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_RESULTS_GT

Line 506: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);

502: UNION ALL
503: SELECT packet_id
504: FROM gl_bc_packets_hists
505: WHERE template_id IS NOT NULL) bc
506: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);
507:
508: CURSOR c_document_status IS
509: SELECT application_name,
510: batch_reference,

Line 522: FROM psa_bc_results_gt

518: sum(decode(funds_check_status_code, 'T', 1, 0)) fatal_count,
519: sum(decode(funds_check_status_code, 'C', 1, 0)) checking_count,
520: sum(decode(funds_check_status_code, 'P', 1, 0)) reserving_count,
521: count(*) total_count
522: FROM psa_bc_results_gt
523: GROUP BY application_name, batch_reference, document_reference, vendor_name, vendor_site_name;
524:
525:
526: TYPE bc_rpt_type IS TABLE OF PSA_BC_RESULTS_GT%ROWTYPE INDEX BY BINARY_INTEGER;

Line 526: TYPE bc_rpt_type IS TABLE OF PSA_BC_RESULTS_GT%ROWTYPE INDEX BY BINARY_INTEGER;

522: FROM psa_bc_results_gt
523: GROUP BY application_name, batch_reference, document_reference, vendor_name, vendor_site_name;
524:
525:
526: TYPE bc_rpt_type IS TABLE OF PSA_BC_RESULTS_GT%ROWTYPE INDEX BY BINARY_INTEGER;
527: l_bc_results_rpt bc_rpt_type;
528: l_dump bc_rpt_type;
529: l_bc_summary_rpt bc_rpt_type;
530: l_sum_dump bc_rpt_type;

Line 2581: DELETE from PSA_BC_RESULTS_GT;

2577:
2578: -- Purge the GT table if it already holds rows. This is possible if report
2579: -- is reinvoked in the same session.
2580:
2581: DELETE from PSA_BC_RESULTS_GT;
2582:
2583: -- Insert all records from PLSQL table l_bc_results_rpt INTO psa_bc_results_rpt_gt
2584:
2585: FORALL i IN 1..l_bc_results_rpt.count

Line 2586: INSERT INTO PSA_BC_RESULTS_GT

2582:
2583: -- Insert all records from PLSQL table l_bc_results_rpt INTO psa_bc_results_rpt_gt
2584:
2585: FORALL i IN 1..l_bc_results_rpt.count
2586: INSERT INTO PSA_BC_RESULTS_GT
2587: VALUES l_bc_results_rpt(i);
2588:
2589: --delete
2590: IF x_source = 'CP' THEN

Line 2591: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleting unwanted rows from PSA_BC_RESULTS_GT to retain the latest Budgetary Control Transaction only');

2587: VALUES l_bc_results_rpt(i);
2588:
2589: --delete
2590: IF x_source = 'CP' THEN
2591: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleting unwanted rows from PSA_BC_RESULTS_GT to retain the latest Budgetary Control Transaction only');
2592:
2593: DELETE PSA_BC_RESULTS_GT GT1
2594: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2595: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)

Line 2593: DELETE PSA_BC_RESULTS_GT GT1

2589: --delete
2590: IF x_source = 'CP' THEN
2591: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleting unwanted rows from PSA_BC_RESULTS_GT to retain the latest Budgetary Control Transaction only');
2592:
2593: DELETE PSA_BC_RESULTS_GT GT1
2594: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2595: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2596: FROM PSA_BC_RESULTS_GT GT2
2597: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);

Line 2596: FROM PSA_BC_RESULTS_GT GT2

2592:
2593: DELETE PSA_BC_RESULTS_GT GT1
2594: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2595: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2596: FROM PSA_BC_RESULTS_GT GT2
2597: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);
2598: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');
2599: END IF;
2600:

Line 2598: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');

2594: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2595: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2596: FROM PSA_BC_RESULTS_GT GT2
2597: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);
2598: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');
2599: END IF;
2600:
2601:
2602: IF p_para_rec.application_id IN (200, 201, 8901, 101) THEN

Line 2721: FROM PSA_BC_RESULTS_GT PBRG,

2717: MIN(PBRG.ERROR_SOURCE),
2718: MIN(PBRV.CURRENT_FUNDS_AVAILABLE),
2719: NULL
2720: BULK COLLECT INTO l_sum_dump
2721: FROM PSA_BC_RESULTS_GT PBRG,
2722: GL_PERIOD_STATUSES PS,
2723: GL_SUMMARY_TEMPLATES ST,
2724: GL_ACCOUNT_HIERARCHIES AH,
2725: GL_BUDGETS B,

Line 2767: INSERT INTO PSA_BC_RESULTS_GT

2763: -- Bug 5711972
2764: populate_sum_tabs;
2765:
2766: FORALL i IN 1..l_bc_summary_rpt.count
2767: INSERT INTO PSA_BC_RESULTS_GT
2768: VALUES l_bc_summary_rpt(i);
2769:
2770: END IF;
2771:

Line 2815: UPDATE psa_bc_results_gt

2811: lookup_code = l_document_status;
2812:
2813: END IF;
2814:
2815: UPDATE psa_bc_results_gt
2816: SET document_status = l_meaning
2817: WHERE nvl(APPLICATION_NAME, '-99') = nvl(x.application_name, '-99') AND
2818: nvl(batch_reference, '-99') = nvl(x.batch_reference, '-99') AND
2819: nvl(document_reference, '-99') = nvl(x.document_reference, '-99') AND

Line 2829: UPDATE psa_bc_results_gt rg

2825: -- End of Section added to compute overall document budgetary status
2826:
2827: -- Bug 5713831, Added statement below to update lookup values
2828:
2829: UPDATE psa_bc_results_gt rg
2830: SET actual_flag_meaning = (SELECT description
2831: FROM gl_lookups
2832: WHERE lookup_code = rg.actual_flag
2833: AND lookup_type = 'BATCH_TYPE');

Line 2835: UPDATE psa_bc_results_gt rg

2831: FROM gl_lookups
2832: WHERE lookup_code = rg.actual_flag
2833: AND lookup_type = 'BATCH_TYPE');
2834:
2835: UPDATE psa_bc_results_gt rg
2836: SET funds_check_status = nvl((SELECT meaning
2837: FROM gl_lookups
2838: WHERE lookup_code = rg.funds_check_status_code
2839: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE'),

Line 2842: UPDATE psa_bc_results_gt rg

2838: WHERE lookup_code = rg.funds_check_status_code
2839: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE'),
2840: decode(rg.funds_check_status_code, 'Z', 'Accounting could not be created', ' ')) ;
2841:
2842: UPDATE psa_bc_results_gt rg
2843: SET result_message = (SELECT description
2844: FROM gl_lookups
2845: WHERE lookup_code = rg.result_code
2846: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')

Line 2849: UPDATE psa_bc_results_gt rg

2845: WHERE lookup_code = rg.result_code
2846: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')
2847: WHERE result_message IS NULL;
2848:
2849: UPDATE psa_bc_results_gt rg
2850: SET amount_type_meaning = (SELECT meaning
2851: FROM gl_lookups
2852: WHERE lookup_code = rg.amount_type
2853: AND lookup_type = 'PTD_YTD');

Line 2855: UPDATE psa_bc_results_gt rg

2851: FROM gl_lookups
2852: WHERE lookup_code = rg.amount_type
2853: AND lookup_type = 'PTD_YTD');
2854:
2855: UPDATE psa_bc_results_gt rg
2856: SET boundary = (SELECT meaning
2857: FROM gl_lookups
2858: WHERE lookup_code = rg.boundary_code
2859: AND lookup_type = 'BOUNDARY_TYPE');

Line 2861: UPDATE psa_bc_results_gt rg

2857: FROM gl_lookups
2858: WHERE lookup_code = rg.boundary_code
2859: AND lookup_type = 'BOUNDARY_TYPE');
2860:
2861: UPDATE psa_bc_results_gt rg
2862: SET funds_check_level_meaning = (SELECT meaning
2863: FROM gl_lookups
2864: WHERE lookup_code = rg.funds_check_level_code
2865: AND lookup_type = 'FUNDS_CHECK_LEVEL');

Line 2867: UPDATE psa_bc_results_gt rg

2863: FROM gl_lookups
2864: WHERE lookup_code = rg.funds_check_level_code
2865: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2866:
2867: UPDATE psa_bc_results_gt rg
2868: SET account_type_meaning = (SELECT description
2869: FROM gl_lookups
2870: WHERE lookup_code = rg.account_type
2871: AND lookup_type = 'ACCOUNT TYPE');

Line 2875: x_report_query := 'SELECT PBRG.* FROM psa_bc_results_gt PBRG, GL_CODE_COMBINATIONS GLCC

2871: AND lookup_type = 'ACCOUNT TYPE');
2872:
2873: -- End Bug 5713831
2874:
2875: x_report_query := 'SELECT PBRG.* FROM psa_bc_results_gt PBRG, GL_CODE_COMBINATIONS GLCC
2876: WHERE PBRG.ccid = GLCC.code_combination_id(+) ';
2877:
2878: -- Dynamic WHERE clause
2879: psa_utils.debug_other_string(g_state_level,l_api_name,'Before Dynamic WHERE clause');