eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_AP_BC_PVT dependencies on AP_PREPAY_HISTORY_ALL

Line 148: UPDATE ap_prepay_history_all aph

144: SET bc_event_id = NULL
145: WHERE bc_event_id = l_events_tab(i).event_id;
146: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_invoice_distributions_all has been updated to NULL:'||SQL%ROWCOUNT);
147:
148: UPDATE ap_prepay_history_all aph
149: SET aph.bc_event_id = NULL
150: WHERE aph.bc_event_id = l_events_tab(i).event_id;
151: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_history_all has been updated to NULL:'||SQL%ROWCOUNT);
152:

Line 151: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_history_all has been updated to NULL:'||SQL%ROWCOUNT);

147:
148: UPDATE ap_prepay_history_all aph
149: SET aph.bc_event_id = NULL
150: WHERE aph.bc_event_id = l_events_tab(i).event_id;
151: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_history_all has been updated to NULL:'||SQL%ROWCOUNT);
152:
153: UPDATE ap_prepay_app_dists apad
154: SET apad.bc_event_id = NULL
155: WHERE apad.bc_event_id = l_events_tab(i).event_id;

Line 618: UPDATE ap_prepay_history_all aph

614: IF (l_distribution_type = 'PREPAY' AND
615: NVL(p_bc_mode,'P') <> 'C') THEN
616:
617: --Modified For Bug 7229803
618: UPDATE ap_prepay_history_all aph
619: SET aph.bc_event_id = l_event_id
620: WHERE aph.invoice_id = p_tab_fc_dist(i).invoice_id
621: and transaction_type = l_event_type_code
622: AND (aph.bc_event_id IS NULL or

Line 627: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_history_all: ' || SQL%ROWCOUNT);

623: aph.bc_event_id = p_tab_fc_dist(i).bc_event_id)
624: AND aph.prepay_history_id = (select max(prepay_history_id)
625: from ap_prepay_app_dists apd
626: where prepay_app_distribution_id = p_tab_fc_dist(i).inv_distribution_id);
627: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_history_all: ' || SQL%ROWCOUNT);
628:
629: UPDATE ap_prepay_app_dists apad
630: SET apad.bc_event_id = l_event_id
631: WHERE apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id