1 Package AHL_PRD_WORKORDER_CUHK AS
2 /*$Header: AHLCPRJS.pls 120.0.12010000.1 2009/01/12 23:32:49 sikumar noship $*/
3
4 ------------------------
5 -- Declare Procedures --
6 ------------------------
7 -- Start of Comments --
8 --
9 -- Procedure name : CREATE_JOB_PRE
10 -- Type : Public
11 -- Function : Provide User Hooks for the customer to add validations before CREATE_JOB function call
12 -- Pre-reqs :
13 --
14 -- Standard IN Parameters :
15 --
16 -- Standard OUT Parameters :
17 -- x_return_status OUT VARCHAR2 Required
18 -- x_msg_count OUT NUMBER Required
19 -- x_msg_data OUT VARCHAR2 Required
20 --
21 -- CREATE_JOB_PRE Parameters :
22 -- p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec Required
23 --
24 -- Version :
25 -- Initial Version 1.0
26 --
27 -- End of Comments --
28
29 PROCEDURE CREATE_JOB_PRE
30 (
31 p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
32 x_return_status OUT NOCOPY VARCHAR2 ,
33 x_msg_count OUT NOCOPY NUMBER ,
34 x_msg_data OUT NOCOPY VARCHAR2
35 );
36
37 -- Start of Comments --
38 --
39 -- Procedure name : CREATE_JOB_POST
40 -- Type : Public
41 -- Function : Provide User Hooks for the customer to add validations after CREATE_JOB function call
42 -- Pre-reqs :
43 --
44 -- Standard IN Parameters :
45 --
46 -- Standard OUT Parameters :
47 -- x_return_status OUT VARCHAR2 Required
48 -- x_msg_count OUT NUMBER Required
49 -- x_msg_data OUT VARCHAR2 Required
50 --
51 -- CREATE_JOB_POST Parameters :
52 -- p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec Required
53 -- p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl Required
54 -- p_resource_tbl IN AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type Required
55 -- p_material_tbl IN AHL_PP_MATERIALS_PVT.req_material_tbl_type Required Required
56 --
57 -- Version :
58 -- Initial Version 1.0
59 --
60 -- End of Comments --
61
62 PROCEDURE CREATE_JOB_POST
63 (
64 p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
65 p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
66 p_resource_tbl IN AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
67 p_material_tbl IN AHL_PP_MATERIALS_PVT.req_material_tbl_type,
68 x_return_status OUT NOCOPY VARCHAR2 ,
69 x_msg_count OUT NOCOPY NUMBER ,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 -- Start of Comments --
74 --
75 -- Procedure name : UPDATE_JOB_PRE
76 -- Type : Public
77 -- Function : Provide User Hooks for the customer to add validations before UPDATE_JOB_PRE function call
78 -- Pre-reqs :
79 --
80 -- Standard IN Parameters :
81 --
82 -- Standard OUT Parameters :
83 -- x_return_status OUT VARCHAR2 Required
84 -- x_msg_count OUT NUMBER Required
85 -- x_msg_data OUT VARCHAR2 Required
86 --
87 -- UPDATE_JOB_PRE Parameters :
88 -- p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec Required
89 -- p_prd_workoper_tbl IN AHL_PRD_WORKORDER_PVT.prd_workoper_tbl Required
90 --
91 -- Version :
92 -- Initial Version 1.0
93 --
94 -- End of Comments --
95
96 PROCEDURE UPDATE_JOB_PRE
97 (
98 p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
99 p_prd_workoper_tbl IN AHL_PRD_WORKORDER_PVT.prd_workoper_tbl,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2
103 );
104
105 -- Start of Comments --
106 --
107 -- Procedure name : UPDATE_JOB_PRE
108 -- Type : Public
109 -- Function : Provide User Hooks for the customer to add validations after UPDATE_JOB_PRE function call
110 -- Pre-reqs :
111 --
112 -- Standard IN Parameters :
113 --
114 -- Standard OUT Parameters :
115 -- x_return_status OUT VARCHAR2 Required
116 -- x_msg_count OUT NUMBER Required
117 -- x_msg_data OUT VARCHAR2 Required
118 --
119 -- UPDATE_JOB_PRE Parameters :
120 -- p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec Required
121 -- p_prd_workoper_tbl IN AHL_PRD_WORKORDER_PVT.prd_workoper_tbl Required
122 --
123 -- Version :
124 -- Initial Version 1.0
125 --
126 -- End of Comments --
127
128 PROCEDURE UPDATE_JOB_POST
129 (
130 p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
131 p_prd_workoper_tbl IN AHL_PRD_WORKORDER_PVT.prd_workoper_tbl,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137
138 END AHL_PRD_WORKORDER_CUHK;