Zafar

If we want to build a Custom Web ADI using custom table or standard table.  Or we want to define a custom dff or custom kff on a custom form then just creating a table may not be enough.  We also need to register this table so that the entry for this table exists in fnd_tables.  And the entries for its columns exist in fnd_columns table.  By using the below procedure we can define a concurrent program and run it by passing the input parameters of the concurrent program as table name.  When this concurrent program completes normal it would have registered the table and all its columns by using a standard API ad_dd.  This program can be rerun any number of times, especially if there are new columns are created or modified. This program will delete the entries and register it again.  CREATE OR REPLACE PROCEDURE xxregtc (errbuf       OUT VARCHAR2,                         ...

UPDATE fnd_concurrent_requests    SET phase_code = 'C', status_code = 'X'  WHERE     status_code IN ('Q', 'I')        AND requested_start_date > SYSDATE        AND hold_flag = 'N'        AND (phase_code <> 'C' OR status_code <> 'X') /

CREATE OR REPLACE FORCE VIEW apps.XX_timesheet AS      SELECT a."OBJECTTYPE",             a."USER_DEFINE_NAME",             a."SHORT_NAME_OR_STATUS",             a."DESCRIPTION",             a."APPLICATION_OBJECT_ID",             a."OWNER",             (SELECT user_name                FROM fnd_user fu               WHERE fu.user_id = a.created_by)                created_by,             a."CREATION_DATE"        FROM (SELECT 'Concurrent Programs' objecttype,                     fct.user_concurrent_program_name user_define_name,             ...