1 package cstppcit AUTHID CURRENT_USER as
2 /* $Header: CSTPCITS.pls 115.2 2002/11/09 00:40:56 awwang ship $ */
3
4 procedure periodic_cost_validate (
5 i_org_cost_group_id in number,
6 i_cost_type_id in number,
7 i_transaction_date in date,
8 i_txn_interface_id in number,
9 i_org_id in number,
10 i_item_id in number,
11 i_new_avg_cost in number,
12 i_per_change in number,
13 i_val_change in number,
14 i_mat_accnt in number,
15 i_mat_ovhd_accnt in number,
16 i_res_accnt in number,
17 i_osp_accnt in number,
18 i_ovhd_accnt in number,
19 o_err_num out NOCOPY number,
20 o_err_code out NOCOPY varchar2,
21 o_err_msg out NOCOPY varchar2
22 );
23
24 FUNCTION validate_account(
25 i_accnt in number,
26 i_chart_of_accounts in number)
27 RETURN number;
28
29 procedure periodic_cost_det_move (
30 i_cost_type_id in number,
31 i_transaction_date in date,
32 i_txn_id in number,
33 i_txn_interface_id in number,
34 i_txn_action_id in number,
35 i_org_id in number,
36 i_item_id in number,
37 i_org_cost_group_id in number,
38 i_txn_cost in number,
39 i_new_avg_cost in number,
40 i_per_change in number,
41 i_val_change in number,
42 i_mat_accnt in number,
43 i_mat_ovhd_accnt in number,
44 i_res_accnt in number,
45 i_osp_accnt in number,
46 i_ovhd_accnt in number,
47 i_user_id in number,
48 i_login_id in number,
49 i_request_id in number,
50 i_prog_appl_id in number,
51 i_prog_id in number,
52 o_err_num out NOCOPY number,
53 o_err_code out NOCOPY varchar2,
54 o_err_msg out NOCOPY varchar2
55 );
56
57 procedure periodic_cost_det_new_insert (
58 i_pac_period_id in number,
59 i_legal_entity in number,
60 i_cost_type_id in number,
61 i_txn_id in number,
62 i_txn_action_id in number,
63 i_org_id in number,
64 i_item_id in number,
65 i_org_cost_group_id in number,
66 i_txn_cost in number,
67 i_new_avg_cost in number,
68 i_per_change in number,
69 i_val_change in number,
70 i_mat_accnt in number,
71 i_mat_ovhd_accnt in number,
72 i_res_accnt in number,
73 i_osp_accnt in number,
74 i_ovhd_accnt in number,
75 i_user_id in number,
76 i_login_id in number,
77 i_request_id in number,
78 i_prog_appl_id in number,
79 i_prog_id in number,
80 o_err_num out NOCOPY number,
81 o_err_code out NOCOPY varchar2,
82 o_err_msg out NOCOPY varchar2
83 );
84
85
86 end cstppcit;