DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_BC_COMMITMENTS

Line 747: UPDATE pa_bc_commitments bc_cm

743:
744: log_message (' Updating AP commitment records with newly derived open gl_date for corresponding BTC/TBC CDL');
745:
746: FORALL i IN 1..g_expenditure_item_id.count
747: UPDATE pa_bc_commitments bc_cm
748: SET bc_cm.request_id = g_request_id,
749: bc_cm.transferred_date = SYSDATE,
750: bc_cm.liquidate_gl_date = g_gl_date_new_tab(i)
751: WHERE ( bc_cm.document_header_id,bc_cm.document_distribution_id,expenditure_type)

Line 777: UPDATE pa_bc_commitments bc_cm

773:
774: log_message (' Updating PO commitment records with newly derived open gl_date for corresponding BTC/TBC CDL');
775:
776: FORALL i IN 1..g_expenditure_item_id.count
777: UPDATE pa_bc_commitments bc_cm
778: SET bc_cm.request_id = g_request_id,
779: bc_cm.transferred_date = SYSDATE,
780: bc_cm.liquidate_gl_date = g_gl_date_new_tab(i)
781: WHERE (bc_cm.exp_item_id,bc_cm.expenditure_type)