1 PACKAGE CST_PerItemCostChangeRpt_PVT AS
2 /* $Header: CSTVPICS.pls 120.0 2005/06/28 05:28 cmuthu noship $ */
3
4 -- Start of comments
5 -- API name : generateXML
6 -- Type : Private
7 -- Function : Generate XML data for Periodic Item Cost Change
8 -- Report.
9 -- Pre-reqs : None
10 -- Parameters :
11 -- IN : p_legal_entity_id IN NUMBER Required
12 -- p_cost_type_id IN NUMBER Required
13 -- p_pac_period_id IN NUMBER Required
14 -- p_cost_group_id IN NUMBER Required
15 -- p_category_set_id IN NUMBER Required
16 -- p_item_master_org_id IN NUMBER Required
17 -- p_category_number IN NUMBER, Required /* Dummy */
18 -- p_category_from IN VARCHAR2 Optional
19 -- p_category_to IN VARCHAR2 Optional
20 -- p_item_from IN VARCHAR2 Optional
21 -- p_item_to IN VARCHAR2 Optional
22 -- p_qty_precision IN NUMBER Required
23 --
24 -- OUT : errcode OUT NOCOPY VARCHAR2
25 -- errno OUT NOCOPY NUMBER
26 --
27 -- Version : Current version 1.0
28 -- Initial Creation
29 --
30 -- Notes : This Procedure is called by the Periodic Item Cost
31 -- Change report. The procedure generates XML data and
32 -- writes it to the report output file, which is used by
33 -- XML Report Publisher program to publish the output.
34 -- End of comments
35
36 PROCEDURE generateXML (
37 errcode OUT NOCOPY VARCHAR2,
38 errno OUT NOCOPY NUMBER,
39 p_legal_entity_id IN NUMBER,
40 p_cost_type_id IN NUMBER,
41 p_pac_period_id IN NUMBER,
42 p_cost_group_id IN NUMBER,
43 p_category_set_id IN NUMBER,
44 p_item_master_org_id IN NUMBER,
45 p_category_number IN NUMBER, /* Dummy */
46 p_category_from IN VARCHAR2,
47 p_category_to IN VARCHAR2,
48 p_item_from IN VARCHAR2,
49 p_item_to IN VARCHAR2,
50 p_qty_precision IN NUMBER
51 );
52
53 -- Start of comments
54 -- API name : generateXML
55 -- Type : Private
56 -- Function : Adds the parameters to the XML output of Periodic Item
57 -- Cost Change Report.
58 -- Pre-reqs : None
59 -- Parameters :
60 -- IN : p_api_version IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Required
62 -- p_validation_level IN NUMBER Required
63 -- i_legal_entity_id IN NUMBER Required
64 -- i_cost_type_id IN NUMBER Required
65 -- i_pac_period_id IN NUMBER Required
66 -- i_cost_group_id IN NUMBER Required
67 -- i_category_set_id IN NUMBER Required
68 -- i_item_master_org_id IN NUMBER Required
69 -- i_category_from IN VARCHAR2 Optional
70 -- i_category_to IN VARCHAR2 Optional
71 -- i_item_from IN VARCHAR2 Optional
72 -- i_item_to IN VARCHAR2 Optional
73 --
74 -- OUT : x_return_status OUT NOCOPY VARCHAR2
75 -- x_msg_count OUT NOCOPY NUMBER
76 -- x_msg_data OUT NOCOPY VARCHAR2
77 -- x_xml_doc OUT NOCOPY CLOB
78 --
79 -- Version : Current version 1.0
80 -- Initial Creation
81 --
82 -- Notes : This Procedure is called by generate XML to add the
83 -- parameters of the report to the XML output.
84 -- End of comments
85
86 PROCEDURE add_parameters (
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_validation_level IN NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 i_legal_entity_id IN NUMBER,
94 i_cost_type_id IN NUMBER,
95 i_pac_period_id IN NUMBER,
96 i_cost_group_id IN NUMBER,
97 i_category_set_id IN NUMBER,
98 i_item_master_org_id IN NUMBER,
99 i_category_from IN VARCHAR2,
100 i_category_to IN VARCHAR2,
101 i_item_from IN VARCHAR2,
102 i_item_to IN VARCHAR2,
103 x_xml_doc IN OUT NOCOPY CLOB
104 );
105 END CST_PerItemCostChangeRpt_PVT;