DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 2519: FROM mtl_item_revisions_interface

2515: ,lifecycle_id
2516: ,current_phase_id
2517: ,transaction_id
2518: ,rowid
2519: FROM mtl_item_revisions_interface
2520: WHERE (set_process_id = p_set_id OR set_process_id = p_set_id + 1000000000000)
2521: AND transaction_type = 'UPDATE'
2522: AND process_flag = 4;
2523:

Line 2763: UPDATE mtl_item_revisions_interface

2759: END IF;
2760:
2761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2762:
2763: UPDATE mtl_item_revisions_interface
2764: SET process_flag = 3
2765: WHERE rowid = cur.rowid;
2766:
2767: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2777: ,'MTL_ITEM_REVISIONS_INTERFACE'

2773: ,P_Request_Id
2774: ,cur.transaction_id
2775: ,l_msg_text
2776: ,l_column_name
2777: ,'MTL_ITEM_REVISIONS_INTERFACE'
2778: ,'INV_IOI_ERR_C_ITM_LC_DEPND_02'--bug 11894684, replace INV_IOI_ERR
2779: ,err_text);
2780: END IF;
2781: END LOOP;