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_LABEL_MGMT_GRP dependencies on GMO_LABEL_HISTORY

Line 50: SELECT GMO_LABEL_HISTORY_S.nextval from dual;

46: P_CONTEXT IN GMO_LABEL_MGMT_GRP.CONTEXT_TABLE,
47: x_Label_id OUT NOCOPY NUMBER) IS PRAGMA AUTONOMOUS_TRANSACTION;
48:
49: CURSOR C_LABEL_HISTORY_S IS
50: SELECT GMO_LABEL_HISTORY_S.nextval from dual;
51:
52: CURSOR C_LABEL_HISTORY_DTL_S IS
53: SELECT GMO_LABEL_HISTORY_DTL_S.nextval from dual;
54:

Line 53: SELECT GMO_LABEL_HISTORY_DTL_S.nextval from dual;

49: CURSOR C_LABEL_HISTORY_S IS
50: SELECT GMO_LABEL_HISTORY_S.nextval from dual;
51:
52: CURSOR C_LABEL_HISTORY_DTL_S IS
53: SELECT GMO_LABEL_HISTORY_DTL_S.nextval from dual;
54:
55: l_index number;
56: l_label_id number;
57: l_labeldtl_id number;

Line 80: /* Insert master row into GMO_LABEL_HISTORY */

76: END IF;
77:
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: /* Insert master row into GMO_LABEL_HISTORY */
81: OPEN C_LABEL_HISTORY_S;
82: fetch C_LABEL_HISTORY_S into l_label_id;
83: CLOSE C_LABEL_HISTORY_S;
84:

Line 93: INSERT INTO GMO_LABEL_HISTORY

89: X_LAST_UPDATE_DATE =>L_LAST_UPDATE_DATE,
90: X_LAST_UPDATED_BY =>L_LAST_UPDATED_BY,
91: X_LAST_UPDATE_LOGIN =>L_LAST_UPDATE_LOGIN);
92:
93: INSERT INTO GMO_LABEL_HISTORY
94: ( LABEL_ID,
95: ENTITY_NAME,
96: ENTITY_KEY,
97: WMS_BUSINESSFLOW_CODE,

Line 138: /* Insert DTL row into GMO_LABEL_HISTORY_TL */

134: L_EXIT:= false;
135: else
136: L_LABELTYPE:=substr(L_LABELSTRING,0,instr(L_LABELSTRING,',')-1) ;
137: end if;
138: /* Insert DTL row into GMO_LABEL_HISTORY_TL */
139: OPEN C_LABEL_HISTORY_DTL_S;
140: fetch C_LABEL_HISTORY_DTL_S into l_labeldtl_id;
141: CLOSE C_LABEL_HISTORY_DTL_S;
142:

Line 143: INSERT INTO GMO_LABEL_HISTORY_DTL

139: OPEN C_LABEL_HISTORY_DTL_S;
140: fetch C_LABEL_HISTORY_DTL_S into l_labeldtl_id;
141: CLOSE C_LABEL_HISTORY_DTL_S;
142:
143: INSERT INTO GMO_LABEL_HISTORY_DTL
144: ( LABEL_DTL_ID,
145: LABEL_ID,
146: LABEL_TYPE,
147: WMS_LABEL_ID,

Line 255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;

251: P_ERECORD_STATUS IN VARCHAR2,
252: x_print_status OUT NOCOPY VARCHAR2) IS
253:
254: l_label_id number;
255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;
256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;

Line 256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;

252: x_print_status OUT NOCOPY VARCHAR2) IS
253:
254: l_label_id number;
255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;
256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;
260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;

Line 257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;

253:
254: l_label_id number;
255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;
256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;
260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;
261: L_CREATION_DATE DATE;

Line 258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;

254: l_label_id number;
255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;
256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;
260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;
261: L_CREATION_DATE DATE;
262: L_CREATED_BY NUMBER;

Line 259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;

255: l_wms_businessflow_code GMO_LABEL_HISTORY.wms_businessflow_code%TYPE;
256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;
260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;
261: L_CREATION_DATE DATE;
262: L_CREATED_BY NUMBER;
263: L_LAST_UPDATE_DATE DATE;

Line 260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;

256: l_WMS_BUSINESSFLOW_TRANS_ID GMO_LABEL_HISTORY.WMS_BUSINESSFLOW_TRANS_ID%TYPE;
257: L_TRANSACTION_TYPE GMO_LABEL_HISTORY.TRANSACTION_TYPE%TYPE;
258: L_LABEL_TYPE GMO_LABEL_HISTORY_DTL.LABEL_TYPE%TYPE;
259: L_LABEL_STATUS GMO_LABEL_HISTORY_DTL.WMS_PRINT_STATUS%TYPE;
260: L_WMS_LABEL_ID GMO_LABEL_HISTORY_DTL.WMS_LABEL_ID%TYPE;
261: L_CREATION_DATE DATE;
262: L_CREATED_BY NUMBER;
263: L_LAST_UPDATE_DATE DATE;
264: L_LAST_UPDATED_BY NUMBER;

Line 275: from GMO_LABEL_HISTORY

271: CURSOR C_LABEL_HDR is
272: SELECT WMS_BUSINESSFLOW_CODE,
273: WMS_BUSINESSFLOW_TRANS_ID,
274: TRANSACTION_TYPE
275: from GMO_LABEL_HISTORY
276: where LABEL_ID=p_LABEL_ID;
277:
278:
279: CURSOR C_LABEL_DTL IS

Line 280: select LABEL_TYPE from GMO_LABEL_HISTORY_DTL

276: where LABEL_ID=p_LABEL_ID;
277:
278:
279: CURSOR C_LABEL_DTL IS
280: select LABEL_TYPE from GMO_LABEL_HISTORY_DTL
281: where label_id=P_LABEL_ID;
282: BEGIN
283: IF NOT fnd_api.Compatible_API_Call (p_api_version, p_api_version, l_api_name, G_PKG_NAME )
284: THEN

Line 331: Update GMO_LABEL_HISTORY_DTL

327: P_NO_OF_COPIES=>1,
328: P_FORMAT_ID=>NULL);
329:
330:
331: Update GMO_LABEL_HISTORY_DTL
332: set WMS_PRINT_STATUS=decode(X_RETURN_STATUS,'S','SUCCESS','FAILURE'),
333: WMS_LABEL_ID=L_WMS_LABEL_ID
334: where
335: label_id=P_LABEL_ID and

Line 341: UPDATE GMO_LABEL_HISTORY set

337:
338:
339: END LOOP;
340: CLOSE C_LABEL_DTL;
341: UPDATE GMO_LABEL_HISTORY set
342: ERECORD_ID=P_ERECORD_ID,
343: STATUS='COMPLETE',
344: LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 359: UPDATE GMO_LABEL_HISTORY set

355: else
356: L_LABEL_STATUS := P_ERECORD_STATUS;
357: end if;
358:
359: UPDATE GMO_LABEL_HISTORY set
360: ERECORD_ID=P_ERECORD_ID,
361: STATUS=L_LABEL_STATUS,
362: LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
363: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 368: Update GMO_LABEL_HISTORY_DTL

364: LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN
365: where
366: label_id=P_LABEL_ID;
367:
368: Update GMO_LABEL_HISTORY_DTL
369: set WMS_PRINT_STATUS=L_LABEL_STATUS,
370: WMS_LABEL_ID=NULL
371: where
372: label_id=P_LABEL_ID;

Line 448: UPDATE GMO_LABEL_HISTORY set

444: X_LAST_UPDATE_DATE =>L_LAST_UPDATE_DATE,
445: X_LAST_UPDATED_BY =>L_LAST_UPDATED_BY,
446: X_LAST_UPDATE_LOGIN =>L_LAST_UPDATE_LOGIN);
447:
448: UPDATE GMO_LABEL_HISTORY set
449: STATUS='CANCEL',
450: LAST_UPDATE_DATE=L_LAST_UPDATE_DATE,
451: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
452: LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN

Line 456: Update GMO_LABEL_HISTORY_DTL

452: LAST_UPDATE_LOGIN=L_LAST_UPDATE_LOGIN
453: where
454: label_id=P_LABEL_ID;
455:
456: Update GMO_LABEL_HISTORY_DTL
457: set WMS_PRINT_STATUS='CANCEL',
458: WMS_LABEL_ID=NULL
459: where
460: label_id=P_LABEL_ID;

Line 549: From GMO_LABEL_HISTORY A, GMO_LABEL_HISTORY_DTL B

545: FND_MSG_PUB.initialize;
546: END IF;
547: Select Count(*) into x_print_count
548: --Bug 4912228: Start
549: From GMO_LABEL_HISTORY A, GMO_LABEL_HISTORY_DTL B
550: --Bug 4912228: End
551: Where A.LABEL_ID=B.LABEL_ID
552: --Bug 5146629: start
553: and B.WMS_PRINT_STATUS = 'SUCCESS'