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_APP_DISTS

Line 167: UPDATE ap_prepay_app_dists apad

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;
170: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_app_dists has been updated to NULL:'||SQL%ROWCOUNT);
171:

Line 170: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_app_dists 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;
170: psa_utils.debug_other_string(g_state_level,l_api_name,'# distributions in ap_prepay_app_dists has been updated to NULL:'||SQL%ROWCOUNT);
171:
172: END LOOP;
173: END IF;
174: fnd_file.put_line(fnd_file.log ,'Count of BC events deleted:' || l_event_count);

Line 454: FROM ap_prepay_app_dists apd

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)
456: AND NOT EXISTS (SELECT 'not exists'
457: FROM ap_self_assessed_tax_dist_all aps
458: WHERE aps.bc_event_id = xe.event_id)

Line 953: UPDATE ap_prepay_app_dists apad

949: bc_event_id = null
950: WHERE invoice_distribution_id = l_PrepayProcessTab(i).inv_distribution_id;
951: psa_utils.debug_other_string(g_state_level,l_api_name,'No of prepay distributiuon encumbered set to R = '||SQL%ROWCOUNT);
952:
953: UPDATE ap_prepay_app_dists apad
954: SET apad.bc_event_id = NULL
955: WHERE apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id
956: AND apad.bc_event_id = p_tab_fc_dist(i).bc_event_id;
957: psa_utils.debug_other_string(g_state_level,l_api_name,'No of prepay app distributiuon bc_event set to null = '||SQL%ROWCOUNT);

Line 1103: FROM ap_prepay_app_dists apd

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)
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

Line 1107: UPDATE ap_prepay_app_dists apad

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
1110: AND (apad.bc_event_id IS NULL OR apad.bc_event_id = p_tab_fc_dist(i).bc_event_id);
1111: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_app_dists: ' || SQL%ROWCOUNT);

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

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
1110: AND (apad.bc_event_id IS NULL OR apad.bc_event_id = p_tab_fc_dist(i).bc_event_id);
1111: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_app_dists: ' || SQL%ROWCOUNT);
1112: END IF;
1113:
1114: IF nvl(p_tab_fc_dist(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1115: UPDATE ap_invoice_distributions_all aid

Line 1257: ap_prepay_app_dists apad

1253: p_tab_fc_dist(i).status_code
1254: FROM psa_bc_xla_events_gt e,
1255: gl_bc_packets p,
1256: xla_distribution_links xdl,
1257: ap_prepay_app_dists apad
1258: WHERE xdl.event_id = e.event_id
1259: AND apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id
1260: AND xdl.source_distribution_id_num_1 = APAD.Prepay_App_Dist_ID
1261: AND apad.bc_event_id = xdl.event_id