[Home] [Help]
PACKAGE: APPS.CSTPAPBR
Source
1 PACKAGE CSTPAPBR AS
2 /* $Header: CSTAPBRS.pls 120.5.12010000.2 2008/10/29 23:16:41 vjavli ship $ */
3
4 PROCEDURE create_acct_lines (
5 i_legal_entity in number,
6 i_cost_type_id in number,
7 i_cost_group_id in number,
8 i_period_id in number,
9 i_transaction_id in number,
10 i_event_type_id in varchar2,
11 i_txn_type_flag IN VARCHAR2, -- Bug 4586534
12 o_err_num out NOCOPY number,
13 o_err_code out NOCOPY varchar2,
14 o_err_msg out NOCOPY varchar2
15 );
16
17
18 procedure create_inv_ae_lines(
19 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
20 o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
21 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
22 ) ;
23
24 procedure wip_cost_txn(
25 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
26 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
27 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
28 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
29 ) ;
30
31 procedure sub_cost_txn(
32 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
33 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
34 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
35 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
36 ) ;
37
38 procedure interorg_cost_txn(
39 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
40 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
41 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
42 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
43 ) ;
44
45 procedure pcu_cost_txn(
46 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
47 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
48 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
49 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
50 ) ;
51
52 procedure inv_cost_txn(
53 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
54 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
55 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
56 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
57 ) ;
58
59 procedure cost_logical_txn(
60 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
61 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
62 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
63 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
64 ) ;
65
66 procedure cost_consigned_update_txn(
67 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
68 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
69 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
70 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
71 ) ;
72
73 procedure inventory_accounts(
74 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
75 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
76 i_exp_flag IN BOOLEAN,
77 i_exp_account IN NUMBER,
78 i_dr_flag IN BOOLEAN,
79 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
80 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
81 i_intransit_flag IN NUMBER DEFAULT 0
82 ) ;
83
84 procedure encumbrance_account(
85 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
86 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
87 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
88 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
89 );
90 procedure offset_accounts(
91 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
92 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
93 i_acct_line_type IN NUMBER,
94 i_elemental IN NUMBER,
95 i_ovhd_absp IN NUMBER,
96 i_dr_flag IN BOOLEAN,
97 i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
98 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
99 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
100 );
101
102 procedure ovhd_accounts(
103 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
104 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
105 i_dr_flag IN BOOLEAN,
106 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
107 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
108 );
109
110 PROCEDURE insert_account(
111 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
112 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
113 i_dr_flag IN BOOLEAN,
114 i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
115 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
116 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
117 );
118
119 procedure balance_account (
120 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
121 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
122 );
123
124
125 procedure create_wip_ae_lines(
126 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
127 o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
128 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
129 ) ;
130
131 procedure get_accts(
132 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
133 i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
134 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
135 o_acct_id1 OUT NOCOPY NUMBER,
136 o_acct_id2 OUT NOCOPY NUMBER,
137 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
138 );
139
140 procedure WIP_accounts(
141 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
142 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
143 i_acct_line_type IN NUMBER,
144 i_ovhd_absp IN NUMBER,
145 i_dr_flag IN BOOLEAN,
146 i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
147 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
148 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type);
149
150 Function Get_Intercompany_account(
151 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
152 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
153 RETURN NUMBER;
154
155 PROCEDURE cost_internal_order_exp_txn(
156 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
157 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
158 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
159 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
160 ) ;
161
162 Procedure get_pacp_priorPrd_mta_cost (
163 i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
164 i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
165 l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
166 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
167 o_pacp_flag OUT NOCOPY NUMBER,
168 o_pacp_pwac_cost OUT NOCOPY NUMBER,
169 o_prev_period_flag OUT NOCOPY NUMBER,
170 o_prev_period_pwac_cost OUT NOCOPY NUMBER,
171 o_perp_ship_flag OUT NOCOPY NUMBER,
172 o_perp_ship_value OUT NOCOPY NUMBER,
173 o_txfr_credit OUT NOCOPY NUMBER
174 ) ;
175
176 PROCEDURE CompEncumbrance_IntOrdersExp (
177 p_api_version IN NUMBER,
178 p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
179 p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
180 p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
181 p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
182 p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
183 p_total_primary_qty IN NUMBER,
184 x_encumbrance_amount OUT NOCOPY NUMBER,
185 x_encumbrance_account OUT NOCOPY NUMBER,
186 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
187 ) ;
188
189 PROCEDURE CompEncumbrance_IntOrdersExp (
190 p_api_version IN NUMBER,
191 p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
192 x_encumbrance_amount OUT NOCOPY NUMBER,
193 x_encumbrance_account OUT NOCOPY NUMBER,
194 o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
195 );
196
197 end CSTPAPBR;