APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on FND_GLOBAL

Line 504: , LAST_UPDATED_BY = FND_GLOBAL.user_id

500: IF (l_rcv_pending_clubbed_trx_tbl(rcv_error_trx_ids(k)).transaction_id = l_rcv_pending_trx_tbl(i).transaction_id) THEN
501: UPDATE rcv_staging_table
502: SET status = 'CL_ERROR'
503: , LAST_UPDATE_DATE = sysdate
504: , LAST_UPDATED_BY = FND_GLOBAL.user_id
505: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
506: WHERE transaction_id = l_rcv_pending_trx_tbl(i).clubbed_transaction_id
507: AND team = g_team_name;
508: ELSIF (l_rcv_pending_clubbed_trx_tbl(rcv_error_trx_ids(k)).transaction_id = l_rcv_pending_trx_tbl(i).clubbed_transaction_id) THEN

Line 505: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

501: UPDATE rcv_staging_table
502: SET status = 'CL_ERROR'
503: , LAST_UPDATE_DATE = sysdate
504: , LAST_UPDATED_BY = FND_GLOBAL.user_id
505: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
506: WHERE transaction_id = l_rcv_pending_trx_tbl(i).clubbed_transaction_id
507: AND team = g_team_name;
508: ELSIF (l_rcv_pending_clubbed_trx_tbl(rcv_error_trx_ids(k)).transaction_id = l_rcv_pending_trx_tbl(i).clubbed_transaction_id) THEN
509: UPDATE rcv_staging_table

Line 512: , LAST_UPDATED_BY = FND_GLOBAL.user_id

508: ELSIF (l_rcv_pending_clubbed_trx_tbl(rcv_error_trx_ids(k)).transaction_id = l_rcv_pending_trx_tbl(i).clubbed_transaction_id) THEN
509: UPDATE rcv_staging_table
510: SET status = 'CL_ERROR'
511: , LAST_UPDATE_DATE = sysdate
512: , LAST_UPDATED_BY = FND_GLOBAL.user_id
513: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
514: WHERE transaction_id = l_rcv_pending_trx_tbl(i).transaction_id
515: AND team = g_team_name;
516: END IF;

Line 513: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

509: UPDATE rcv_staging_table
510: SET status = 'CL_ERROR'
511: , LAST_UPDATE_DATE = sysdate
512: , LAST_UPDATED_BY = FND_GLOBAL.user_id
513: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
514: WHERE transaction_id = l_rcv_pending_trx_tbl(i).transaction_id
515: AND team = g_team_name;
516: END IF;
517: END LOOP; -- FORALL k IN 1 .. rcv_error_trx_ids.COUNT LOOP

Line 546: , LAST_UPDATED_BY = FND_GLOBAL.user_id

542: l_error_trx_index := rcv_error_trx_ids(i);
543: UPDATE rcv_staging_table
544: SET status = l_rcv_pending_clubbed_trx_tbl(l_error_trx_index).error_status
545: , LAST_UPDATE_DATE = sysdate
546: , LAST_UPDATED_BY = FND_GLOBAL.user_id
547: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
548: WHERE transaction_id = l_rcv_pending_clubbed_trx_tbl(l_error_trx_index).transaction_id
549: AND team = g_team_name;
550: END LOOP;

Line 547: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

543: UPDATE rcv_staging_table
544: SET status = l_rcv_pending_clubbed_trx_tbl(l_error_trx_index).error_status
545: , LAST_UPDATE_DATE = sysdate
546: , LAST_UPDATED_BY = FND_GLOBAL.user_id
547: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
548: WHERE transaction_id = l_rcv_pending_clubbed_trx_tbl(l_error_trx_index).transaction_id
549: AND team = g_team_name;
550: END LOOP;
551: /* vmutyala changed the following code to delete successful records which might have failed in previous attempts Bug 4670527*/

Line 840: , LAST_UPDATED_BY = FND_GLOBAL.user_id

836:
837: -- Update Interlock Shikyu status as Completed in JMF_SUBCONTRACT_ORDERS
838: UPDATE JMF_SUBCONTRACT_ORDERS SET interlock_status = 'C'
839: , LAST_UPDATE_DATE = sysdate
840: , LAST_UPDATED_BY = FND_GLOBAL.user_id
841: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
842: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_po_shipment_id;
843:
844: -- AND NVL(project_id, -1)= NVL(p_project_id, -1)

Line 841: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

837: -- Update Interlock Shikyu status as Completed in JMF_SUBCONTRACT_ORDERS
838: UPDATE JMF_SUBCONTRACT_ORDERS SET interlock_status = 'C'
839: , LAST_UPDATE_DATE = sysdate
840: , LAST_UPDATED_BY = FND_GLOBAL.user_id
841: , LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
842: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_po_shipment_id;
843:
844: -- AND NVL(project_id, -1)= NVL(p_project_id, -1)
845: -- AND NVL(task_id, -1)= NVL(p_task_id, -1);