[Home] [Help]
PACKAGE: APPS.AHL_RA_NR_PROFILE_PVT
Source
1 PACKAGE AHL_RA_NR_PROFILE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVNRPS.pls 120.0.12020000.2 2012/12/07 01:12:39 sareepar noship $ */
3 -- Global variables to access
4 G_RESOURCE CONSTANT VARCHAR2(1):= 'R';
5 G_ITEM CONSTANT VARCHAR2(1):= 'I';
6
7 -- Record for Nonroutine Profile Header
8 TYPE nr_prof_header_rec_type IS RECORD
9 (
10 NR_PROFILE_HEADER_ID NUMBER,
11 OBJECT_VERSION_NUMBER NUMBER,
12 LAST_UPDATE_DATE DATE,
13 LAST_UPDATED_BY NUMBER,
14 CREATION_DATE DATE,
15 CREATED_BY NUMBER,
16 LAST_UPDATE_LOGIN NUMBER,
17 MR_TITLE VARCHAR2(80),
18 STATUS_CODE VARCHAR2(30),
19 IDENT_SEQ_THIRD VARCHAR2(30),
20 IDENT_SEQ_FOURTH VARCHAR2(30),
21 SECURITY_GROUP_ID NUMBER,
22 ATTRIBUTE_CATEGORY VARCHAR2(30),
23 ATTRIBUTE1 VARCHAR2(150),
24 ATTRIBUTE2 VARCHAR2(150),
25 ATTRIBUTE3 VARCHAR2(150),
26 ATTRIBUTE4 VARCHAR2(150),
27 ATTRIBUTE5 VARCHAR2(150),
28 ATTRIBUTE6 VARCHAR2(150),
29 ATTRIBUTE7 VARCHAR2(150),
30 ATTRIBUTE8 VARCHAR2(150),
31 ATTRIBUTE9 VARCHAR2(150),
32 ATTRIBUTE10 VARCHAR2(150),
33 ATTRIBUTE11 VARCHAR2(150),
34 ATTRIBUTE12 VARCHAR2(150),
35 ATTRIBUTE13 VARCHAR2(150),
36 ATTRIBUTE14 VARCHAR2(150),
37 ATTRIBUTE15 VARCHAR2(150),
38 DML_OPERATION VARCHAR2(1)
39 );
40
41 -- Record for Nonroutine Profile Estimates
42 TYPE nr_prof_est_rec_type IS RECORD
43 (
44 NR_PROFILE_DET_ID NUMBER,
45 OBJECT_VERSION_NUMBER NUMBER,
46 LAST_UPDATE_DATE DATE,
47 LAST_UPDATED_BY NUMBER,
48 CREATION_DATE DATE,
49 CREATED_BY NUMBER,
50 LAST_UPDATE_LOGIN NUMBER,
51 NR_PROFILE_HEADER_ID NUMBER,
52 STAGE_TYPE_CODE VARCHAR2(30),
53 STAGE_TYPE VARCHAR2(80),
54 INVENTORY_ITEM_ID NUMBER,
55 INVENTORY_ITEM VARCHAR2(240),
56 UOM_CODE VARCHAR2(30),
57 UOM VARCHAR2(80),
58 CMRO_RESOURCE_ID NUMBER,
59 CMRO_RESOURCE_NAME VARCHAR2(240),
60 CMRO_RESOURCE_TYPE VARCHAR2(80),
61 ANALYSIS_QTY NUMBER,
62 REQUIRED_QTY NUMBER,
63 FLEET_HEADER_ID NUMBER,
64 FLEET_NAME VARCHAR2(150),
65 OPERATING_ORG_ID NUMBER,
66 OPERATING_ORG_NAME VARCHAR2(150),
67 OPERATIONS_TYPE_CODE VARCHAR2(30),
68 OPERATIONS_TYPE VARCHAR2(80),
69 DEMANTRA_UPDATED_DATE DATE,
70 EXCLUDED_DATE DATE,
71 SECURITY_GROUP_ID NUMBER,
72 PROFILE_DETAIL_TYPE VARCHAR2(1),
73 DML_OPERATION VARCHAR2(1)
74 );
75
76 TYPE nr_prof_est_tbl_type IS TABLE OF nr_prof_est_rec_type INDEX BY BINARY_INTEGER;
77
78 -- Record for Nonroutine Profile Identification Resource Details
79 TYPE nrp_res_req_rec_type IS RECORD
80 (
81 NR_PROFILE_DET_ID NUMBER,
82 CMRO_RESOURCE_ID NUMBER,
83 DURATION NUMBER,
84 STAGE_TYPE_CODE VARCHAR2(30)
85 );
86
87 TYPE nrp_res_req_tbl_type IS TABLE OF nrp_res_req_rec_type INDEX BY BINARY_INTEGER;
88
89 -- Record for Nonroutine Profile Identification Material Details
90 TYPE nrp_mat_req_rec_type IS RECORD
91 (
92 NR_PROFILE_DET_ID NUMBER,
93 INVENTORY_ITEM_ID NUMBER,
94 QUANTITY NUMBER,
95 UOM_CODE VARCHAR2(30),
96 STAGE_TYPE_CODE VARCHAR2(30)
97 );
98
99 TYPE nrp_mat_req_tbl_type IS TABLE OF nrp_mat_req_rec_type INDEX BY BINARY_INTEGER;
100
101 --Procedure for for Nonroutine Profile Identification Resource Details
102 PROCEDURE populate_prof_res_req
103 (
104 p_mr_header_id IN NUMBER,
105 p_instance_id IN NUMBER,
106 p_ue_id IN NUMBER,
107 p_plan_id IN NUMBER,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 x_prof_res_req_tbl OUT NOCOPY nrp_res_req_tbl_type
112 );
113
114 -- Procedure to Nonroutine Profile Identification Material Details
115 PROCEDURE populate_prof_mat_req
116 (
117 p_mr_header_id IN NUMBER,
118 p_instance_id IN NUMBER,
119 p_ue_id IN NUMBER,
120 p_plan_id IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 x_prof_mat_req_tbl OUT NOCOPY nrp_mat_req_tbl_type
125 );
126
127 -- Prcoess the Nonroutine Profile
128 -- Create/Update/Delete
129 PROCEDURE process_nr_profile
130 (
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
133 p_commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_x_nr_profile_header_rec IN OUT NOCOPY nr_prof_header_rec_type
139 );
140
141 -- Procedure to add Nonroutine Profile Estimates to Profile
142 PROCEDURE add_details_to_prof
143 (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_x_nr_prof_est_tbl IN OUT NOCOPY nr_prof_est_tbl_type
152 );
153
154 -- Returns Resource Type
155 FUNCTION get_resource_type
156 RETURN VARCHAR2;
157
158 -- Returns Item Type
159 FUNCTION get_item_type
160 RETURN VARCHAR2;
161
162 END AHL_RA_NR_PROFILE_PVT;