APPS.PSA_AP_BC_PVT dependencies on PSA_BC_XLA_EVENTS_GT

Line 802: DELETE from psa_bc_xla_events_gt;

798:
799: ----------------------------------------------------------------------
800: -- Bug 5160179: clear the temporary gt table before inserting any rows
801: ----------------------------------------------------------------------
802: DELETE from psa_bc_xla_events_gt;
803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;

Line 803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

799: ----------------------------------------------------------------------
800: -- Bug 5160179: clear the temporary gt table before inserting any rows
801: ----------------------------------------------------------------------
802: DELETE from psa_bc_xla_events_gt;
803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;
807: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

Line 1141: INSERT INTO psa_bc_xla_events_gt

1137: END IF;
1138:
1139: FOR i IN 1..l_bc_event_count LOOP
1140: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
1141: INSERT INTO psa_bc_xla_events_gt
1142: (
1143: event_id,
1144: result_code
1145: )

Line 1151: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

1147: (
1148: l_bc_event_tab(i).event_id,
1149: 'XLA_UNPROCESSED'
1150: );
1151: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
1152: END LOOP;
1153:
1154:
1155: IF (p_bc_mode <> 'C') THEN

Line 1254: FROM psa_bc_xla_events_gt e,

1250: SELECT DECODE(MIN(p.status_code),'A', 'S', 'F'),
1251: MIN(p.status_code)
1252: INTO p_tab_fc_dist(i).result_code,
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

Line 1281: FROM psa_bc_xla_events_gt e,

1277: SELECT DECODE(MIN(p.status_code),'A', 'S', 'F'),
1278: MIN(p.status_code)
1279: INTO p_tab_fc_dist(i).result_code,
1280: p_tab_fc_dist(i).status_code
1281: FROM psa_bc_xla_events_gt e,
1282: gl_bc_packets p,
1283: xla_distribution_links xdl
1284: WHERE xdl.event_id = e.event_id
1285: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id

Line 1426: psa_bc_xla_events_gt e

1422: FROM gl_lookups l
1423: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1424: AND EXISTS ( SELECT 'x'
1425: FROM gl_bc_packets bc,
1426: psa_bc_xla_events_gt e
1427: WHERE bc.event_id = e.event_id
1428: AND bc.result_code like 'F%'
1429: AND bc.result_code = l.lookup_code)
1430: AND rownum = 1;