DBA Data[Home] [Help]

APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_BC_COMMITMENTS

Line 752: UPDATE pa_bc_commitments bc_cm

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

Line 782: UPDATE pa_bc_commitments bc_cm

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