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_BC_XML_REPORT_PUB dependencies on PSA_BC_REPORT_EVENTS_GT

Line 162: -- Cursor is used to print data from psa_bc_report_events_gt

158: x_report_query VARCHAR2(32000) DEFAULT NULL;
159: l_query VARCHAR2(32000) DEFAULT NULL;
160: l_trxs CLOB;
161:
162: -- Cursor is used to print data from psa_bc_report_events_gt
163: -- as entered by product teams. This is useful for debugging.
164:
165: CURSOR get_report_events_gt IS
166: SELECT event_id,

Line 174: FROM psa_bc_report_events_gt;

170: source_distribution_id_num_2,
171: source_distribution_id_num_3,
172: source_distribution_id_num_4,
173: source_distribution_id_num_5
174: FROM psa_bc_report_events_gt;
175:
176: BEGIN
177: l_api_name := g_full_path||'create_bc_transaction_report';
178: errbuf := NULL;

Line 188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');

184: psa_utils.debug_other_string(g_state_level,l_api_name,'p_application_id' || ' = ' || p_application_id);
185: psa_utils.debug_other_string(g_state_level,l_api_name,'p_packet_event_flag' || ' = ' || p_packet_event_flag);
186: psa_utils.debug_other_string(g_state_level,l_api_name,'p_sequence_id' || ' = ' || p_sequence_id);
187:
188: psa_utils.debug_other_string(g_state_level,l_api_name, 'PSA_BC_REPORT_EVENTS_GT');
189: psa_utils.debug_other_string(g_state_level,l_api_name, '========================');
190:
191: FOR x in get_report_events_gt
192: LOOP

Line 303: FROM psa_bc_report_events_gt;

299: source_distribution_id_num_2,
300: source_distribution_id_num_3,
301: source_distribution_id_num_4,
302: source_distribution_id_num_5
303: FROM psa_bc_report_events_gt;
304:
305: CURSOR get_coaid (p_ledgerid IN NUMBER) IS
306: SELECT chart_of_accounts_id
307: FROM gl_ledgers

Line 333: FROM psa_bc_report_events_gt psagt,

329: sum(decode(event_class_code, 'PO_PA', 1, 0)) PO_PA,
330: sum(decode(event_class_code, 'REQUISITION', 1, 0)) REQ,
331: sum(decode(event_class_code, 'RELEASE', 1, 0)) RELEASE
332: FROM ( SELECT distinct xdl.event_class_code
333: FROM psa_bc_report_events_gt psagt,
334: xla_distribution_links xdl
335: WHERE xdl.application_id = p_para_rec.application_id AND
336: xdl.event_id = psagt.event_id
337: );

Line 483: FROM PSA_BC_REPORT_EVENTS_GT PSAGT,

479: PS.application_id = p_para_rec.application_id AND
480: (XAE.event_date between PS.start_date AND PS.end_date) AND
481: ((x_source = 'FORM' AND
482: EXISTS (SELECT 'x'
483: FROM PSA_BC_REPORT_EVENTS_GT PSAGT,
484: GL_BC_PACKETS glb
485: WHERE PSAGT.packet_id = glb.packet_id
486: AND glb.event_id = XAE.event_id
487: UNION

Line 489: FROM PSA_BC_REPORT_EVENTS_GT PSAGT

485: WHERE PSAGT.packet_id = glb.packet_id
486: AND glb.event_id = XAE.event_id
487: UNION
488: SELECT 'x'
489: FROM PSA_BC_REPORT_EVENTS_GT PSAGT
490: WHERE PSAGT.event_id = XAE.event_id))
491: OR (x_source = 'CP' AND (PS.period_year = l_period_year) AND PS.period_num BETWEEN l_period_start_num AND l_period_end_num)); -- Bug 8966506
492:
493: -- This Cursor has been added for performance reasons. Query for summary rows is complex and takes time to execute.

Line 729: -- Bug 9200360 : Populating PSA_BC_REPORT_EVENTS_GT when the x_source is CP

725: --Raise GET_QUALIFIER_SEGNUM_EXCEP;
726: NULL;
727: END IF;
728:
729: -- Bug 9200360 : Populating PSA_BC_REPORT_EVENTS_GT when the x_source is CP
730: IF x_source = 'CP' THEN
731:
732: -- The following should ideally return no records in the fnd_logs
733: FOR x_rep_eve in get_report_events_gt

Line 747: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)

743: END LOOP;
744:
745: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS');
746:
747: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
748: SELECT DISTINCT packet_id
749: FROM GL_BC_PACKETS pkts
750: WHERE pkts.period_year = l_period_year
751: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;

Line 755: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)

751: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;
752:
753: psa_utils.debug_other_string(g_state_level,l_api_name, 'Fetching records from GL_BC_PACKETS_HISTS');
754:
755: INSERT INTO PSA_BC_REPORT_EVENTS_GT (packet_id)
756: SELECT DISTINCT packet_id
757: FROM GL_BC_PACKETS_HISTS pkts
758: WHERE pkts.period_year = l_period_year
759: AND pkts.period_num BETWEEN l_period_start_num AND l_period_end_num;

Line 766: INSERT INTO psa_bc_report_events_gt

762:
763: ELSE
764: --Bug 9881400
765: --First Insert all the packet_id data
766: INSERT INTO psa_bc_report_events_gt
767: (
768: packet_id
769: )
770: SELECT DISTINCT b.packet_id

Line 772: psa_bc_report_events_gt r

768: packet_id
769: )
770: SELECT DISTINCT b.packet_id
771: FROM gl_bc_packets b,
772: psa_bc_report_events_gt r
773: WHERE b.event_id = r.event_id;
774:
775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Inserted records into psa_bc_report_events_gt: '||SQL%ROWCOUNT);
776:

Line 775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Inserted records into psa_bc_report_events_gt: '||SQL%ROWCOUNT);

771: FROM gl_bc_packets b,
772: psa_bc_report_events_gt r
773: WHERE b.event_id = r.event_id;
774:
775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Inserted records into psa_bc_report_events_gt: '||SQL%ROWCOUNT);
776:
777: IF (SQL%ROWCOUNT <> 0) THEN
778: --Next Delete all rows that have packet_id null
779: DELETE psa_bc_report_events_gt r

Line 779: DELETE psa_bc_report_events_gt r

775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Inserted records into psa_bc_report_events_gt: '||SQL%ROWCOUNT);
776:
777: IF (SQL%ROWCOUNT <> 0) THEN
778: --Next Delete all rows that have packet_id null
779: DELETE psa_bc_report_events_gt r
780: WHERE r.packet_id IS NULL;
781:
782: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (NULL): '||SQL%ROWCOUNT);
783:

Line 782: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (NULL): '||SQL%ROWCOUNT);

778: --Next Delete all rows that have packet_id null
779: DELETE psa_bc_report_events_gt r
780: WHERE r.packet_id IS NULL;
781:
782: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (NULL): '||SQL%ROWCOUNT);
783:
784: --Next Delete all rows that have duplicate packet_id
785: DELETE psa_bc_report_events_gt r1
786: WHERE ROWID NOT IN (SELECT MAX(ROWID)

Line 785: DELETE psa_bc_report_events_gt r1

781:
782: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (NULL): '||SQL%ROWCOUNT);
783:
784: --Next Delete all rows that have duplicate packet_id
785: DELETE psa_bc_report_events_gt r1
786: WHERE ROWID NOT IN (SELECT MAX(ROWID)
787: FROM psa_bc_report_events_gt r2
788: WHERE r1.packet_id = r2.packet_id);
789:

Line 787: FROM psa_bc_report_events_gt r2

783:
784: --Next Delete all rows that have duplicate packet_id
785: DELETE psa_bc_report_events_gt r1
786: WHERE ROWID NOT IN (SELECT MAX(ROWID)
787: FROM psa_bc_report_events_gt r2
788: WHERE r1.packet_id = r2.packet_id);
789:
790: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (DUP): '||SQL%ROWCOUNT);
791: END IF;

Line 790: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (DUP): '||SQL%ROWCOUNT);

786: WHERE ROWID NOT IN (SELECT MAX(ROWID)
787: FROM psa_bc_report_events_gt r2
788: WHERE r1.packet_id = r2.packet_id);
789:
790: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleted records from psa_bc_report_events_gt (DUP): '||SQL%ROWCOUNT);
791: END IF;
792:
793: END IF;
794:

Line 912: PSA_BC_REPORT_EVENTS_GT PBRE

908: NULL DOCUMENT_STATUS
909: BULK COLLECT INTO l_dump
910: FROM PSA_BC_REPORT_V PBRV,
911: GL_JE_HEADERS JH,
912: PSA_BC_REPORT_EVENTS_GT PBRE
913: WHERE PBRV.je_header_id = JH.je_header_id(+) AND
914: PBRV.ledger_id = p_para_rec.ledger_id AND
915: --PBRV.application_id = 101 AND -- Bug 9138667 : Commented out the filter by application id
916: PBRV.template_id IS NULL AND

Line 917: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

913: WHERE PBRV.je_header_id = JH.je_header_id(+) AND
914: PBRV.ledger_id = p_para_rec.ledger_id AND
915: --PBRV.application_id = 101 AND -- Bug 9138667 : Commented out the filter by application id
916: PBRV.template_id IS NULL AND
917: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
918:
919: psa_utils.debug_other_string(g_state_level,l_api_name,'GL Query returned '||sql%rowcount||' rows.');
920:
921: populate_tab;

Line 1053: PSA_BC_REPORT_EVENTS_GT PBRE

1049: AP_INVOICES AI,
1050: AP_INVOICE_LINES AIL,
1051: PO_VENDORS PV,
1052: PO_VENDOR_SITES PVS,
1053: PSA_BC_REPORT_EVENTS_GT PBRE
1054: WHERE PBRV.source_distribution_id_num_1 = AID.invoice_distribution_id AND
1055: AID.invoice_id = AI.invoice_id AND
1056: AID.batch_id = APB.batch_id(+) AND
1057: AI.vendor_id = PV.vendor_id(+) AND

Line 1081: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

1077: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
1078: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
1079: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
1080: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
1081: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
1082: */
1083:
1084: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 1 returned '||sql%rowcount||' rows.');
1085:

Line 1212: PSA_BC_REPORT_EVENTS_GT PBRE

1208: AP_INVOICES AI,
1209: AP_INVOICE_LINES AIL,
1210: PO_VENDORS PV,
1211: PO_VENDOR_SITES PVS,
1212: PSA_BC_REPORT_EVENTS_GT PBRE
1213: WHERE PBRV.source_distribution_id_num_1 = APD.prepay_app_distribution_id AND
1214: AID.invoice_distribution_id = APD.invoice_distribution_id AND
1215: AID.invoice_id = AI.invoice_id AND
1216: AID.batch_id = APB.batch_id(+) AND

Line 1240: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

1236: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
1237: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
1238: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
1239: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
1240: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
1241: */
1242: psa_utils.debug_other_string(g_state_level,l_api_name,'AP Query 2 returned '||sql%rowcount||' rows.');
1243:
1244: populate_tab;

Line 1382: PSA_BC_REPORT_EVENTS_GT PBRE

1378: PO_HEADERS PH,
1379: PO_LINES PL,
1380: PO_DISTRIBUTIONS PD,
1381: PO_LINE_LOCATIONS PLL,
1382: PSA_BC_REPORT_EVENTS_GT PBRE
1383: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1384: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1385: PBRV.event_id = PBD.ae_event_id AND
1386: PBRV.application_id = XDL.application_id AND

Line 1411: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

1407: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
1408: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
1409: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
1410: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
1411: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
1412: */
1413: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 1 returned '||sql%rowcount||' rows.');
1414:
1415: populate_tab;

Line 1541: PSA_BC_REPORT_EVENTS_GT PBRE

1537: PO_VENDOR_SITES PVS,
1538: PO_REQUISITION_HEADERS PRH,
1539: PO_REQUISITION_LINES PRL,
1540: PO_REQ_DISTRIBUTIONS PRD,
1541: PSA_BC_REPORT_EVENTS_GT PBRE
1542: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1543: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1544: PBRV.event_id = PBD.ae_event_id AND
1545: PBRV.application_id = XDL.application_id AND

Line 1568: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

1564: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
1565: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
1566: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
1567: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
1568: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
1569: */
1570: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 2 returned '||sql%rowcount||' rows.');
1571:
1572: populate_tab;

Line 1707: PSA_BC_REPORT_EVENTS_GT PBRE

1703: PO_RELEASES PR,
1704: PO_LINES PL,
1705: PO_DISTRIBUTIONS PD,
1706: PO_LINE_LOCATIONS PLL,
1707: PSA_BC_REPORT_EVENTS_GT PBRE
1708: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1709: PBRV.source_distribution_id_num_1 = PBD.distribution_id AND
1710: decode(pbd.distribution_type,
1711: 'REQUISITION', 'PO_REQ_DISTRIBUTIONS_ALL',

Line 1741: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

1737: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
1738: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
1739: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
1740: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
1741: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
1742: */
1743: psa_utils.debug_other_string(g_state_level,l_api_name,'PO Query 3 returned '||sql%rowcount||' rows.');
1744:
1745: populate_tab;

Line 1996: PSA_BC_REPORT_EVENTS_GT PBRE

1992: XLA_DISTRIBUTION_LINKS XLADIST,
1993: FV_BE_TRX_HDRS BE,
1994: FV_BE_TRX_DTLS BET,
1995: FV_BE_RPR_TRANSACTIONS RPR,
1996: PSA_BC_REPORT_EVENTS_GT PBRE
1997: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
1998: PBRV.application_id = 8901 AND
1999: PBRV.application_id = XLADIST.application_id AND
2000: PBRV.source_distribution_id_num_1 = XLADIST.source_distribution_id_num_1 AND

Line 2019: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

2015: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
2016: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
2017: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
2018: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
2019: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2020: */
2021: psa_utils.debug_other_string(g_state_level,l_api_name,'FV Query returned '||sql%rowcount||' rows.');
2022:
2023: populate_tab;

Line 2142: PSA_BC_REPORT_EVENTS_GT PBRE

2138: PBRV.CURRENT_FUNDS_AVAILABLE,
2139: NULL DOCUMENT_STATUS
2140: BULK COLLECT INTO l_dump
2141: FROM PSA_BC_REPORT_V PBRV,
2142: PSA_BC_REPORT_EVENTS_GT PBRE
2143: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
2144: PBRV.application_id = p_para_rec.application_id AND
2145: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2146:

Line 2145: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

2141: FROM PSA_BC_REPORT_V PBRV,
2142: PSA_BC_REPORT_EVENTS_GT PBRE
2143: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
2144: PBRV.application_id = p_para_rec.application_id AND
2145: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2146:
2147:
2148: psa_utils.debug_other_string(g_state_level,l_api_name,'PSB Query returned '||sql%rowcount||' rows.');
2149:

Line 2268: PSA_BC_REPORT_EVENTS_GT PBRE

2264: PBRV.CURRENT_FUNDS_AVAILABLE,
2265: NULL DOCUMENT_STATUS
2266: BULK COLLECT INTO l_dump
2267: FROM PSA_BC_REPORT_V PBRV,
2268: PSA_BC_REPORT_EVENTS_GT PBRE
2269: WHERE PBRV.ledger_id = p_para_rec.ledger_id AND
2270: PBRV.application_id = p_para_rec.application_id AND
2271: PBRV.packet_id = PBRE.packet_id;
2272: /*

Line 2283: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

2279: --NVL(PBRE.source_distribution_id_num_2,0) = NVL(PBRV.source_distribution_id_num_2,0) AND
2280: --NVL(PBRE.source_distribution_id_num_3,0) = NVL(PBRV.source_distribution_id_num_3,0) AND
2281: --NVL(PBRE.source_distribution_id_num_4,0) = NVL(PBRV.source_distribution_id_num_4,0) AND
2282: --NVL(PBRE.source_distribution_id_num_5,0) = NVL(PBRV.source_distribution_id_num_5,0)
2283: )); -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2284: */
2285: psa_utils.debug_other_string(g_state_level,l_api_name,'Other Query returned '||sql%rowcount||' rows.');
2286:
2287: populate_tab;

Line 2311: where packet_id in (select packet_id from psa_bc_report_events_gt)

2307: IF p_para_rec.packet_event_flag = 'P' THEN
2308: select EVENT_ID
2309: into l_event_id
2310: from gl_bc_packets
2311: where packet_id in (select packet_id from psa_bc_report_events_gt)
2312: and template_id is NULL
2313: and rownum = 1;
2314: END IF;
2315: psa_utils.debug_other_string(g_state_level,l_api_name,'l_event_id = ' || l_event_id);

Line 2432: PSA_BC_REPORT_EVENTS_GT PBRE

2428: PBRV.CURRENT_FUNDS_AVAILABLE CURRENT_FUNDS_AVAILABLE,
2429: NULL DOCUMENT_STATUS
2430: BULK COLLECT INTO l_dump
2431: FROM PSA_BC_REPORT_V PBRV,
2432: PSA_BC_REPORT_EVENTS_GT PBRE
2433: WHERE PBRV.packet_id = PBRE.packet_id
2434: and template_id is NULL; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2435:
2436: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query1 returned '||sql%rowcount||' rows.');

Line 2434: and template_id is NULL; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

2430: BULK COLLECT INTO l_dump
2431: FROM PSA_BC_REPORT_V PBRV,
2432: PSA_BC_REPORT_EVENTS_GT PBRE
2433: WHERE PBRV.packet_id = PBRE.packet_id
2434: and template_id is NULL; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2435:
2436: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query1 returned '||sql%rowcount||' rows.');
2437:
2438: populate_tab;

Line 2557: PSA_BC_REPORT_EVENTS_GT PBRE

2553: BULK COLLECT INTO l_dump
2554: FROM PSA_BC_REPORT_V PBRV,
2555: XLA_AE_HEADERS XAH,
2556: XLA_DISTRIBUTION_LINKS XDL,
2557: PSA_BC_REPORT_EVENTS_GT PBRE
2558: WHERE PBRV.application_id = XDL.application_id AND
2559: PBRV.event_id = XDL.event_id AND
2560: PBRV.ae_header_id = XDL.ae_header_id AND
2561: PBRV.ae_line_num = XDL.ae_line_num AND

Line 2567: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause

2563: PBRV.application_id = XAH.application_id AND
2564: PBRV.ae_header_id = XAH.ae_header_id AND
2565: PBRV.ledger_id = p_para_rec.ledger_id AND
2566: PBRV.application_id = p_para_rec.application_id AND
2567: PBRV.packet_id = PBRE.packet_id; -- Bug 9200360 : Moved PSA_BC_REPORT_EVENTS_GT to the FROM clause
2568:
2569: psa_utils.debug_other_string(g_state_level,l_api_name,'XLA Manual journals Query2 returned '||sql%rowcount||' rows.');
2570:
2571: populate_tab;

Line 2772: -- Bug 9200360 : Deleting the populated records in PSA_BC_REPORT_EVENTS_GT

2768: VALUES l_bc_summary_rpt(i);
2769:
2770: END IF;
2771:
2772: -- Bug 9200360 : Deleting the populated records in PSA_BC_REPORT_EVENTS_GT
2773: IF x_source = 'CP' THEN
2774:
2775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleting records in PSA_BC_REPORT_EVENTS_GT');
2776:

Line 2775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleting records in PSA_BC_REPORT_EVENTS_GT');

2771:
2772: -- Bug 9200360 : Deleting the populated records in PSA_BC_REPORT_EVENTS_GT
2773: IF x_source = 'CP' THEN
2774:
2775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleting records in PSA_BC_REPORT_EVENTS_GT');
2776:
2777: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
2778:
2779: psa_utils.debug_other_string(g_state_level,l_api_name, 'End of deleting records in PSA_BC_REPORT_EVENTS_GT');

Line 2777: DELETE FROM PSA_BC_REPORT_EVENTS_GT;

2773: IF x_source = 'CP' THEN
2774:
2775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleting records in PSA_BC_REPORT_EVENTS_GT');
2776:
2777: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
2778:
2779: psa_utils.debug_other_string(g_state_level,l_api_name, 'End of deleting records in PSA_BC_REPORT_EVENTS_GT');
2780:
2781: END IF;

Line 2779: psa_utils.debug_other_string(g_state_level,l_api_name, 'End of deleting records in PSA_BC_REPORT_EVENTS_GT');

2775: psa_utils.debug_other_string(g_state_level,l_api_name, 'Deleting records in PSA_BC_REPORT_EVENTS_GT');
2776:
2777: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
2778:
2779: psa_utils.debug_other_string(g_state_level,l_api_name, 'End of deleting records in PSA_BC_REPORT_EVENTS_GT');
2780:
2781: END IF;
2782:
2783: psa_utils.debug_other_string(g_state_level,l_api_name,'Summary Query returned '||sql%rowcount||' rows.');