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 162: UPDATE ap_prepay_history_all aph

158: SET bc_event_id = NULL
159: WHERE bc_event_id = l_events_tab(i).event_id;
160: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_invoice_distributions_all has been updated to NULL:'||SQL%ROWCOUNT);
161:
162: UPDATE ap_prepay_history_all aph
163: SET aph.bc_event_id = NULL
164: WHERE aph.bc_event_id = l_events_tab(i).event_id;
165: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_history_all has been updated to NULL:'||SQL%ROWCOUNT);
166:

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

161:
162: UPDATE ap_prepay_history_all aph
163: SET aph.bc_event_id = NULL
164: WHERE aph.bc_event_id = l_events_tab(i).event_id;
165: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_history_all has been updated to NULL:'||SQL%ROWCOUNT);
166:
167: UPDATE ap_prepay_app_dists apad
168: SET apad.bc_event_id = NULL
169: WHERE apad.bc_event_id = l_events_tab(i).event_id;

Line 451: FROM ap_prepay_history_all aph

447: AND NOT EXISTS (SELECT 'not exists'
448: FROM ap_invoice_distributions_all aid
449: WHERE aid.bc_event_id = xe.event_id)
450: AND NOT EXISTS (SELECT 'not exists'
451: FROM ap_prepay_history_all aph
452: WHERE aph.bc_event_id = xe.event_id)
453: AND NOT EXISTS (SELECT 'not exists'
454: FROM ap_prepay_app_dists apd
455: WHERE apd.bc_event_id = xe.event_id)

Line 1097: UPDATE ap_prepay_history_all aph

1093:
1094:
1095: IF (l_distribution_type = 'PREPAY' AND NVL(p_bc_mode,'P') <> 'C') THEN
1096: --Modified For Bug 7229803
1097: UPDATE ap_prepay_history_all aph
1098: SET aph.bc_event_id = l_event_id
1099: WHERE aph.invoice_id = p_tab_fc_dist(i).invoice_id
1100: AND transaction_type = l_event_type_code
1101: AND (aph.bc_event_id IS NULL OR aph.bc_event_id = p_tab_fc_dist(i).bc_event_id)

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

1101: AND (aph.bc_event_id IS NULL OR aph.bc_event_id = p_tab_fc_dist(i).bc_event_id)
1102: AND aph.prepay_history_id = (SELECT MAX(prepay_history_id)
1103: FROM ap_prepay_app_dists apd
1104: WHERE prepay_app_distribution_id = p_tab_fc_dist(i).inv_distribution_id);
1105: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_history_all: ' || SQL%ROWCOUNT);
1106:
1107: UPDATE ap_prepay_app_dists apad
1108: SET apad.bc_event_id = l_event_id
1109: WHERE apad.prepay_app_distribution_id = p_tab_fc_dist(i).inv_distribution_id