[Home] [Help]
PACKAGE: APPS.AHL_PP_RESRC_REQUIRE_PVT
Source
1 PACKAGE AHL_PP_RESRC_REQUIRE_PVT AS
2 /* $Header: AHLVREQS.pls 120.1.12010000.3 2008/12/28 01:54:13 sracha 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
20 DEPARTMENT_ID NUMBER ,
21 DEPARTMENT_NAME VARCHAR2(240) ,
22
23 RESOURCE_TYPE_CODE NUMBER ,
24 RESOURCE_TYPE_NAME VARCHAR2(80) ,
25
26 RESOURCE_ID NUMBER ,
27 RESOURCE_NAME VARCHAR2(80) ,
28
29 OPER_START_DATE DATE ,
30 OPER_END_DATE DATE ,
31
32 DURATION NUMBER ,
33 QUANTITY NUMBER ,
34 SET_UP NUMBER ,
35
36 UOM_CODE VARCHAR2(3) ,
37 UOM_NAME VARCHAR2(30) ,
38
39 COST_BASIS_CODE NUMBER ,
40 COST_BASIS_NAME VARCHAR2(80) ,
41
42 CHARGE_TYPE_CODE NUMBER ,
43 CHARGE_TYPE_NAME VARCHAR2(80) ,
44
45 SCHEDULED_TYPE_CODE NUMBER ,
46 SCHEDULED_TYPE_NAME VARCHAR2(80) ,
47
48 STD_RATE_FLAG_CODE NUMBER ,
49 STD_RATE_FLAG_NAME VARCHAR2(80) ,
50
51 TOTAL_REQUIRED NUMBER ,
52 APPLIED_NUM NUMBER ,
53 OPEN_NUM NUMBER ,
54
55 REQ_START_DATE DATE ,
56 REQ_END_DATE DATE ,
57
58 OBJECT_VERSION_NUMBER NUMBER ,
59 SECURITY_GROUP_ID NUMBER ,
60 LAST_UPDATE_LOGIN NUMBER ,
61 LAST_UPDATED_DATE DATE ,
62 LAST_UDDATED_BY NUMBER ,
63 CREATION_DATE DATE ,
64 CREATED_BY NUMBER ,
65 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
66 ATTRIBUTE1 VARCHAR2(150) ,
67 ATTRIBUTE2 VARCHAR2(150) ,
68 ATTRIBUTE3 VARCHAR2(150) ,
69 ATTRIBUTE4 VARCHAR2(150) ,
70 ATTRIBUTE5 VARCHAR2(150) ,
71 ATTRIBUTE6 VARCHAR2(150) ,
72 ATTRIBUTE7 VARCHAR2(150) ,
73 ATTRIBUTE8 VARCHAR2(150) ,
74 ATTRIBUTE9 VARCHAR2(150) ,
75 ATTRIBUTE10 VARCHAR2(150) ,
76 ATTRIBUTE11 VARCHAR2(150) ,
77 ATTRIBUTE12 VARCHAR2(150) ,
78 ATTRIBUTE13 VARCHAR2(150) ,
79 ATTRIBUTE14 VARCHAR2(150) ,
80 ATTRIBUTE15 VARCHAR2(150) ,
81 OPERATION_FLAG VARCHAR2(1) ,
82 IS_UNIT_LOCKED VARCHAR2(1)
83 );
84
85 TYPE Resrc_Require_Tbl_Type IS TABLE OF Resrc_Require_Rec_Type INDEX BY BINARY_INTEGER;
86
87 ------------------------
88 -- Declare Procedures --
89 ------------------------
90
91 -- Start of Comments --
92 -- Procedure name : Process_Resrc_Require
93 -- Type : Private
94 -- Function : Manages Create/Modify/Delete material requirements for routine and
95 -- non routine operations associated to a job.
96 -- Pre-reqs :
97 -- Parameters :
98 --
99 -- Standard IN Parameters :
100 -- p_api_version IN NUMBER Required
101 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104 -- Based on this flag, the API will set the default attributes.
105 -- p_module_type In VARCHAR2 Default NULL
106 -- This will be null.
107 -- Standard OUT Parameters :
108 -- x_return_status OUT NOCOPY VARCHAR2 Required
109 -- x_msg_count OUT NOCOPY NUMBER Required
110 -- x_msg_data OUT NOCOPY VARCHAR2 Required
111 --
112 -- Process_Resrc_Require Parameters :
113 -- p_x_resrc_Require_tbl IN OUT Ahl_PP_Resrc_Require_Pvt.Resrc_Require_Tbl_Type,Required
114 -- List of Resource Requireed for a job
115 --
116
117 PROCEDURE Process_Resrc_Require (
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
120 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
121 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
122 p_module_type IN VARCHAR2 := NULL,
123 p_operation_flag IN VARCHAR2,
124 p_interface_flag IN VARCHAR2,
125 p_x_Resrc_Require_tbl IN OUT NOCOPY AHL_PP_RESRC_Require_PVT.Resrc_Require_Tbl_Type,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129
130 );
131
132 END AHL_PP_RESRC_REQUIRE_PVT;