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 399: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (

395: OPEN CS1;
396: FETCH CS1 INTO ACTION_TRIGGER_ID;
397: CLOSE CS1;
398:
399: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (
400: PLAN_CHAR_ACTION_TRIGGER_ID,
401: LAST_UPDATE_DATE,
402: LAST_UPDATED_BY,
403: CREATION_DATE,

Line 444: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

440: -- Included Template OPM Recieving inspection plan because
441: -- conversion is required for these plans as well.
442:
443: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
444: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
445: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
446: FROM PO_LOOKUP_CODES
447: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
448: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)

Line 1017: QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT,

1013: QIL.VALUE,
1014: QIL.VALUE_ID,
1015: QIL.CHAR_ID
1016: FROM
1017: QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT,
1018: QA_IN_LISTS QIL
1019: WHERE QPCAT.PLAN_ID = X_COPY_PLAN_ID
1020: AND QPCAT.CHAR_ID = QIL.CHAR_ID
1021: AND ???? */