1 PACKAGE pos_supp_generate_rpt_pkg AUTHID CURRENT_USER AS
2 /* $Header: POSSPRPTS.pls 120.1 2010/11/25 12:16:45 puppulur noship $ */
3 -- Author : BHUVANA VAMSI
4 -- Purpose : Generate XML report for selected suppliers
5
6 g_curr_supp_xml_rpt_id NUMBER := 0;
7 FromClause varchar2(30):= null;
8 WhereClause varchar2(1000):=null;
9 P_REPORT_ID number;
10 P_PUBLICATION_ID VARCHAR2(100);
11 -----------------------------------------
12 -- Function to return the report id
13 FUNCTION get_curr_supp_xml_rpt_id RETURN NUMBER;
14 -----------------------------------------
15 FUNCTION rem_first_comma(in_string IN VARCHAR2) RETURN VARCHAR2;
16 -----------------------------------------
17 -- List to csv conversion
18 PROCEDURE list_to_csv_varchar(x_array IN pos_tbl_number,
19 x_result1 OUT NOCOPY VARCHAR2,
20 x_result2 OUT NOCOPY VARCHAR2,
21 x_result3 OUT NOCOPY VARCHAR2);
22 ----------------------------------------------
23 -- Parse Procedure
24 PROCEDURE parse_list(x_result IN VARCHAR2,
25 x_array IN OUT NOCOPY pos_tbl_number);
26 ------------------------------------------------
27 -- Main Procedure which is being called from the Generate Report AM Method
28 PROCEDURE generate_report_event(p_api_version IN INTEGER,
29 p_init_msg_list IN VARCHAR2,
30 p_party_id IN pos_tbl_number,
31 x_report_id OUT NOCOPY NUMBER,
32 x_actions_request_id OUT NOCOPY NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2);
36
37 ---------------------------------------------
38 -- Procedure to call the Concurrent program to submit
39 PROCEDURE populate_bo_and_save_concur(--x_errbuf OUT NOCOPY VARCHAR2,
40 --x_retcode OUT NOCOPY NUMBER,
41 p_party_id_cs_1 IN VARCHAR2 DEFAULT '',
42 p_party_id_cs_2 IN VARCHAR2 DEFAULT '',
43 p_party_id_cs_3 IN VARCHAR2 DEFAULT '',
44 p_report_id_in IN VARCHAR2 DEFAULT '');
45
46 --------------------------------------------------
47 -- Procedure to get the BO and insert the XML content in
48 PROCEDURE get_bo_and_insert(p_party_id IN pos_tbl_number,
49 p_report_id IN NUMBER
50 );
51 ---------------------------------------------------------
52 Function BEFORE_REPORT_TRIGGER (P_REPORT_ID in number,P_PUBLICATION_ID in varchar2) return Boolean;
53
54 END pos_supp_generate_rpt_pkg;