APPS.GMO_LABEL_MGMT_GRP dependencies on GMO_LABEL_HISTORY_S

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