APPS.GMO_LABEL_MGMT_GRP dependencies on GMO_LABEL_HISTORY_DTL

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 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 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 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 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 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'