eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_SWORKBENCH_PVT dependencies on GMO_DISPENSING_PLANNING

Line 18: gmo_dispensing_planning_rec GMO_DISPENSING_PLANNING%ROWTYPE;

14: P_DISPENSE_TYPE IN VARCHAR2,
15: P_DISPENSE_AREA_ID IN NUMBER,
16: P_DISP_ORG_ID IN NUMBER
17: ) is
18: gmo_dispensing_planning_rec GMO_DISPENSING_PLANNING%ROWTYPE;
19: task_id GMO_DISPENSING_PLANNING.PLANNED_TASK_ID%TYPE;
20: l_count number;
21: l_total_disp_count NUMBER;
22: l_total_unplanned_count NUMBER;

Line 19: task_id GMO_DISPENSING_PLANNING.PLANNED_TASK_ID%TYPE;

15: P_DISPENSE_AREA_ID IN NUMBER,
16: P_DISP_ORG_ID IN NUMBER
17: ) is
18: gmo_dispensing_planning_rec GMO_DISPENSING_PLANNING%ROWTYPE;
19: task_id GMO_DISPENSING_PLANNING.PLANNED_TASK_ID%TYPE;
20: l_count number;
21: l_total_disp_count NUMBER;
22: l_total_unplanned_count NUMBER;
23: L_CREATION_DATE DATE;

Line 31: CURSOR c_planning_rec_details (cp_reservation_id gmo_dispensing_planning_rec.RESERVATION_ID%TYPE,

27: L_LAST_UPDATE_LOGIN NUMBER;
28: L_DISP_AREA_ID NUMBER;
29:
30: --Bug 13545234
31: CURSOR c_planning_rec_details (cp_reservation_id gmo_dispensing_planning_rec.RESERVATION_ID%TYPE,
32: cp_dispense_id gmo_dispensing_planning_rec.DISPENSE_ID%TYPE) IS
33: select *
34: --into gmo_dispensing_planning_rec
35: from gmo_dispensing_planning

Line 32: cp_dispense_id gmo_dispensing_planning_rec.DISPENSE_ID%TYPE) IS

28: L_DISP_AREA_ID NUMBER;
29:
30: --Bug 13545234
31: CURSOR c_planning_rec_details (cp_reservation_id gmo_dispensing_planning_rec.RESERVATION_ID%TYPE,
32: cp_dispense_id gmo_dispensing_planning_rec.DISPENSE_ID%TYPE) IS
33: select *
34: --into gmo_dispensing_planning_rec
35: from gmo_dispensing_planning
36: where reservation_id = cp_reservation_id --P_RESERVATION_ID

Line 34: --into gmo_dispensing_planning_rec

30: --Bug 13545234
31: CURSOR c_planning_rec_details (cp_reservation_id gmo_dispensing_planning_rec.RESERVATION_ID%TYPE,
32: cp_dispense_id gmo_dispensing_planning_rec.DISPENSE_ID%TYPE) IS
33: select *
34: --into gmo_dispensing_planning_rec
35: from gmo_dispensing_planning
36: where reservation_id = cp_reservation_id --P_RESERVATION_ID
37: AND DISPENSE_ID = cp_dispense_id --P_DISPENSE_ID
38: and status ='DISPENSD';

Line 35: from gmo_dispensing_planning

31: CURSOR c_planning_rec_details (cp_reservation_id gmo_dispensing_planning_rec.RESERVATION_ID%TYPE,
32: cp_dispense_id gmo_dispensing_planning_rec.DISPENSE_ID%TYPE) IS
33: select *
34: --into gmo_dispensing_planning_rec
35: from gmo_dispensing_planning
36: where reservation_id = cp_reservation_id --P_RESERVATION_ID
37: AND DISPENSE_ID = cp_dispense_id --P_DISPENSE_ID
38: and status ='DISPENSD';
39:

Line 43: select count(*) into l_count from gmo_dispensing_planning

39:
40:
41: BEGIN
42:
43: select count(*) into l_count from gmo_dispensing_planning
44: where reservation_id = P_RESERVATION_ID
45: and status = 'PLANNED';
46: if (l_count > 0) then -- for planned dispense and partial dispenses /MAIN IF/
47: if ( P_DISPENSE_TYPE = 'DISPENSE' ) THEN --DISPENSE IF

Line 48: update gmo_dispensing_planning

44: where reservation_id = P_RESERVATION_ID
45: and status = 'PLANNED';
46: if (l_count > 0) then -- for planned dispense and partial dispenses /MAIN IF/
47: if ( P_DISPENSE_TYPE = 'DISPENSE' ) THEN --DISPENSE IF
48: update gmo_dispensing_planning
49: set
50: status = 'DISPENSD',
51: dispense_id = P_DISPENSE_ID,
52: dispensed_date = P_DISPENSED_DATE

Line 59: select * into gmo_dispensing_planning_rec from gmo_dispensing_planning

55: -- for partial dispense
56: elsif ( P_DISPENSE_TYPE = 'PDISPENSE' ) then
57:
58: --copy the record
59: select * into gmo_dispensing_planning_rec from gmo_dispensing_planning
60: where reservation_id = P_RESERVATION_ID
61: and status ='PLANNED';
62:
63: --change the status to dispensed

Line 64: update gmo_dispensing_planning

60: where reservation_id = P_RESERVATION_ID
61: and status ='PLANNED';
62:
63: --change the status to dispensed
64: update gmo_dispensing_planning
65: set
66: status = 'DISPENSD',
67: dispense_id = P_DISPENSE_ID,
68: dispensed_date = P_DISPENSED_DATE

Line 80: insert into gmo_dispensing_planning (

76: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,
77: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
78: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
79: );
80: insert into gmo_dispensing_planning (
81: PLANNED_TASK_ID,
82: RESERVATION_ID,
83: DISPENSE_AREA_ID ,
84: PRIORITY ,

Line 98: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence

94: LAST_UPDATE_LOGIN
95: )
96: values
97: (
98: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
99: P_RESERVATION_ID,
100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,

Line 100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,

96: values
97: (
98: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
99: P_RESERVATION_ID,
100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----

Line 101: gmo_dispensing_planning_rec.PRIORITY,

97: (
98: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
99: P_RESERVATION_ID,
100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----
105: gmo_dispensing_planning_rec.status,

Line 102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,

98: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
99: P_RESERVATION_ID,
100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----
105: gmo_dispensing_planning_rec.status,
106: null,

Line 103: gmo_dispensing_planning_rec.OPER_ID,

99: P_RESERVATION_ID,
100: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----
105: gmo_dispensing_planning_rec.status,
106: null,
107: gmo_dispensing_planning_rec.DISPENSED_DATE,

Line 105: gmo_dispensing_planning_rec.status,

101: gmo_dispensing_planning_rec.PRIORITY,
102: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----
105: gmo_dispensing_planning_rec.status,
106: null,
107: gmo_dispensing_planning_rec.DISPENSED_DATE,
108: --L_CREATED_BY,
109: gmo_dispensing_planning_rec.created_by,

Line 107: gmo_dispensing_planning_rec.DISPENSED_DATE,

103: gmo_dispensing_planning_rec.OPER_ID,
104: --'PDISPENSE', ---signifying partial dispense----
105: gmo_dispensing_planning_rec.status,
106: null,
107: gmo_dispensing_planning_rec.DISPENSED_DATE,
108: --L_CREATED_BY,
109: gmo_dispensing_planning_rec.created_by,
110: L_CREATION_DATE,
111: --L_LAST_UPDATED_BY,

Line 109: gmo_dispensing_planning_rec.created_by,

105: gmo_dispensing_planning_rec.status,
106: null,
107: gmo_dispensing_planning_rec.DISPENSED_DATE,
108: --L_CREATED_BY,
109: gmo_dispensing_planning_rec.created_by,
110: L_CREATION_DATE,
111: --L_LAST_UPDATED_BY,
112: gmo_dispensing_planning_rec.last_updated_by,
113: L_LAST_UPDATE_DATE,

Line 112: gmo_dispensing_planning_rec.last_updated_by,

108: --L_CREATED_BY,
109: gmo_dispensing_planning_rec.created_by,
110: L_CREATION_DATE,
111: --L_LAST_UPDATED_BY,
112: gmo_dispensing_planning_rec.last_updated_by,
113: L_LAST_UPDATE_DATE,
114: --L_LAST_UPDATE_LOGIN
115: gmo_dispensing_planning_rec.last_update_login
116: );

Line 115: gmo_dispensing_planning_rec.last_update_login

111: --L_LAST_UPDATED_BY,
112: gmo_dispensing_planning_rec.last_updated_by,
113: L_LAST_UPDATE_DATE,
114: --L_LAST_UPDATE_LOGIN
115: gmo_dispensing_planning_rec.last_update_login
116: );
117: /*
118: The Changes Made to accommodate Reverse Dispense STARTS-
119: */

Line 125: select count(*) into l_total_unplanned_count from gmo_dispensing_planning

121: else --- l_count = 0 for unplanned dispenses /ELSE OF MAIN IF/
122:
123: if (P_DISPENSE_TYPE = 'RDISPENSE') THEN --REV DISPENSE IF
124:
125: select count(*) into l_total_unplanned_count from gmo_dispensing_planning
126: where reservation_id = P_RESERVATION_ID
127: and status = 'UNPLANNED';
128:
129: SELECT Count(*) INTO l_total_disp_count FROM gmo_dispensing_planning

Line 129: SELECT Count(*) INTO l_total_disp_count FROM gmo_dispensing_planning

125: select count(*) into l_total_unplanned_count from gmo_dispensing_planning
126: where reservation_id = P_RESERVATION_ID
127: and status = 'UNPLANNED';
128:
129: SELECT Count(*) INTO l_total_disp_count FROM gmo_dispensing_planning
130: WHERE reservation_id = P_RESERVATION_ID
131: AND status='DISPENSD';
132:
133: GMO_UTILITIES.GET_WHO_COLUMNS

Line 146: FETCH c_planning_rec_details INTO gmo_dispensing_planning_rec ;

142: IF( l_total_unplanned_count = 0) THEN /*Changes made as a part of Bug 13545234*/
143:
144: OPEN c_planning_rec_details(P_RESERVATION_ID,P_DISPENSE_ID);
145: LOOP
146: FETCH c_planning_rec_details INTO gmo_dispensing_planning_rec ;
147: EXIT WHEN c_planning_rec_details%NOTFOUND;
148: IF (l_total_disp_count > 0) THEN
149:
150: --change the status to dispensed

Line 152: update gmo_dispensing_planning

148: IF (l_total_disp_count > 0) THEN
149:
150: --change the status to dispensed
151:
152: update gmo_dispensing_planning
153: set status = 'UNPLANNED',
154: planned_dispensing_date=NULL,
155: dispense_id = NULL,
156: dispensed_date = NULL,

Line 165: insert into gmo_dispensing_planning (

161: and status ='DISPENSD';
162:
163: --
164: ELSE
165: insert into gmo_dispensing_planning (
166: PLANNED_TASK_ID,
167: RESERVATION_ID,
168: DISPENSE_AREA_ID ,
169: PRIORITY ,

Line 183: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence

179: LAST_UPDATE_LOGIN
180: )
181: values
182: (
183: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
184: P_RESERVATION_ID,
185: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
186: gmo_dispensing_planning_rec.PRIORITY,
187: NULL,

Line 185: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,

181: values
182: (
183: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
184: P_RESERVATION_ID,
185: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
186: gmo_dispensing_planning_rec.PRIORITY,
187: NULL,
188: gmo_dispensing_planning_rec.OPER_ID,
189: --'PDISPENSE', ---signifying partial dispense----

Line 186: gmo_dispensing_planning_rec.PRIORITY,

182: (
183: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
184: P_RESERVATION_ID,
185: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
186: gmo_dispensing_planning_rec.PRIORITY,
187: NULL,
188: gmo_dispensing_planning_rec.OPER_ID,
189: --'PDISPENSE', ---signifying partial dispense----
190: 'UNPLANNED',

Line 188: gmo_dispensing_planning_rec.OPER_ID,

184: P_RESERVATION_ID,
185: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
186: gmo_dispensing_planning_rec.PRIORITY,
187: NULL,
188: gmo_dispensing_planning_rec.OPER_ID,
189: --'PDISPENSE', ---signifying partial dispense----
190: 'UNPLANNED',
191: null,
192: null,

Line 194: gmo_dispensing_planning_rec.created_by,

190: 'UNPLANNED',
191: null,
192: null,
193: --L_CREATED_BY,
194: gmo_dispensing_planning_rec.created_by,
195: L_CREATION_DATE,
196: --L_LAST_UPDATED_BY,
197: gmo_dispensing_planning_rec.last_updated_by,
198: L_LAST_UPDATE_DATE,

Line 197: gmo_dispensing_planning_rec.last_updated_by,

193: --L_CREATED_BY,
194: gmo_dispensing_planning_rec.created_by,
195: L_CREATION_DATE,
196: --L_LAST_UPDATED_BY,
197: gmo_dispensing_planning_rec.last_updated_by,
198: L_LAST_UPDATE_DATE,
199: --L_LAST_UPDATE_LOGIN
200: gmo_dispensing_planning_rec.last_update_login
201: );

Line 200: gmo_dispensing_planning_rec.last_update_login

196: --L_LAST_UPDATED_BY,
197: gmo_dispensing_planning_rec.last_updated_by,
198: L_LAST_UPDATE_DATE,
199: --L_LAST_UPDATE_LOGIN
200: gmo_dispensing_planning_rec.last_update_login
201: );
202: END IF; -- end of unplanned count if -- changes end for Bug 13545234
203: END LOOP;
204: CLOSE c_planning_rec_details;

Line 222: select count(*) into l_count from gmo_dispensing_planning

218: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
219: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
220: );
221:
222: select count(*) into l_count from gmo_dispensing_planning
223: where reservation_id = P_RESERVATION_ID
224: and status = 'UNPLANNED';
225:
226: if( l_count = 0) then

Line 227: insert into gmo_dispensing_planning

223: where reservation_id = P_RESERVATION_ID
224: and status = 'UNPLANNED';
225:
226: if( l_count = 0) then
227: insert into gmo_dispensing_planning
228: (
229: PLANNED_TASK_ID,
230: RESERVATION_ID,
231: DISPENSE_AREA_ID,

Line 246: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence

242: LAST_UPDATE_LOGIN
243: )
244: values
245: (
246: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
247: P_RESERVATION_ID,
248: P_DISPENSE_AREA_ID,
249: 'MEDIUM',
250: null,

Line 264: update gmo_dispensing_planning

260: );
261:
262: ELSE
263:
264: update gmo_dispensing_planning
265: set
266: status = 'DISPENSD',
267: dispense_id = P_DISPENSE_ID,
268: dispense_area_id = P_DISPENSE_AREA_ID,

Line 279: insert into gmo_dispensing_planning

275: select DISPENSE_AREA_ID into L_DISP_AREA_ID
276: from gmo_dispense_area_b ar
277: where ar.organization_id = P_DISP_ORG_ID and ar.default_area_ind = 'Y';
278:
279: insert into gmo_dispensing_planning
280: (
281: PLANNED_TASK_ID,
282: RESERVATION_ID,
283: DISPENSE_AREA_ID,

Line 298: GMO_DISPENSING_PLANNING_S.nextval,

294: LAST_UPDATE_LOGIN
295: )
296: values
297: (
298: GMO_DISPENSING_PLANNING_S.nextval,
299: P_RESERVATION_ID,
300: L_DISP_AREA_ID,
301: 'MEDIUM',
302: null,

Line 337: select count(*) into plannedPer from gmo_dispensing_planning

333: totalPer number default 0;
334:
335: begin
336:
337: select count(*) into plannedPer from gmo_dispensing_planning
338: where dispense_area_id = area_id
339: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
340: and status = 'PLANNED'
341: and dispense_id is null;

Line 343: select count(*) into dispensedPer from gmo_dispensing_planning

339: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
340: and status = 'PLANNED'
341: and dispense_id is null;
342:
343: select count(*) into dispensedPer from gmo_dispensing_planning
344: where dispense_area_id = area_id
345: and to_char(dispensed_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
346: and dispense_id is not null;
347:

Line 370: select count(*) into plannedPer from gmo_dispensing_planning

366: dispensedPer number default 0;
367: totalPer number default 0;
368: begin
369:
370: select count(*) into plannedPer from gmo_dispensing_planning
371: where dispense_area_id = area_id
372: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
373: and OPER_ID = oper
374: and status = 'PLANNED'

Line 377: select count(*) into dispensedPer from gmo_dispensing_planning

373: and OPER_ID = oper
374: and status = 'PLANNED'
375: and dispense_id is null;
376:
377: select count(*) into dispensedPer from gmo_dispensing_planning
378: where dispense_area_id = area_id
379: and to_char(dispensed_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
380: and OPER_ID = oper
381: and dispense_id is not null;

Line 405: select count(*) into plannedPer from gmo_dispensing_planning

401: totalPer number default 0;
402:
403: noofdays number;
404: begin
405: select count(*) into plannedPer from gmo_dispensing_planning
406: where dispense_area_id = area_id
407: and planned_dispensing_date between week_start_date and week_end_date
408: and status = 'PLANNED'
409: and dispense_id is null;

Line 411: select count(*) into dispensedPer from gmo_dispensing_planning

407: and planned_dispensing_date between week_start_date and week_end_date
408: and status = 'PLANNED'
409: and dispense_id is null;
410:
411: select count(*) into dispensedPer from gmo_dispensing_planning
412: where dispense_area_id = area_id
413: and dispensed_date between week_start_date and week_end_date
414: and dispense_id is not null;
415:

Line 439: select count(*) into plannedPer from gmo_dispensing_planning

435: totalPer number default 0;
436: noofdays number;
437: begin
438:
439: select count(*) into plannedPer from gmo_dispensing_planning
440: where dispense_area_id = area_id
441: and OPER_ID = oper
442: and planned_dispensing_date between week_start_date and week_end_date
443: and status = 'PLANNED'

Line 446: select count(*) into dispensedPer from gmo_dispensing_planning

442: and planned_dispensing_date between week_start_date and week_end_date
443: and status = 'PLANNED'
444: and dispense_id is null;
445:
446: select count(*) into dispensedPer from gmo_dispensing_planning
447: where dispense_area_id = area_id
448: and OPER_ID = oper
449: and dispensed_date between week_start_date and week_end_date
450: and dispense_id is not null;