1 PACKAGE CSTPCGUT AS
2 /* $Header: CSTCGUTS.pls 120.1 2005/08/26 12:00:19 awwang noship $ */
3
4
5
6 type cost_group_rec is record
7 (
8 cost_group_id number
9
10 );
11
12 type cost_group_tbl is table of NUMBER
13 index by binary_integer;
14
15 ----------------------------------------------------------------------------
16 -- PROCEDURE --
17 -- get_cost_group --
18 -- --
19 -- DESCRIPTION --
20 -- Use this procedure to obatain cost groups based on account information.--
21 -- --
22 -- PURPOSE: --
23 -- Oracle Applications Rel 11i.2 --
24 -- --
25
26 -- HISTORY: --
27 -- 03/02/00 Sujit Dalai Created --
28 ----------------------------------------------------------------------------
29
30 PROCEDURE get_cost_group(x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_cost_group_id_tbl OUT NOCOPY CSTPCGUT.cost_group_tbl,
34 x_count OUT NOCOPY NUMBER,
35 p_material_account IN NUMBER default FND_API.G_MISS_NUM,
36 p_material_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
37 p_resource_account IN NUMBER default FND_API.G_MISS_NUM,
38 p_overhead_account IN NUMBER default FND_API.G_MISS_NUM,
39 p_outside_processing_account IN NUMBER default FND_API.G_MISS_NUM,
40 p_expense_account IN NUMBER default FND_API.G_MISS_NUM,
41 p_encumbrance_account IN NUMBER default FND_API.G_MISS_NUM,
42 p_average_cost_var_account IN NUMBER default FND_API.G_MISS_NUM,
43 p_payback_mat_var_account IN NUMBER default FND_API.G_MISS_NUM,
44 p_payback_res_var_account IN NUMBER default FND_API.G_MISS_NUM,
45 p_payback_osp_var_account IN NUMBER default FND_API.G_MISS_NUM,
46 p_payback_moh_var_account IN NUMBER default FND_API.G_MISS_NUM,
47 p_payback_ovh_var_account IN NUMBER default FND_API.G_MISS_NUM,
48 p_organization_id IN NUMBER ,
49 p_cost_group_type_id IN NUMBER);
50
51
52 ----------------------------------------------------------------------------
53 -- PROCEDURE --
54 -- create_cost_group --
55 -- --
56 -- DESCRIPTION --
57 -- Use this procedure to create a new cost group. --
58 -- --
59 -- PURPOSE: --
60 -- Oracle Applications Rel 11i.2 --
61 -- --
62 -- Parameter : --
63 -- p_multi_org = 1 (Multi org cost group) --
64 -- 2 ( Non Multi org cost group) --
65
66 -- HISTORY: --
67 -- 05/26/00 Sujit Dalai Created --
68 ----------------------------------------------------------------------------
69
70 PROCEDURE create_cost_group(x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 x_cost_group_id OUT NOCOPY NUMBER,
74 p_cost_group IN VARCHAR2,
75 p_material_account IN NUMBER default NULL,
76 p_material_overhead_account IN NUMBER default NULL,
77 p_resource_account IN NUMBER default NULL,
78 p_overhead_account IN NUMBER default NULL,
79 p_outside_processing_account IN NUMBER default NULL,
80 p_expense_account IN NUMBER default NULL,
81 p_encumbrance_account IN NUMBER default NULL,
82 p_average_cost_var_account IN NUMBER default NULL,
83 p_payback_mat_var_account IN NUMBER default NULL,
84 p_payback_res_var_account IN NUMBER default NULL,
85 p_payback_osp_var_account IN NUMBER default NULL,
86 p_payback_moh_var_account IN NUMBER default NULL,
87 p_payback_ovh_var_account IN NUMBER default NULL,
88 p_organization_id IN NUMBER,
89 p_cost_group_type_id IN NUMBER,
90 p_multi_org IN NUMBER DEFAULT 2);
91
92
93 ----------------------------------------------------------------------------
94 -- PROCEDURE --
95 -- get_cost_group_accounts --
96 -- --
97 -- DESCRIPTION --
98 -- Use this procedure to obatain cost groups based on account information.--
99 -- --
100 -- PURPOSE: --
101 -- Oracle Applications Rel 11i.2 --
102 -- --
103
104 -- HISTORY: --
105 -- 05/26/00 Sujit Dalai Created --
106 ----------------------------------------------------------------------------
107 PROCEDURE get_cost_group_accounts(x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 x_material_account OUT NOCOPY NUMBER,
111 x_material_overhead_account OUT NOCOPY NUMBER,
112 x_resource_account OUT NOCOPY NUMBER,
113 x_overhead_account OUT NOCOPY NUMBER,
114 x_outside_processing_account OUT NOCOPY NUMBER,
115 x_expense_account OUT NOCOPY NUMBER,
116 x_encumbrance_account OUT NOCOPY NUMBER,
117 x_average_cost_var_account OUT NOCOPY NUMBER,
118 x_payback_mat_var_account OUT NOCOPY NUMBER,
119 x_payback_res_var_account OUT NOCOPY NUMBER,
120 x_payback_osp_var_account OUT NOCOPY NUMBER,
121 x_payback_moh_var_account OUT NOCOPY NUMBER,
122 x_payback_ovh_var_account OUT NOCOPY NUMBER,
123 p_cost_group_id IN NUMBER,
124 p_organization_id IN NUMBER
125 );
126
127
128 ----------------------------------------------------------------------------
129 -- PROCEDURE --
130 -- verify_cg_change --
131 -- --
132 -- DESCRIPTION --
133 -- Use this procedure to verify if changing the accounts of a cost group--
134 -- is allowed. Replaces get_cg_pending_txns. --
135 ----------------------------------------------------------------------------
136
137 PROCEDURE verify_cg_change(x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 x_change_allowed OUT NOCOPY NUMBER,
141 p_cost_group_id IN NUMBER,
142 p_organization_id IN NUMBER);
143
144
145 end CSTPCGUT;