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 153: UPDATE ap_prepay_app_dists apad

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

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

Line 625: from ap_prepay_app_dists apd

621: and transaction_type = l_event_type_code
622: AND (aph.bc_event_id IS NULL or
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

Line 629: UPDATE ap_prepay_app_dists apad

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
632: AND (apad.bc_event_id IS NULL or
633: apad.bc_event_id = p_tab_fc_dist(i).bc_event_id);

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

630: SET apad.bc_event_id = l_event_id
631: WHERE apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id
632: AND (apad.bc_event_id IS NULL or
633: apad.bc_event_id = p_tab_fc_dist(i).bc_event_id);
634: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_prepay_app_dists: ' || SQL%ROWCOUNT);
635: END IF;
636: IF nvl(p_tab_fc_dist(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
637: UPDATE ap_invoice_distributions_all aid
638: SET bc_event_id = l_event_id

Line 776: ap_prepay_app_dists apad

772: p_tab_fc_dist(i).status_code
773: FROM psa_bc_xla_events_gt e,
774: gl_bc_packets p,
775: xla_distribution_links xdl,
776: ap_prepay_app_dists apad
777: WHERE xdl.event_id = e.event_id
778: AND apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id
779: AND xdl.source_distribution_id_num_1 = APAD.Prepay_App_Dist_ID
780: AND apad.bc_event_id = xdl.event_id