DBA Data[Home] [Help]

APPS.RCV_INSPECTION_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;

211: l_source_doc_quantity NUMBER;
212: l_primary_quantity NUMBER;
213:
214: -- Bug 5018102
215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;
216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;
217: BEGIN
218:
219: --dbms_output.enable('1000000');

Line 216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;

212: l_primary_quantity NUMBER;
213:
214: -- Bug 5018102
215: l_project_id RCV_TRANSACTIONS_INTERFACE.PROJECT_ID%TYPE;
216: l_task_id RCV_TRANSACTIONS_INTERFACE.TASK_ID%TYPE;
217: BEGIN
218:
219: --dbms_output.enable('1000000');
220: -- Standard Start of API savepoint

Line 461: UPDATE rcv_transactions_interface

457: WHERE transaction_id = p_transaction_id;
458:
459: IF l_project_id IS NOT NULL THEN
460:
461: UPDATE rcv_transactions_interface
462: SET project_id = l_project_id
463: , task_id = l_task_id
464: WHERE interface_transaction_id = l_interface_id;
465: