1 PACKAGE gmp_wps_writer AUTHID CURRENT_USER AS
2 /* $Header: GMPWPSWS.pls 120.1 2005/08/17 13:59:56 rpatangy noship $ */
3
4 TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 /* Global value variables */
6
7 /* Variables for document types */
8 v_doc_prod VARCHAR2(4) := 'PROD';
9
10
11 /* Procedure to update the batch header after the WPS scheduler has completed */
12 PROCEDURE update_batch_header(
13 pbatch_id IN NUMBER,
14 pstart_date IN NUMBER,
15 pend_date IN NUMBER,
16 plast_update IN NUMBER,
17 phorizon IN NUMBER,
18 puser_id IN NUMBER,
19 plogin_id IN NUMBER,
20 return_status OUT NOCOPY NUMBER);
21
22 /* Procedure to update the batch steps after the WPS scheduler has completed */
23 PROCEDURE update_batch_steps(
24 pbatch_id IN NUMBER,
25 pstep_no IN NUMBER_TBL_TYPE,
26 pstep_id IN NUMBER_TBL_TYPE,
27 pstart_date IN NUMBER_TBL_TYPE,
28 pend_date IN NUMBER_TBL_TYPE,
29 plast_update IN NUMBER_TBL_TYPE,
30 phorizon IN NUMBER,
31 puser_id IN NUMBER,
32 plogin_id IN NUMBER,
33 pnum_rows IN NUMBER,
34 return_status OUT NOCOPY NUMBER);
35
36 /* Procedure to update the batch step activities after the WPS scheduler has
37 completed */
38 PROCEDURE update_batch_activities(
39 pbatch_id IN NUMBER,
40 pstep_id IN NUMBER,
41 pactivity_id IN NUMBER,
42 pstart_date IN NUMBER,
43 pend_date IN NUMBER,
44 plast_update IN NUMBER,
45 phorizon IN NUMBER,
46 puom_hour IN VARCHAR2,
47 puser_id IN NUMBER,
48 plogin_id IN NUMBER,
49 return_status OUT NOCOPY NUMBER);
50
51 /* Procedure to update the batch step resources after the WPS scheduler has
52 completed */
53 PROCEDURE update_batch_resources(
54 pbatch_id IN NUMBER,
55 pstep_id IN NUMBER_TBL_TYPE,
56 pact_res_id IN NUMBER_TBL_TYPE,
57 pres_usage IN NUMBER_TBL_TYPE,
58 presource_id IN NUMBER_TBL_TYPE,
59 psetup_id IN NUMBER_TBL_TYPE,
60 pstart_date IN NUMBER_TBL_TYPE,
61 pend_date IN NUMBER_TBL_TYPE,
62 plast_update IN NUMBER_TBL_TYPE,
63 pseq_dep_usage IN NUMBER_TBL_TYPE,
64 phorizon IN NUMBER,
65 puom_hour IN VARCHAR2,
66 puser_id IN NUMBER,
67 plogin_id IN NUMBER,
68 pres_rows IN NUMBER,
69 return_status OUT NOCOPY NUMBER,
70 pnew_act_res IN OUT NOCOPY NUMBER_TBL_TYPE);
71
72 /* Procedure to update the batch resource transactions after the WPS scheduler
73 has completed */
74 PROCEDURE update_resource_transactions(
75 pbatch_id IN NUMBER,
76 pact_res_id IN NUMBER_TBL_TYPE,
77 presource_id IN NUMBER_TBL_TYPE,
78 pinstance_id IN NUMBER_TBL_TYPE,
79 prsrc_count IN NUMBER_TBL_TYPE,
80 pseq_dep_ind IN NUMBER_TBL_TYPE,
81 pstart_date IN NUMBER_TBL_TYPE,
82 pend_date IN NUMBER_TBL_TYPE,
83 phorizon IN NUMBER,
84 puom_hour IN VARCHAR2,
85 puser_id IN NUMBER,
86 plogin_id IN NUMBER,
87 pres_rows IN NUMBER,
88 ptrn_rows IN NUMBER,
89 return_status OUT NOCOPY NUMBER,
90 porig_act_res IN NUMBER_TBL_TYPE,
91 pnew_act_res IN NUMBER_TBL_TYPE);
92
93 /* Procedure to update the batch resource instances transactions after the
94 WPS scheduler has completed */
95 PROCEDURE update_operation_resources(
96 pbatch_id IN NUMBER,
97 pactivity_id IN NUMBER,
98 pact_start_date IN NUMBER,
99 pact_end_date IN NUMBER,
100 pact_last_update IN NUMBER,
101 pstep_id IN NUMBER_TBL_TYPE,
102 pact_res_id IN NUMBER_TBL_TYPE,
103 presource_id IN NUMBER_TBL_TYPE,
104 presource_usage IN NUMBER_TBL_TYPE,
105 psetup_id IN NUMBER_TBL_TYPE,
106 pres_start_date IN NUMBER_TBL_TYPE,
107 pres_end_date IN NUMBER_TBL_TYPE,
108 plast_update IN NUMBER_TBL_TYPE,
109 pseq_dep_usage IN NUMBER_TBL_TYPE,
110 ptrn_act_res_id IN NUMBER_TBL_TYPE,
111 ptrn_resource_id IN NUMBER_TBL_TYPE,
112 ptrn_rsrc_count IN NUMBER_TBL_TYPE,
113 ptrn_seq_dep IN NUMBER_TBL_TYPE,
114 ptrn_start_date IN NUMBER_TBL_TYPE,
115 ptrn_end_date IN NUMBER_TBL_TYPE,
116 ptrn_instance_id IN NUMBER_TBL_TYPE,
117 phorizon IN NUMBER,
118 puom_hour IN VARCHAR2,
119 puser_id IN NUMBER,
120 plogin_id IN NUMBER,
121 pres_rows IN NUMBER,
122 ptrn_rows IN NUMBER,
123 return_status OUT NOCOPY NUMBER);
124
125 /* Procedure to lock the batch header and details after the WPS scheduler
126 has completed */
127 PROCEDURE lock_batch_details(
128 pbatch_id IN NUMBER,
129 return_status OUT NOCOPY NUMBER);
130
131 PROCEDURE log_message(
132 pbuff IN VARCHAR2);
133
134 FUNCTION get_wps_atr(
135 p_organization_id IN NUMBER
136 ,p_inventory_item_id IN NUMBER ) RETURN NUMBER ;
137
138 FUNCTION get_wps_onhand(
139 p_organization_id IN NUMBER
140 ,p_inventory_item_id IN NUMBER ) RETURN NUMBER ;
141
142 END gmp_wps_writer;