[Home] [Help]
PACKAGE: APPS.AHL_PP_RESRC_ASSIGN_PVT
Source
1 PACKAGE AHL_PP_RESRC_ASSIGN_PVT AS
2 /* $Header: AHLVASGS.pls 120.2 2005/07/06 06:19:17 rroy noship $*/
3
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7 TYPE Resrc_Assign_Rec_Type IS RECORD (
8 ASSIGNMENT_ID NUMBER ,
9 WORKORDER_ID NUMBER ,
10 WORKORDER_OPERATION_ID NUMBER ,
11
12 WIP_ENTITY_ID NUMBER ,
13 ORGANIZATION_ID NUMBER ,
14
15 OPERATION_SEQ_NUMBER NUMBER ,
16 RESOURCE_SEQ_NUMBER NUMBER ,
17
18 RESOURCE_TYPE_CODE NUMBER ,
19 RESOURCE_TYPE_NAME VARCHAR2(80) ,
20 OPER_RESOURCE_ID NUMBER ,
21 DEPARTMENT_ID NUMBER ,
22
23 EMPLOYEE_ID NUMBER ,
24 EMPLOYEE_NUMBER VARCHAR2(30) ,
25 EMPLOYEE_NAME VARCHAR2(240) ,
26
27 INVENTORY_ITEM_ID NUMBER ,
28 ITEM_ORGANIZATION_ID NUMBER ,
29 SERIAL_NUMBER VARCHAR2(30) ,
30 INSTANCE_ID NUMBER ,
31
32 ASSIGN_START_DATE DATE ,
33 ASSIGN_START_HOUR NUMBER ,
34 ASSIGN_START_MIN NUMBER ,
35 ASSIGN_END_DATE DATE ,
36 ASSIGN_END_HOUR NUMBER ,
37 ASSIGN_END_MIN NUMBER ,
38
39 SELF_ASSIGNED_FLAG VARCHAR2(1) ,
40 LOGIN_DATE DATE ,
41
42 OBJECT_VERSION_NUMBER NUMBER ,
43 SECURITY_GROUP_ID NUMBER ,
44 LAST_UPDATE_LOGIN NUMBER ,
45 LAST_UPDATED_DATE DATE ,
46 LAST_UDDATED_BY NUMBER ,
47 CREATION_DATE DATE ,
48 CREATED_BY NUMBER ,
49 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
50 ATTRIBUTE1 VARCHAR2(150) ,
51 ATTRIBUTE2 VARCHAR2(150) ,
52 ATTRIBUTE3 VARCHAR2(150) ,
53 ATTRIBUTE4 VARCHAR2(150) ,
54 ATTRIBUTE5 VARCHAR2(150) ,
55 ATTRIBUTE6 VARCHAR2(150) ,
56 ATTRIBUTE7 VARCHAR2(150) ,
57 ATTRIBUTE8 VARCHAR2(150) ,
58 ATTRIBUTE9 VARCHAR2(150) ,
59 ATTRIBUTE10 VARCHAR2(150) ,
60 ATTRIBUTE11 VARCHAR2(150) ,
61 ATTRIBUTE12 VARCHAR2(150) ,
62 ATTRIBUTE13 VARCHAR2(150) ,
63 ATTRIBUTE14 VARCHAR2(150) ,
64 ATTRIBUTE15 VARCHAR2(150) ,
65 OPERATION_FLAG VARCHAR2(1)
66 );
67
68 TYPE Resrc_Assign_Tbl_Type IS TABLE OF Resrc_Assign_Rec_Type INDEX BY BINARY_INTEGER;
69
70 ------------------------
71 -- Declare Procedures --
72 ------------------------
73
74 -- Start of Comments --
75 -- Procedure name : Process_Resrc_Assign
76 -- Type : Private
77 -- Function : Manages Create/Modify/Delete material requirements for routine and
78 -- non routine operations associated to a job.
79 -- Pre-reqs :
80 -- Parameters :
81 --
82 -- Standard IN Parameters :
83 -- p_api_version IN NUMBER Required
84 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
86 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87 -- Based on this flag, the API will set the default attributes.
88 -- p_module_type In VARCHAR2 Default NULL
89 -- This will be null.
90 -- Standard OUT Parameters :
91 -- x_return_status OUT VARCHAR2 Required
92 -- x_msg_count OUT NUMBER Required
93 -- x_msg_data OUT VARCHAR2 Required
94 --
95 -- Process_Resrc_Assign Parameters :
96 -- p_x_resrc_assign_tbl IN OUT Ahl_PP_Resrc_Assign_Pvt.Resrc_Assign_Tbl_Type,Required
97 -- List of Resource Assigned for a job
98 --
99
100 PROCEDURE Process_Resrc_Assign (
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
103 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
104 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
105 p_module_type IN VARCHAR2 := NULL,
106 p_operation_flag IN VARCHAR2,
107 p_x_resrc_assign_tbl IN OUT NOCOPY AHL_PP_RESRC_ASSIGN_PVT.Resrc_Assign_Tbl_Type,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111
112 );
113
114 END AHL_PP_RESRC_ASSIGN_PVT;