[Home] [Help]
PACKAGE: APPS.CSTPALBR
Source
1 PACKAGE CSTPALBR AS
2 /* $Header: CSTALBRS.pls 120.1 2006/02/13 04:09:11 ggautam noship $ */
3 /*-----------------------------------------------------------------------
4 TYPE cst_ae_txn_rec_type IS RECORD (
5 event_type_id VARCHAR2(30),
6 txn_action_id NUMBER(15),
7 txn_src_type_id NUMBER(15),
8 txn_src_id NUMBER(15),
9 txn_type_id NUMBER(15),
10 txn_type_flag VARCHAR2(3),
11 --wip_txn_type NUMBER(15),
12 txn_type VARCHAR2(30),
13 transaction_id NUMBER(15),
14 inventory_item_id NUMBER(15),
15 set_of_books_id NUMBER(15),
16 legal_entity_id NUMBER(15),
17 cost_type_id NUMBER(15),
18 cost_group_id NUMBER(15),
19 xfer_cost_group_id NUMBER(15),
20 primary_quantity NUMBER,
21 subinventory_code VARCHAR2(10),
22 xfer_organization_id NUMBER(15),
23 xfer_subinventory VARCHAR2(10),
24 xfer_transaction_id NUMBER(15),
25 dist_acct_id NUMBER(15),
26 currency_code VARCHAR2(15),
27 currency_conv_type VARCHAR2(15),
28 currency_conv_date DATE,
29 currency_conv_rate NUMBER,
30 ae_category varchar2(15),
31 accounting_period_id NUMBER(15),
32 accounting_period_name VARCHAR2(15),
33 accounting_date DATE,
34 organization_id NUMBER(15),
35 mat_account NUMBER(15),
36 mat_ovhd_account NUMBER(15),
37 res_account NUMBER(15),
38 osp_account NUMBER(15),
39 ovhd_account NUMBER(15),
40 flow_schedule NUMBER(15),
41 exp_item NUMBER,
42 category_id NUMBER ,
43 source_table VARCHAR2(15),
44 source_id NUMBER,
45 description VARCHAR2(240),
46 wip_entity_type NUMBER,
47 line_id NUMBER
48 );
49
50 TYPE cst_ae_line_rec_type IS RECORD (
51 ae_line_type NUMBER(5),
52 description VARCHAR2(240),
53 account NUMBER(15),
54 currency_code VARCHAR2(15),
55 currency_conv_type VARCHAR2(15),
56 currency_conv_date DATE,
57 currency_conv_rate NUMBER,
58 entered_dr NUMBER,
59 entered_cr NUMBER,
60 accounted_dr NUMBER,
61 accounted_cr NUMBER,
62 source_table VARCHAR2(30),
63 source_id NUMBER,
64 rate_or_amount NUMBER,
65 basis_type NUMBER,
66 resource_id NUMBER,
67 cost_element_id NUMBER,
68 activity_id NUMBER,
69 repetitive_schedule_id NUMBER,
70 overhead_basis_factor NUMBER,
71 basis_resource_id NUMBER,
72 transaction_value NUMBER,
73 reference1 VARCHAR2(240),
74 reference2 VARCHAR2(240),
75 reference3 VARCHAR2(240),
76 reference4 VARCHAR2(240),
77 reference5 VARCHAR2(240),
78 reference6 VARCHAR2(240),
79 reference7 VARCHAR2(240),
80 reference8 VARCHAR2(240),
81 reference9 VARCHAR2(240),
82 reference10 VARCHAR2(240)
83 );
84
85 TYPE cst_ae_curr_rec_type IS RECORD (
86 pri_currency VARCHAR2(15),
87 alt_currency VARCHAR2(15),
88 currency_conv_type VARCHAR2(15),
89 currency_conv_date DATE,
90 currency_conv_rate NUMBER
91 );
92
93 TYPE cst_ae_acct_rec_type IS RECORD (
94 account NUMBER,
95 mat_account NUMBER,
96 mat_ovhd_account NUMBER,
97 res_account NUMBER,
98 osp_account NUMBER,
99 ovhd_account NUMBER
100 );
101
102 TYPE cst_ae_err_rec_type IS RECORD (
103 l_err_num NUMBER,
104 l_err_code VARCHAR2(240),
105 l_err_msg VARCHAR2(240)
106 );
107
108 TYPE cst_ae_par_rec_type IS RECORD (
109 legal_entity NUMBER,
110 cost_type_id NUMBER,
111 cost_group_id NUMBER,
112 period_id NUMBER
113 );
114
115
116 TYPE cst_ae_line_tbl_type IS TABLE OF cst_ae_line_rec_type;
117
118
119 TYPE cst_ae_lib_param_type IS RECORD (
120 i_name VARCHAR2(50),
121 i_num_value NUMBER,
122 i_vchar_value VARCHAR2(500),
123 i_char_value CHAR(500),
124 i_date_value DATE,
125 i_datatype NUMBER,
126 i_inout NUMBER
127 );
128
129 TYPE cst_ae_lib_par_tbl_type IS TABLE OF cst_ae_lib_param_type;
130 -----------------------------------------------------------------------*/
131 PROCEDURE dyn_proc_call (
132 i_proc_name IN VARCHAR2,
133 i_legal_entity IN NUMBER,
134 i_cost_type IN NUMBER,
135 i_cost_group IN NUMBER,
136 i_period_id IN NUMBER,
137 i_transaction_id IN NUMBER,
138 i_event_type_id IN VARCHAR2,
139 i_txn_type_flag IN VARCHAR2, -- 4586534
140 o_err_num OUT NOCOPY NUMBER,
141 o_err_code OUT NOCOPY VARCHAR2,
142 o_err_msg OUT NOCOPY VARCHAR2
143 );
144 /*-------------------------------------------------------------------
145 PROCEDURE run_dyn_proc (
146 i_num_params IN NUMBER,
147 i_proc_name IN VARCHAR2,
148 io_parameters IN OUT CSTPALTY.CST_AE_LIB_PAR_TBL_TYPE,
149 o_err OUT NUMBER
150 );
151 ----------------------------------------------------------------------*/
152
153 PROCEDURE create_acct_entry (
154 i_acct_lib_id IN NUMBER,
155 i_legal_entity IN NUMBER,
156 i_cost_type_id IN NUMBER,
157 i_cost_group_id IN NUMBER,
158 i_period_id IN NUMBER,
159 i_mode IN NUMBER,
160 o_err_num OUT NOCOPY NUMBER,
161 o_err_code OUT NOCOPY VARCHAR2,
162 o_err_msg OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE insert_ae_lines (
166 i_ae_txn_rec IN CSTPALTY.CST_AE_TXN_REC_TYPE,
167 i_ae_line_rec_tbl IN CSTPALTY.CST_AE_LINE_TBL_TYPE,
168 o_err_rec OUT NOCOPY CSTPALTY.CST_AE_ERR_REC_TYPE
169 );
170
171
172 END CSTPALBR;
173