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 486: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);

482: UNION ALL
483: SELECT packet_id
484: FROM gl_bc_packets_hists
485: WHERE template_id IS NOT NULL) bc
486: WHERE bc.packet_id IN (SELECT packet_id FROM psa_bc_results_gt);
487:
488: CURSOR c_document_status IS
489: SELECT application_name,
490: batch_reference,

Line 502: FROM psa_bc_results_gt

498: sum(decode(funds_check_status_code, 'T', 1, 0)) fatal_count,
499: sum(decode(funds_check_status_code, 'C', 1, 0)) checking_count,
500: sum(decode(funds_check_status_code, 'P', 1, 0)) reserving_count,
501: count(*) total_count
502: FROM psa_bc_results_gt
503: GROUP BY application_name, batch_reference, document_reference, vendor_name, vendor_site_name;
504:
505:
506: TYPE bc_rpt_type IS TABLE OF PSA_BC_RESULTS_GT%ROWTYPE INDEX BY BINARY_INTEGER;

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

502: FROM psa_bc_results_gt
503: GROUP BY application_name, batch_reference, document_reference, vendor_name, vendor_site_name;
504:
505:
506: TYPE bc_rpt_type IS TABLE OF PSA_BC_RESULTS_GT%ROWTYPE INDEX BY BINARY_INTEGER;
507: l_bc_results_rpt bc_rpt_type;
508: l_dump bc_rpt_type;
509: l_bc_summary_rpt bc_rpt_type;
510: l_sum_dump bc_rpt_type;

Line 2508: DELETE from PSA_BC_RESULTS_GT;

2504:
2505: -- Purge the GT table if it already holds rows. This is possible if report
2506: -- is reinvoked in the same session.
2507:
2508: DELETE from PSA_BC_RESULTS_GT;
2509:
2510: -- Insert all records from PLSQL table l_bc_results_rpt INTO psa_bc_results_rpt_gt
2511:
2512: FORALL i IN 1..l_bc_results_rpt.count

Line 2513: INSERT INTO PSA_BC_RESULTS_GT

2509:
2510: -- Insert all records from PLSQL table l_bc_results_rpt INTO psa_bc_results_rpt_gt
2511:
2512: FORALL i IN 1..l_bc_results_rpt.count
2513: INSERT INTO PSA_BC_RESULTS_GT
2514: VALUES l_bc_results_rpt(i);
2515:
2516: --delete
2517: IF x_source = 'CP' THEN

Line 2518: 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');

2514: VALUES l_bc_results_rpt(i);
2515:
2516: --delete
2517: IF x_source = 'CP' THEN
2518: 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');
2519:
2520: DELETE PSA_BC_RESULTS_GT GT1
2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)

Line 2520: DELETE PSA_BC_RESULTS_GT GT1

2516: --delete
2517: IF x_source = 'CP' THEN
2518: 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');
2519:
2520: DELETE PSA_BC_RESULTS_GT GT1
2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2523: FROM PSA_BC_RESULTS_GT GT2
2524: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);

Line 2523: FROM PSA_BC_RESULTS_GT GT2

2519:
2520: DELETE PSA_BC_RESULTS_GT GT1
2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2523: FROM PSA_BC_RESULTS_GT GT2
2524: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);
2525: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');
2526: END IF;
2527:

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

2521: WHERE (GT1.batch_reference, GT1.document_reference , GT1.line_reference, GT1.packet_id) NOT IN
2522: (SELECT GT2.batch_reference, GT2.document_reference, GT2.line_reference, max(GT2.packet_id)
2523: FROM PSA_BC_RESULTS_GT GT2
2524: GROUP BY GT2.batch_reference, GT2.document_reference, GT2.line_reference);
2525: psa_utils.debug_other_string(g_state_level,l_api_name,'Deleted '||sql%rowcount||' rows from psa_bc_results_gt.');
2526: END IF;
2527:
2528:
2529: IF p_para_rec.application_id IN (200, 201, 8901, 101) THEN

Line 2648: FROM PSA_BC_RESULTS_GT PBRG,

2644: MIN(PBRG.ERROR_SOURCE),
2645: MIN(PBRV.CURRENT_FUNDS_AVAILABLE),
2646: NULL
2647: BULK COLLECT INTO l_sum_dump
2648: FROM PSA_BC_RESULTS_GT PBRG,
2649: GL_PERIOD_STATUSES PS,
2650: GL_SUMMARY_TEMPLATES ST,
2651: GL_ACCOUNT_HIERARCHIES AH,
2652: GL_BUDGETS B,

Line 2694: INSERT INTO PSA_BC_RESULTS_GT

2690: -- Bug 5711972
2691: populate_sum_tabs;
2692:
2693: FORALL i IN 1..l_bc_summary_rpt.count
2694: INSERT INTO PSA_BC_RESULTS_GT
2695: VALUES l_bc_summary_rpt(i);
2696:
2697: END IF;
2698:

Line 2731: UPDATE psa_bc_results_gt

2727: lookup_code = l_document_status;
2728:
2729: END IF;
2730:
2731: UPDATE psa_bc_results_gt
2732: SET document_status = l_meaning
2733: WHERE nvl(APPLICATION_NAME, '-99') = nvl(x.application_name, '-99') AND
2734: nvl(batch_reference, '-99') = nvl(x.batch_reference, '-99') AND
2735: nvl(document_reference, '-99') = nvl(x.document_reference, '-99') AND

Line 2745: UPDATE psa_bc_results_gt rg

2741: -- End of Section added to compute overall document budgetary status
2742:
2743: -- Bug 5713831, Added statement below to update lookup values
2744:
2745: UPDATE psa_bc_results_gt rg
2746: SET actual_flag_meaning = (SELECT description
2747: FROM gl_lookups
2748: WHERE lookup_code = rg.actual_flag
2749: AND lookup_type = 'BATCH_TYPE');

Line 2751: UPDATE psa_bc_results_gt rg

2747: FROM gl_lookups
2748: WHERE lookup_code = rg.actual_flag
2749: AND lookup_type = 'BATCH_TYPE');
2750:
2751: UPDATE psa_bc_results_gt rg
2752: SET funds_check_status = (SELECT meaning
2753: FROM gl_lookups
2754: WHERE lookup_code = rg.funds_check_status_code
2755: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE');

Line 2757: UPDATE psa_bc_results_gt rg

2753: FROM gl_lookups
2754: WHERE lookup_code = rg.funds_check_status_code
2755: AND lookup_type = 'FUNDS_CHECK_STATUS_CODE');
2756:
2757: UPDATE psa_bc_results_gt rg
2758: SET result_message = (SELECT description
2759: FROM gl_lookups
2760: WHERE lookup_code = rg.result_code
2761: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')

Line 2764: UPDATE psa_bc_results_gt rg

2760: WHERE lookup_code = rg.result_code
2761: AND lookup_type = 'FUNDS_CHECK_RESULT_CODE')
2762: WHERE result_message IS NULL;
2763:
2764: UPDATE psa_bc_results_gt rg
2765: SET amount_type_meaning = (SELECT meaning
2766: FROM gl_lookups
2767: WHERE lookup_code = rg.amount_type
2768: AND lookup_type = 'PTD_YTD');

Line 2770: UPDATE psa_bc_results_gt rg

2766: FROM gl_lookups
2767: WHERE lookup_code = rg.amount_type
2768: AND lookup_type = 'PTD_YTD');
2769:
2770: UPDATE psa_bc_results_gt rg
2771: SET boundary = (SELECT meaning
2772: FROM gl_lookups
2773: WHERE lookup_code = rg.boundary_code
2774: AND lookup_type = 'BOUNDARY_TYPE');

Line 2776: UPDATE psa_bc_results_gt rg

2772: FROM gl_lookups
2773: WHERE lookup_code = rg.boundary_code
2774: AND lookup_type = 'BOUNDARY_TYPE');
2775:
2776: UPDATE psa_bc_results_gt rg
2777: SET funds_check_level_meaning = (SELECT meaning
2778: FROM gl_lookups
2779: WHERE lookup_code = rg.funds_check_level_code
2780: AND lookup_type = 'FUNDS_CHECK_LEVEL');

Line 2782: UPDATE psa_bc_results_gt rg

2778: FROM gl_lookups
2779: WHERE lookup_code = rg.funds_check_level_code
2780: AND lookup_type = 'FUNDS_CHECK_LEVEL');
2781:
2782: UPDATE psa_bc_results_gt rg
2783: SET account_type_meaning = (SELECT description
2784: FROM gl_lookups
2785: WHERE lookup_code = rg.account_type
2786: AND lookup_type = 'ACCOUNT TYPE');

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

2786: AND lookup_type = 'ACCOUNT TYPE');
2787:
2788: -- End Bug 5713831
2789:
2790: x_report_query := 'SELECT PBRG.* FROM psa_bc_results_gt PBRG, GL_CODE_COMBINATIONS GLCC
2791: WHERE PBRG.ccid = GLCC.code_combination_id(+) ';
2792:
2793: -- Dynamic WHERE clause
2794: psa_utils.debug_other_string(g_state_level,l_api_name,'Before Dynamic WHERE clause');