1 PACKAGE AHL_PP_RESRC_REQUIRE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVREQS.pls 120.5.12020000.2 2012/12/07 13:33:40 sareepar ship $*/
3
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7 TYPE Resrc_Require_Rec_Type IS RECORD (
8 OPERATION_RESOURCE_ID NUMBER ,
9 RESOURCE_SEQ_NUMBER NUMBER ,
10 OPERATION_SEQ_NUMBER NUMBER ,
11 --JKJAIN US space FP for ER # 6998882 -- start
12 SCHEDULE_SEQ_NUM NUMBER ,
13 --JKJAIN US space FP for ER # 6998882 -- end
14 WORKORDER_ID NUMBER ,
15 JOB_NUMBER VARCHAR2(80) ,
16 WIP_ENTITY_ID NUMBER ,
17 WORKORDER_OPERATION_ID NUMBER ,
18 ORGANIZATION_ID NUMBER ,
19 --SUKHWSIN ER# 9014609 -start
20 RT_OPER_RESOURCE_ID NUMBER ,
21 --SUKHWSIN ER# 9014609 -end
22
23 DEPARTMENT_ID NUMBER ,
24 DEPARTMENT_NAME VARCHAR2(240) ,
25
26 RESOURCE_TYPE_CODE NUMBER ,
27 RESOURCE_TYPE_NAME VARCHAR2(80) ,
28
29 RESOURCE_ID NUMBER ,
30 RESOURCE_NAME VARCHAR2(80) ,
31
32 OPER_START_DATE DATE ,
33 OPER_END_DATE DATE ,
34
35 DURATION NUMBER ,
36 QUANTITY NUMBER ,
37 SET_UP NUMBER ,
38
39 UOM_CODE VARCHAR2(3) ,
40 UOM_NAME VARCHAR2(30) ,
41
42 COST_BASIS_CODE NUMBER ,
43 COST_BASIS_NAME VARCHAR2(80) ,
44
45 CHARGE_TYPE_CODE NUMBER ,
46 CHARGE_TYPE_NAME VARCHAR2(80) ,
47
48 SCHEDULED_TYPE_CODE NUMBER ,
49 SCHEDULED_TYPE_NAME VARCHAR2(80) ,
50
51 STD_RATE_FLAG_CODE NUMBER ,
52 STD_RATE_FLAG_NAME VARCHAR2(80) ,
53
54 TOTAL_REQUIRED NUMBER ,
55 APPLIED_NUM NUMBER ,
56 OPEN_NUM NUMBER ,
57
58 REQ_START_DATE DATE ,
59 REQ_END_DATE DATE ,
60
61 OBJECT_VERSION_NUMBER NUMBER ,
62 SECURITY_GROUP_ID NUMBER ,
63 LAST_UPDATE_LOGIN NUMBER ,
64 LAST_UPDATED_DATE DATE ,
65 LAST_UDDATED_BY NUMBER ,
66 CREATION_DATE DATE ,
67 CREATED_BY NUMBER ,
68 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
69 ATTRIBUTE1 VARCHAR2(150) ,
70 ATTRIBUTE2 VARCHAR2(150) ,
71 ATTRIBUTE3 VARCHAR2(150) ,
72 ATTRIBUTE4 VARCHAR2(150) ,
73 ATTRIBUTE5 VARCHAR2(150) ,
74 ATTRIBUTE6 VARCHAR2(150) ,
75 ATTRIBUTE7 VARCHAR2(150) ,
76 ATTRIBUTE8 VARCHAR2(150) ,
77 ATTRIBUTE9 VARCHAR2(150) ,
78 ATTRIBUTE10 VARCHAR2(150) ,
79 ATTRIBUTE11 VARCHAR2(150) ,
80 ATTRIBUTE12 VARCHAR2(150) ,
81 ATTRIBUTE13 VARCHAR2(150) ,
82 ATTRIBUTE14 VARCHAR2(150) ,
83 ATTRIBUTE15 VARCHAR2(150) ,
84 OPERATION_FLAG VARCHAR2(1) ,
85 IS_UNIT_LOCKED VARCHAR2(1)
86
87 );
88
89 TYPE Resrc_Require_Tbl_Type IS TABLE OF Resrc_Require_Rec_Type INDEX BY BINARY_INTEGER;
90
91 ------------------------
92 -- Declare Procedures --
93 ------------------------
94
95 -- Start of Comments --
96 -- Procedure name : Process_Resrc_Require
97 -- Type : Private
98 -- Function : Manages Create/Modify/Delete material requirements for routine and
99 -- non routine operations associated to a job.
100 -- Pre-reqs :
101 -- Parameters :
102 --
103 -- Standard IN Parameters :
104 -- p_api_version IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
106 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
107 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
108 -- Based on this flag, the API will set the default attributes.
109 -- p_module_type In VARCHAR2 Default NULL
110 -- This will be null.
111 -- Standard OUT Parameters :
112 -- x_return_status OUT NOCOPY VARCHAR2 Required
113 -- x_msg_count OUT NOCOPY NUMBER Required
114 -- x_msg_data OUT NOCOPY VARCHAR2 Required
115 --
116 -- Process_Resrc_Require Parameters :
117 -- p_x_resrc_Require_tbl IN OUT Ahl_PP_Resrc_Require_Pvt.Resrc_Require_Tbl_Type,Required
118 -- List of Resource Requireed for a job
119 --
120
121 PROCEDURE Process_Resrc_Require (
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
124 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
125 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
126 p_module_type IN VARCHAR2 := NULL,
127 p_operation_flag IN VARCHAR2,
128 p_interface_flag IN VARCHAR2,
129 p_x_Resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133
134 );
135
136 -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- start
137 --------------------------------------------------------------------------------------------------
138 -- Procedure added for Bug # 8329755 (FP for Bug # 7697909)
139 -- This procedure expands Master Work Order scheduled dates such that there is enough space
140 -- for child work orders to expand and add resource requirement.
141 -- This process of expanding the work orders is needed only for Planned Work Order
142 -- due to the fact that scheduling for planned work orders is done by EAM, and EAM
143 -- does not take care of expanding Master work orders.
144 --------------------------------------------------------------------------------------------------
145 PROCEDURE Expand_Master_Wo_Dates(
146 l_Resrc_Require_Rec IN OUT NOCOPY Resrc_Require_Rec_Type
147 );
148 -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
149
150 END AHL_PP_RESRC_REQUIRE_PVT;