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_CREATION_DATE DATE;
22: L_CREATED_BY 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_CREATION_DATE DATE;
22: L_CREATED_BY NUMBER;
23: L_LAST_UPDATE_DATE DATE;

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

24: L_LAST_UPDATED_BY NUMBER;
25: L_LAST_UPDATE_LOGIN NUMBER;
26: L_DISP_AREA_ID NUMBER;
27: begin
28: select count(*) into l_count from gmo_dispensing_planning
29: where reservation_id = P_RESERVATION_ID
30: and status = 'PLANNED';
31: if (l_count > 0) then -- for planned dispense and partial dispenses
32: if ( P_DISPENSE_TYPE = 'DISPENSE' ) then

Line 33: update gmo_dispensing_planning

29: where reservation_id = P_RESERVATION_ID
30: and status = 'PLANNED';
31: if (l_count > 0) then -- for planned dispense and partial dispenses
32: if ( P_DISPENSE_TYPE = 'DISPENSE' ) then
33: update gmo_dispensing_planning
34: set
35: status = 'DISPENSD',
36: dispense_id = P_DISPENSE_ID,
37: dispensed_date = P_DISPENSED_DATE

Line 44: select * into gmo_dispensing_planning_rec from gmo_dispensing_planning

40: -- for partial dispense
41: elsif ( P_DISPENSE_TYPE = 'PDISPENSE' ) then
42:
43: --copy the record
44: select * into gmo_dispensing_planning_rec from gmo_dispensing_planning
45: where reservation_id = P_RESERVATION_ID
46: and status ='PLANNED';
47:
48: --change the status to dispensed

Line 49: update gmo_dispensing_planning

45: where reservation_id = P_RESERVATION_ID
46: and status ='PLANNED';
47:
48: --change the status to dispensed
49: update gmo_dispensing_planning
50: set
51: status = 'DISPENSD',
52: dispense_id = P_DISPENSE_ID,
53: dispensed_date = P_DISPENSED_DATE

Line 65: insert into gmo_dispensing_planning (

61: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,
62: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
63: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
64: );
65: insert into gmo_dispensing_planning (
66: PLANNED_TASK_ID,
67: RESERVATION_ID,
68: DISPENSE_AREA_ID ,
69: PRIORITY ,

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

79: LAST_UPDATE_LOGIN
80: )
81: values
82: (
83: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
84: P_RESERVATION_ID,
85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,

Line 85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,

81: values
82: (
83: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
84: P_RESERVATION_ID,
85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----

Line 86: gmo_dispensing_planning_rec.PRIORITY,

82: (
83: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
84: P_RESERVATION_ID,
85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----
90: gmo_dispensing_planning_rec.status,

Line 87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,

83: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
84: P_RESERVATION_ID,
85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----
90: gmo_dispensing_planning_rec.status,
91: null,

Line 88: gmo_dispensing_planning_rec.OPER_ID,

84: P_RESERVATION_ID,
85: gmo_dispensing_planning_rec.DISPENSE_AREA_ID,
86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----
90: gmo_dispensing_planning_rec.status,
91: null,
92: gmo_dispensing_planning_rec.DISPENSED_DATE,

Line 90: gmo_dispensing_planning_rec.status,

86: gmo_dispensing_planning_rec.PRIORITY,
87: gmo_dispensing_planning_rec.PLANNED_DISPENSING_DATE,
88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----
90: gmo_dispensing_planning_rec.status,
91: null,
92: gmo_dispensing_planning_rec.DISPENSED_DATE,
93: --L_CREATED_BY,
94: gmo_dispensing_planning_rec.created_by,

Line 92: gmo_dispensing_planning_rec.DISPENSED_DATE,

88: gmo_dispensing_planning_rec.OPER_ID,
89: --'PDISPENSE', ---signifying partial dispense----
90: gmo_dispensing_planning_rec.status,
91: null,
92: gmo_dispensing_planning_rec.DISPENSED_DATE,
93: --L_CREATED_BY,
94: gmo_dispensing_planning_rec.created_by,
95: L_CREATION_DATE,
96: --L_LAST_UPDATED_BY,

Line 94: gmo_dispensing_planning_rec.created_by,

90: gmo_dispensing_planning_rec.status,
91: null,
92: gmo_dispensing_planning_rec.DISPENSED_DATE,
93: --L_CREATED_BY,
94: gmo_dispensing_planning_rec.created_by,
95: L_CREATION_DATE,
96: --L_LAST_UPDATED_BY,
97: gmo_dispensing_planning_rec.last_updated_by,
98: L_LAST_UPDATE_DATE,

Line 97: gmo_dispensing_planning_rec.last_updated_by,

93: --L_CREATED_BY,
94: gmo_dispensing_planning_rec.created_by,
95: L_CREATION_DATE,
96: --L_LAST_UPDATED_BY,
97: gmo_dispensing_planning_rec.last_updated_by,
98: L_LAST_UPDATE_DATE,
99: --L_LAST_UPDATE_LOGIN
100: gmo_dispensing_planning_rec.last_update_login
101: );

Line 100: gmo_dispensing_planning_rec.last_update_login

96: --L_LAST_UPDATED_BY,
97: gmo_dispensing_planning_rec.last_updated_by,
98: L_LAST_UPDATE_DATE,
99: --L_LAST_UPDATE_LOGIN
100: gmo_dispensing_planning_rec.last_update_login
101: );
102: end if; --- dispense_type
103: else --- l_count = 0 for unplanned dispenses
104: GMO_UTILITIES.GET_WHO_COLUMNS

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

109: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
110: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
111: );
112:
113: select count(*) into l_count from gmo_dispensing_planning
114: where reservation_id = P_RESERVATION_ID
115: and status = 'UNPLANNED';
116:
117: if( l_count = 0) then

Line 118: insert into gmo_dispensing_planning (

114: where reservation_id = P_RESERVATION_ID
115: and status = 'UNPLANNED';
116:
117: if( l_count = 0) then
118: insert into gmo_dispensing_planning (
119: PLANNED_TASK_ID,
120: RESERVATION_ID,
121: DISPENSE_AREA_ID,
122: PRIORITY,

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

132: LAST_UPDATE_LOGIN
133: )
134: values
135: (
136: GMO_DISPENSING_PLANNING_S.nextval, --- get the next value from sequence
137: P_RESERVATION_ID,
138: P_DISPENSE_AREA_ID,
139: 'MEDIUM',
140: null,

Line 153: update gmo_dispensing_planning

149: L_LAST_UPDATE_DATE,
150: L_LAST_UPDATE_LOGIN
151: );
152: else
153: update gmo_dispensing_planning
154: set
155: status = 'DISPENSD',
156: dispense_id = P_DISPENSE_ID,
157: dispense_area_id = P_DISPENSE_AREA_ID,

Line 167: insert into gmo_dispensing_planning (

163: select DISPENSE_AREA_ID into L_DISP_AREA_ID
164: from gmo_dispense_area_b ar
165: where ar.organization_id = P_DISP_ORG_ID and ar.default_area_ind = 'Y';
166:
167: insert into gmo_dispensing_planning (
168: PLANNED_TASK_ID,
169: RESERVATION_ID,
170: DISPENSE_AREA_ID,
171: PRIORITY,

Line 185: GMO_DISPENSING_PLANNING_S.nextval,

181: LAST_UPDATE_LOGIN
182: )
183: values
184: (
185: GMO_DISPENSING_PLANNING_S.nextval,
186: P_RESERVATION_ID,
187: L_DISP_AREA_ID,
188: 'MEDIUM',
189: null,

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

219: totalPer number default 0;
220:
221: begin
222:
223: select count(*) into plannedPer from gmo_dispensing_planning
224: where dispense_area_id = area_id
225: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
226: and status = 'PLANNED'
227: and dispense_id is null;

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

225: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
226: and status = 'PLANNED'
227: and dispense_id is null;
228:
229: select count(*) into dispensedPer from gmo_dispensing_planning
230: where dispense_area_id = area_id
231: and to_char(dispensed_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
232: and dispense_id is not null;
233:

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

252: dispensedPer number default 0;
253: totalPer number default 0;
254: begin
255:
256: select count(*) into plannedPer from gmo_dispensing_planning
257: where dispense_area_id = area_id
258: and to_char(planned_dispensing_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
259: and OPER_ID = oper
260: and status = 'PLANNED'

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

259: and OPER_ID = oper
260: and status = 'PLANNED'
261: and dispense_id is null;
262:
263: select count(*) into dispensedPer from gmo_dispensing_planning
264: where dispense_area_id = area_id
265: and to_char(dispensed_date,'dd-mon-rr') = to_char(date_value,'dd-mon-rr')
266: and OPER_ID = oper
267: and dispense_id is not null;

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

287: totalPer number default 0;
288:
289: noofdays number;
290: begin
291: select count(*) into plannedPer from gmo_dispensing_planning
292: where dispense_area_id = area_id
293: and planned_dispensing_date between week_start_date and week_end_date
294: and status = 'PLANNED'
295: and dispense_id is null;

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

293: and planned_dispensing_date between week_start_date and week_end_date
294: and status = 'PLANNED'
295: and dispense_id is null;
296:
297: select count(*) into dispensedPer from gmo_dispensing_planning
298: where dispense_area_id = area_id
299: and dispensed_date between week_start_date and week_end_date
300: and dispense_id is not null;
301:

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

321: totalPer number default 0;
322: noofdays number;
323: begin
324:
325: select count(*) into plannedPer from gmo_dispensing_planning
326: where dispense_area_id = area_id
327: and OPER_ID = oper
328: and planned_dispensing_date between week_start_date and week_end_date
329: and status = 'PLANNED'

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

328: and planned_dispensing_date between week_start_date and week_end_date
329: and status = 'PLANNED'
330: and dispense_id is null;
331:
332: select count(*) into dispensedPer from gmo_dispensing_planning
333: where dispense_area_id = area_id
334: and OPER_ID = oper
335: and dispensed_date between week_start_date and week_end_date
336: and dispense_id is not null;