APPS.FUN_REPORT_PVT dependencies on FUN_REPORT_PVT

Line 1: PACKAGE BODY FUN_REPORT_PVT AS

1: PACKAGE BODY FUN_REPORT_PVT AS
2: /* $Header: FUNVRPTB.pls 120.15.12010000.4 2008/11/20 06:35:48 srampure ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'FUN_REPORT_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'FUN_REPORT_PVT';

1: PACKAGE BODY FUN_REPORT_PVT AS
2: /* $Header: FUNVRPTB.pls 120.15.12010000.4 2008/11/20 06:35:48 srampure ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'FUN_REPORT_PVT';
5:
6:
7:
8:

Line 19: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,

15: --End of Comments
16: -------------------------------------------------------------------------------
17: PROCEDURE build_summary_outquery(
18: x_return_status OUT NOCOPY VARCHAR2,
19: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,
20: x_outbound_query OUT NOCOPY VARCHAR2
21: ) IS
22: l_api_name VARCHAR2(30);
23: l_progress VARCHAR2(3);

Line 287: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,

283: --End of Comments
284: -------------------------------------------------------------------------------
285: PROCEDURE build_account_outquery(
286: x_return_status OUT NOCOPY VARCHAR2,
287: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,
288: x_outbound_query OUT NOCOPY VARCHAR2
289: ) IS
290: l_api_name VARCHAR2(30);
291: l_progress VARCHAR2(3);

Line 682: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,

678: --End of Comments
679: -------------------------------------------------------------------------------
680: PROCEDURE build_summary_inquery(
681: x_return_status OUT NOCOPY VARCHAR2,
682: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,
683: x_inbound_query OUT NOCOPY VARCHAR2
684: ) IS
685: l_api_name VARCHAR2(30);
686: l_progress VARCHAR2(3);

Line 935: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,

931: --End of Comments
932: -------------------------------------------------------------------------------
933: PROCEDURE build_account_inquery(
934: x_return_status OUT NOCOPY VARCHAR2,
935: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,
936: x_inbound_query OUT NOCOPY VARCHAR2
937: ) IS
938: l_api_name VARCHAR2(30);
939: l_progress VARCHAR2(30);

Line 1365: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,

1361: --End of Comments
1362: -------------------------------------------------------------------------------
1363: PROCEDURE construct_output(
1364: x_return_status OUT NOCOPY VARCHAR2,
1365: p_para_rec IN FUN_REPORT_PVT.summaryreport_para_rec_type,
1366: p_outbound_trxs IN CLOB,
1367: p_inbound_trxs IN CLOB
1368: ) IS
1369: l_api_name VARCHAR2(30);

Line 1624: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,

1620: --End of Comments
1621: -------------------------------------------------------------------------------
1622: PROCEDURE construct_account_output(
1623: x_return_status OUT NOCOPY VARCHAR2,
1624: p_para_rec IN FUN_REPORT_PVT.accountreport_para_rec_type,
1625: p_trxs IN CLOB
1626: ) IS
1627: l_api_name VARCHAR2(30);
1628: l_progress VARCHAR2(5);

Line 1915: l_para_rec FUN_REPORT_PVT.summaryreport_para_rec_type;

1911: ) IS
1912: l_api_name VARCHAR2(30);
1913: l_progress VARCHAR2(3);
1914:
1915: l_para_rec FUN_REPORT_PVT.summaryreport_para_rec_type;
1916: l_return_status VARCHAR2(20);
1917: l_outbound_query VARCHAR2(20000);
1918: l_inbound_query VARCHAR2(20000);
1919: l_trxs CLOB;

Line 2160: l_para_rec FUN_REPORT_PVT.accountreport_para_rec_type;

2156: ) IS
2157: l_api_name VARCHAR2(30);
2158: l_progress VARCHAR2(3);
2159:
2160: l_para_rec FUN_REPORT_PVT.accountreport_para_rec_type;
2161: l_return_status VARCHAR2(20);
2162: l_outbound_query VARCHAR2(15000) DEFAULT NULL;
2163: l_inbound_query VARCHAR2(15000) DEFAULT NULL;
2164: l_query VARCHAR2(31000);

Line 2344: END FUN_REPORT_PVT;

2340: FUN_UTIL.log_conc_err(
2341: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2342: END create_accountreport;
2343:
2344: END FUN_REPORT_PVT;
2345:
2346: