APPS.PSA_BC_XML_REPORT_PUB dependencies on PSA_BC_XML_REPORT_PUB

Line 1: PACKAGE BODY PSA_BC_XML_REPORT_PUB AS

1: PACKAGE BODY PSA_BC_XML_REPORT_PUB AS
2: /* $Header: PSAXMLRB.pls 120.49.12000000.15 2007/10/15 15:47:53 sthota ship $ */
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';

7: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
8: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
10: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: g_full_path VARCHAR2(50) := 'psa.plsql.psaxmlrb.psa_bc_xml_report_pub.';
12: --===========================FND_LOG.END=======================================
13: ------------------------------------------------------------------------------
14: -- PROCEDURE create_bc_report
15: -- Start of Comments

Line 37: l_para_rec PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type;

33:
34: l_api_name VARCHAR2(240);
35: l_return_status VARCHAR2(20);
36: l_application_id NUMBER(15);
37: l_para_rec PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type;
38: x_report_query VARCHAR2(32000) DEFAULT NULL;
39: l_query VARCHAR2(32000) DEFAULT NULL;
40: l_trxs CLOB;
41:

Line 157: l_para_rec PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type;

153: l_api_name VARCHAR2(240);
154: l_return_status VARCHAR2(20);
155: l_application_id NUMBER(15);
156: l_sequence_id NUMBER(15);
157: l_para_rec PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type;
158: x_report_query VARCHAR2(32000) DEFAULT NULL;
159: l_query VARCHAR2(32000) DEFAULT NULL;
160: l_trxs CLOB;
161:

Line 278: p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,

274:
275: PROCEDURE build_report_query(
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_source IN VARCHAR2,
278: p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,
279: p_application_short_name IN VARCHAR2,
280: x_report_query OUT NOCOPY VARCHAR2
281: ) IS
282:

Line 3042: p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,

3038: -------------------------------------------------------------------------------
3039: PROCEDURE construct_bc_report_output(
3040: x_return_status OUT NOCOPY VARCHAR2,
3041: x_source IN VARCHAR2,
3042: p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,
3043: p_trxs IN CLOB
3044: ) IS
3045: l_api_name VARCHAR2(240);
3046: l_para_meaning_list VARCHAR2(2000);

Line 3314: END PSA_BC_XML_REPORT_PUB;

3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3311: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3312: RAISE;
3313: END save_xml_to_db;
3314: END PSA_BC_XML_REPORT_PUB;