[Home] [Help]
PACKAGE: APPS.GCS_XML_GEN_PKG
Source
1 PACKAGE GCS_XML_GEN_PKG as
2 /* $Header: gcsxmlgens.pls 120.7 2005/12/23 11:57:42 hakumar noship $ */
3 /*
4 TYPE r_ds_header_data IS RECORD
5 (load_id NUMBER(15),
6 load_name VARCHAR2(50),
7 entity_id NUMBER,
8 entity_name VARCHAR2(150),
9 balance_type VARCHAR2(80),
10 amount_type_code VARCHAR2(30),
11 amount_type_name VARCHAR2(80),
12 curr_type_code VARCHAR2(30),
13 curr_type_name VARCHAR2(80),
14 currency_code VARCHAR2(15),
15 currency_name VARCHAR2(80),
16 cal_period_id NUMBER,
17 cal_period_name VARCHAR2(80),
18 measure_type_code VARCHAR2(30),
19 measure_type_name VARCHAR2(80),
20 start_time VARCHAR2(30),
21 end_time VARCHAR2(30),
22 status_code VARCHAR2(30),
23 balance_type_code VARCHAR2(30),
24 balances_rule_id NUMBER(9),
25 balances_rule_name VARCHAR2(150),
26 ledger_id NUMBER,
27 ledger_name VARCHAR2(150),
28 source_system_code NUMBER,
29 entity_currency_code VARCHAR2(15),
30 sub_global_vs_combo_id NUMBER);
31
32 TYPE r_cmtb_header_data IS RECORD
33 (run_name VARCHAR2(720),
34 cal_period_name VARCHAR2(450),
35 balance_type VARCHAR2(80),
36 start_time VARCHAR2(30),
37 end_time VARCHAR2(30),
38 currency_name VARCHAR2(80),
39 hierarchy_name VARCHAR2(150),
40 hierarchy_id NUMBER,
41 cal_period_id NUMBER);
42
43 TYPE r_ad_header_data IS RECORD
44 (entry_name VARCHAR2(80),
45 description VARCHAR2(240),
46 total_consideration VARCHAR2(240),
47 category_name VARCHAR2(80),
48 transaction_date DATE,
49 hierarchy_name VARCHAR2(150),
50 cons_hierarchy_name VARCHAR2(150),
51 cons_entity_name VARCHAR2(150),
52 child_entity_name VARCHAR2(150),
53 currency_name VARCHAR2(80));
54
55 --Bugfix 4725916: Added category code to the record to support drilldown
56 TYPE r_entry_header_data IS RECORD
57 (entry_name VARCHAR2(80),
58 description VARCHAR2(240),
59 hierarchy_name VARCHAR2(150),
60 entity_name VARCHAR2(150),
61 currency_name VARCHAR2(80),
62 cal_period_name VARCHAR2(80),
63 suspense_flag VARCHAR2(1),
64 rule_id NUMBER,
65 entity_id NUMBER,
66 hierarchy_id NUMBER,
67 cal_period_id NUMBER,
68 balance_type_code VARCHAR2(30),
69 currency_code VARCHAR2(30),
70 entity_type_code VARCHAR2(30),
71 category_code VARCHAR2(80));
72
73 TYPE r_rowseq_hash_data IS RECORD
74 (creation_row_sequence NUMBER,
75 rowseq_hash_key VARCHAR2(1000));
76
77 --
78 -- PROCEDURE
79 -- generate_entry_xml
80 -- Purpose
81 -- Generates the XML per entry and stores on ENTRY_DATA
82 -- If entry was created by consolidation rule it will put the XML on EXECUTION_DATA
83 --
84 --
85 -- Arguments
86 -- p_entry_id Entry Identifier
87 --
88 -- Notes
89 --
90
91 PROCEDURE generate_entry_xml ( p_entry_id IN NUMBER,
92 p_category_code IN VARCHAR2,
93 p_cons_rule_flag IN VARCHAR2);
94
95 PROCEDURE generate_cmtb_xml ( p_entry_id IN NUMBER,
96 p_entity_id IN NUMBER,
97 p_hierarchy_id IN NUMBER,
98 p_cal_period_id IN NUMBER,
99 p_balance_type_code IN VARCHAR2,
100 p_currency_code IN VARCHAR2);
101
102 PROCEDURE generate_ds_xml ( p_load_id IN NUMBER);
103
104 PROCEDURE generate_ad_xml ( p_ad_transaction_id IN NUMBER);*/
105
106 PROCEDURE submit_entry_xml_gen( x_errbuf OUT NOCOPY VARCHAR2,
107 x_retcode OUT NOCOPY VARCHAR2,
108 p_run_name IN VARCHAR2,
109 p_cons_entity_id IN NUMBER,
110 p_category_code IN VARCHAR2,
111 p_child_entity_id IN NUMBER,
112 p_run_detail_id IN NUMBER);
113 END GCS_XML_GEN_PKG;