[Home] [Help]
PACKAGE: APPS.CST_EAMJOB_ACTESTIMATE
Source
1 PACKAGE CST_EAMJOB_ACTESTIMATE AUTHID CURRENT_USER AS
2 /* $Header: CSTPJACS.pls 115.0 2002/11/05 23:06:27 awwang noship $ */
3
4 /* ============================================================== */
5 -- FUNCTION
6 -- Get_eamCostElement()
7 --
8 -- DESCRIPTION
9 -- Function to return the correct eAM cost element, based on
10 -- the transaction mode and the resource id of a transaction.
11 --
12 -- PARAMETERS
13 -- p_txn_mode (1=material, 2=resource)
14 -- p_org_id
15 -- p_resource_id (optional; to be passed only for a resource tranx)
16 --
17 /* ================================================================= */
18
19 FUNCTION Get_eamCostElement(
20 p_txn_mode IN NUMBER,
21 p_org_id IN NUMBER,
22 p_resource_id IN NUMBER := NULL)
23 RETURN number;
24
25 TYPE ActivityEstimateRec IS RECORD
26 (
27 record_type NUMBER,
28 organization_id NUMBER,
29 activity_item_id NUMBER,
30 resource_id NUMBER,
31 overhead_id NUMBER,
32 op_seq_num NUMBER,
33 maint_cost_catg NUMBER,
34 eam_cost_element NUMBER,
35 cost_value NUMBER
36 );
37
38
39 TYPE ActivityEstimateTable IS TABLE OF ActivityEstimateRec;
40
41 ---------------------------------------------------------------------------
42 -- PROCEDURE --
43 -- Get_DeptCostCatg --
44 -- --
45 -- --
46 -- DESCRIPTION --
47 -- This API returns the cost category of the department --
48
49 -- --
50 -- PURPOSE: --
51 -- Oracle Applications Rel 11i.6 --
55 -- 04/17/01 Hemant G Created --
52 -- --
53 -- --
54 -- HISTORY: --
56 ----------------------------------------------------------------------------
57 PROCEDURE Get_DeptCostCatg (
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2
60 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2
62 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER
64 := FND_API.G_VALID_LEVEL_FULL,
65 p_debug IN VARCHAR2 := 'N',
66
67 p_department_id IN NUMBER := NULL,
71 p_request_id IN NUMBER,
68 p_organization_id IN NUMBER := NULL,
69
70 p_user_id IN NUMBER,
72 p_prog_id IN NUMBER,
73 p_prog_app_id IN NUMBER,
74 p_login_id IN NUMBER,
75
76 x_dept_cost_catg OUT NOCOPY NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2 );
80
81 --------------------------------------------------------------------------n
82 -- PROCEDURE --
83 -- Compute_Activity_Estimate --
84 -- --
85 -- --
86
87 -- --
88 -- DESCRIPTION --
89 -- This API Computes the estimate for a an asset activity --
90 -- --
91 -- PURPOSE: --
92 -- Oracle Applications Rel 11i.6 --
93 -- --
94 -- --
95 -- HISTORY: --
96 -- 04/17/01 Hemant G Created --
97 ----------------------------------------------------------------------------
98 PROCEDURE Compute_Activity_Estimate (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2
101 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2
103 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER
105 := FND_API.G_VALID_LEVEL_FULL,
106 p_debug IN VARCHAR2 := 'N',
107
108 p_activity_item_id IN NUMBER,
109 p_organization_id IN NUMBER,
110 p_alt_bom_designator IN VARCHAR2 := NULL,
111 p_alt_rtg_designator IN VARCHAR2 := NULL,
112 p_cost_group_id IN NUMBER := NULL,
113 p_effective_datetime IN VARCHAR2 :=
114 fnd_date.date_to_canonical(SYSDATE),
115
116 p_user_id IN NUMBER,
117 p_request_id IN NUMBER,
118 p_prog_id IN NUMBER,
119 p_prog_app_id IN NUMBER,
120 p_login_id IN NUMBER,
121
122 x_ActivityEstimateTable OUT NOCOPY ActivityEstimateTable,
123 x_return_status OUT NOCOPY VARCHAR2,
124
125 x_msg_count OUT NOCOPY NUMBER,
129
126 x_msg_data OUT NOCOPY VARCHAR2 );
127
128
130 ---------------------------------------------------------------------------
131 -- PROCEDURE --
132 -- Get_Activity_Estimate --
133 -- --
134 -- --
135 -- DESCRIPTION --
136 -- This API Computes the estimate for an asset activity --
137 -- --
138 -- PURPOSE: --
139 -- Oracle Applications Rel 11i.9 --
140 -- --
141 -- --
142
143 -- --
144 -- --
145 -- HISTORY: --
149 p_api_version IN NUMBER,
146 -- 08/07/02 Hemant G Created --
147 ----------------------------------------------------------------------------
148 PROCEDURE Get_Activity_Estimate (
150 p_init_msg_list IN VARCHAR2
151 := FND_API.G_FALSE,
152 p_commit IN VARCHAR2
153 := FND_API.G_FALSE,
154 p_validation_level IN NUMBER
155 := FND_API.G_VALID_LEVEL_FULL,
156 p_debug IN VARCHAR2 := 'N',
157
158 p_activity_item_id IN NUMBER,
159 p_organization_id IN NUMBER,
160 p_alt_bom_designator IN VARCHAR2 := NULL,
161 p_alt_rtg_designator IN VARCHAR2 := NULL,
162 p_cost_group_id IN NUMBER := NULL,
163 p_effective_datetime IN VARCHAR2 :=
164 fnd_date.date_to_canonical(SYSDATE),
165
166 p_user_id IN NUMBER,
167 p_request_id IN NUMBER,
168 p_prog_id IN NUMBER,
169 p_prog_app_id IN NUMBER,
170 p_login_id IN NUMBER,
171
172 x_activity_estimate_record_id OUT NOCOPY NUMBER,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2 );
176
177
178 END CST_EAMJOB_ACTESTIMATE;
179