[Home] [Help]
1343: r.CURRENT_PHASE_ID,
1344: r.REVISION_ID,
1345: r.REVISION_LABEL,
1346: r.REVISION_REASON
1347: FROM MTL_ITEM_REVISIONS_INTERFACE R
1348: WHERE r.process_flag = l_process_flag_4
1349: AND r.set_process_id = xset_id
1350: AND r.transaction_type = l_transaction_type;
1351:
1372: r.LAST_UPDATED_BY,
1373: r.LAST_UPDATE_LOGIN,
1374: L.LANGUAGE_CODE,
1375: USERENV('LANG')
1376: FROM MTL_ITEM_REVISIONS_INTERFACE r,
1377: FND_LANGUAGES L
1378: WHERE r.process_flag = l_process_flag_4
1379: AND r.set_process_id = xset_id
1380: AND r.transaction_type = l_transaction_type
1391:
1392: /*NP 22AUG94 Commenting out the code for the following functionality
1393: ** If a master record was inserted for an orphan child record,
1394: ** we need to create a default
1395: ** record in mtl_item_revisions_interface in the
1396: ** master org (which is stored in last_updated_by
1397: ** The TWO-PASS approach makes it irrelevant
1398: ** Note the use of the last_updated_by who column
1399: ** This is initialized in INVPUTLI and holds the master_org_id
1885: LAST_UPDATE_LOGIN = nvl(LAST_UPDATE_LOGIN,login_id)
1886: where process_flag = l_process_flag_4
1887: and set_process_id = xset_id;
1888:
1889: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
1890:
1891: update MTL_ITEM_REVISIONS_INTERFACE
1892: set process_flag = l_process_flag_7,
1893: request_id = nvl(request_id,req_id),
1887: and set_process_id = xset_id;
1888:
1889: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
1890:
1891: update MTL_ITEM_REVISIONS_INTERFACE
1892: set process_flag = l_process_flag_7,
1893: request_id = nvl(request_id,req_id),
1894: program_application_id = nvl(program_application_id,prg_appid),
1895: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),