1 PACKAGE PSA_BC_XML_REPORT_PUB AS
2 /* $Header: PSAXMLRS.pls 120.5 2006/12/01 17:19:31 agovil noship $ */
3
4
5
6 ------- Create a STRUCTURE with all SRS paramaters ----------
7
8 TYPE funds_check_report_rec_type IS RECORD(
9 LEDGER_ID GL_LEDGERS.LEDGER_ID%TYPE,
10 PERIOD_FROM VARCHAR2(30),
11 PERIOD_TO VARCHAR2(30),
12 CHART_OF_ACCTS_ID NUMBER,
13 CCID_LOW VARCHAR2(1000),
14 CCID_HIGH VARCHAR2(1000),
15 APPLICATION_SHORT_NAME VARCHAR2(8),
16 BC_FUNDS_CHECK_STATUS PSA_LOOKUP_CODES.lookup_code%TYPE,
17 BC_FUNDS_CHECK_ORDER_BY PSA_LOOKUP_CODES.lookup_code%TYPE,
18 PACKET_EVENT_FLAG VARCHAR2(1),
19 APPLICATION_ID NUMBER(15),
20 SEQUENCE_ID NUMBER(15)
21 );
22
23 ------- This is the first procedure and will be called from Concurrent program.-----
24 ------- The executable name in concurrent program -----
25 ------- will be PSA_BC_XML_REPORT_PUB.create_bc_report -------
26
27 PROCEDURE create_bc_report(
28 errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY NUMBER,
30
31 P_LEDGER_ID IN NUMBER DEFAULT NULL,
32 P_PERIOD_FROM IN VARCHAR2 DEFAULT NULL,
33 P_PERIOD_TO IN VARCHAR2 DEFAULT NULL,
34 P_CHART_OF_ACCTS_ID IN NUMBER,
35 P_CCID_LOW IN VARCHAR2 DEFAULT NULL,
36 P_CCID_HIGH IN VARCHAR2 DEFAULT NULL,
37 P_APPLICATION_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
38 P_FUNDS_CHECK_STATUS IN VARCHAR2 DEFAULT NULL,
39 P_ORDER_BY IN VARCHAR2 DEFAULT NULL
40 );
41
42 ------- This Procedure is invoked when the BC report is invoked from Forms
43 PROCEDURE create_bc_transaction_report(
44 -- x_xml_out OUT NOCOPY CLOB,
45 errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY NUMBER,
47 P_LEDGER_ID IN NUMBER DEFAULT NULL,
48 P_APPLICATION_ID IN NUMBER DEFAULT NULL,
49 P_PACKET_EVENT_FLAG IN VARCHAR2 DEFAULT NULL,
50 P_SEQUENCE_ID IN NUMBER DEFAULT NULL
51 );
52
53 ------- This procedure will build the SQL query from PSA_BC_REPORT_V view
54 ------- for all products for the given paramters -------
55
56 PROCEDURE build_report_query(
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_source IN VARCHAR2 DEFAULT NULL,
59 p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,
60 p_application_short_name IN VARCHAR2 DEFAULT NULL,
61 x_report_query OUT NOCOPY VARCHAR2
62 );
63
64
65
66 PROCEDURE get_xml(
67 x_return_status OUT NOCOPY VARCHAR2,
68 p_query IN VARCHAR2,
69 p_rowset_tag IN VARCHAR2 DEFAULT NULL,
70 p_row_tag IN VARCHAR2 DEFAULT NULL,
71 x_xml OUT NOCOPY CLOB
72 );
73
74
75 PROCEDURE construct_bc_report_output(
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_source IN VARCHAR2 DEFAULT NULL,
78 p_para_rec IN PSA_BC_XML_REPORT_PUB.funds_check_report_rec_type,
79 p_trxs IN CLOB
80 );
81
82
83 PROCEDURE save_xml(
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_source IN VARCHAR2 DEFAULT NULL,
86 p_application_id IN NUMBER,
87 p_sequence_id IN NUMBER,
88 p_trxs IN CLOB,
89 p_offset IN INTEGER DEFAULT 1
90 );
91
92 PROCEDURE save_xml_to_db(
93 x_return_status OUT NOCOPY VARCHAR2,
94 p_application_id IN NUMBER,
95 p_sequence_id IN NUMBER,
96 p_trxs IN CLOB
97 );
98
99 END PSA_BC_XML_REPORT_PUB;
100