APPS.QLTCPPLB dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 37: FROM QA_PLAN_CHAR_ACTION_TRIGGERS

33: LOW_VALUE_OTHER,
34: HIGH_VALUE_OTHER,
35: LOW_VALUE_OTHER_ID,
36: HIGH_VALUE_OTHER_ID
37: FROM QA_PLAN_CHAR_ACTION_TRIGGERS
38: WHERE PLAN_ID = X_COPY_PLAN_ID AND
39: CHAR_ID NOT IN (SELECT CHAR_ID FROM QA_PLAN_CHARS
40: WHERE PLAN_ID = X_PLAN_ID)
41: ORDER BY TRIGGER_SEQUENCE,

Line 46: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;

42: PLAN_CHAR_ACTION_TRIGGER_ID;
43:
44:
45: CURSOR CS1 IS
46: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;
47:
48: ACTION_TRIGGER_ID NUMBER;
49:
50: QPCAT C1%ROWTYPE;

Line 391: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (

387: OPEN CS1;
388: FETCH CS1 INTO ACTION_TRIGGER_ID;
389: CLOSE CS1;
390:
391: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (
392: PLAN_CHAR_ACTION_TRIGGER_ID,
393: LAST_UPDATE_DATE,
394: LAST_UPDATED_BY,
395: CREATION_DATE,

Line 436: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

432: -- Included Template OPM Recieving inspection plan because
433: -- conversion is required for these plans as well.
434:
435: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
436: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
437: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
438: FROM PO_LOOKUP_CODES
439: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
440: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)

Line 1001: QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT,

997: QIL.VALUE,
998: QIL.VALUE_ID,
999: QIL.CHAR_ID
1000: FROM
1001: QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT,
1002: QA_IN_LISTS QIL
1003: WHERE QPCAT.PLAN_ID = X_COPY_PLAN_ID
1004: AND QPCAT.CHAR_ID = QIL.CHAR_ID
1005: AND ???? */