DBA Data[Home] [Help]

APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_TB_AP_REPORT_PVT

Line 1: PACKAGE BODY XLA_TB_AP_REPORT_PVT AS

1: PACKAGE BODY XLA_TB_AP_REPORT_PVT AS
2: /* $Header: xlatbapt.pkb 120.7 2010/09/08 08:27:42 vgopiset noship $ */
3:
4:
5: --+==========================================================================+

Line 2263: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'

2259: -- Assign template sql C_INSERT_GT_SELECT for Detail C_INSERT_GT_SUMMARY_SELECT for Summary Report
2260: -- to a local variable to replace strings
2261:
2262: -- Changes for bug#8773522
2263: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'
2264: THEN
2265: l_insert_gt_sql := C_INSERT_GT_SUMMARY_STATEMENT || C_INSERT_GT_SUMMARY_SELECT;
2266: ELSE
2267: l_insert_gt_sql := C_INSERT_GT_STATEMENT || C_INSERT_GT_SELECT;

Line 2363: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'

2359:
2360: END IF;
2361:
2362: -- newly added for bug:8773522
2363: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'
2364: THEN
2365: IF l_security_join IS NOT NULL THEN
2366: l_insert_gt_sql := REPLACE(l_insert_gt_sql
2367: ,'$security_valuation_join$'

Line 2719: (p_location => 'xla_tb_ap_report_pvt.get_gcck_join');

2715: WHEN xla_exceptions_pkg.application_exception THEN
2716: RAISE;
2717: WHEN OTHERS THEN
2718: xla_exceptions_pkg.raise_message
2719: (p_location => 'xla_tb_ap_report_pvt.get_gcck_join');
2720: END get_gcck_join;
2721:
2722: /*======================================================================+
2723: | |

Line 2808: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'

2804: ,p_module => l_log_module);
2805:
2806: END IF;
2807:
2808: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'
2809: THEN
2810: l_source_sql := C_TB_SUMMARY_SOURCE_SQL ;
2811: ELSE
2812: IF p_incl_write_off_flag = 'Y' THEN

Line 2928: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'

2924:
2925: END IF;
2926: */ -- bug 9133956
2927:
2928: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'
2929: THEN
2930: P_SUMMARY_SQL_STATEMENT := l_source_sql;
2931: ELSE
2932: p_sql_statement := l_source_sql;

Line 3035: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'

3031: END IF;
3032:
3033: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3034:
3035: IF XLA_TB_AP_REPORT_PVT.P_REPORT = 'S'
3036: THEN
3037: dump_text(p_text => p_summary_sql_statement);
3038: ELSE
3039: dump_text(p_text => p_sql_statement);

Line 3363: END xla_tb_ap_report_pvt;

3359: IF NOT g_log_enabled THEN
3360: g_log_level := C_LEVEL_LOG_DISABLED;
3361: END IF;
3362:
3363: END xla_tb_ap_report_pvt;