APPS.INVUPD2B dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 5680: FROM mtl_item_revisions_interface rev

5676: --2808277 : Revision update support
5677: CURSOR C_rev_processed_records
5678: IS
5679: SELECT rev.*, rev.rowid
5680: FROM mtl_item_revisions_interface rev
5681: WHERE( rev.set_process_id = xset_id
5682: OR rev.set_process_id = xset_id + 1000000000000 )
5683: AND rev.transaction_type = 'UPDATE'
5684: AND rev.process_flag = 4;

Line 7174: UPDATE mtl_item_revisions_interface

7170: END LOOP;
7171:
7172: EXCEPTION
7173: WHEN resource_busy THEN
7174: UPDATE mtl_item_revisions_interface
7175: SET process_flag = 3,
7176: request_id = req_id,
7177: PROGRAM_APPLICATION_ID = prg_appid,
7178: PROGRAM_ID = prg_id,

Line 7230: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';

7226: and transaction_type in ('UPDATE','AUTO_CHILD')
7227: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
7228:
7229: --2808277 : Start Revision Update support
7230: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
7231:
7232: update MTL_ITEM_REVISIONS_INTERFACE
7233: set process_flag = 7,
7234: request_id = nvl(request_id,req_id),

Line 7232: update MTL_ITEM_REVISIONS_INTERFACE

7228:
7229: --2808277 : Start Revision Update support
7230: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
7231:
7232: update MTL_ITEM_REVISIONS_INTERFACE
7233: set process_flag = 7,
7234: request_id = nvl(request_id,req_id),
7235: program_application_id = nvl(program_application_id,prg_appid),
7236: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),