APPS.QLTAUFLB dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 163: FROM QA_PLAN_CHAR_ACTION_TRIGGERS

159: LOW_VALUE_OTHER,
160: HIGH_VALUE_OTHER,
161: LOW_VALUE_OTHER_ID,
162: HIGH_VALUE_OTHER_ID
163: FROM QA_PLAN_CHAR_ACTION_TRIGGERS
164: WHERE PLAN_ID = X_COPY_PLAN_ID;*/
165: -- AND PLAN_CHAR_ACTION_TRIGGER_ID NOT IN
166: -- (SELECT PLAN_CHAR_ACTION_TRIGGER_ID
167: -- FROM QA_PLAN_CHAR_ACTION_TRIGGERS

Line 167: -- FROM QA_PLAN_CHAR_ACTION_TRIGGERS

163: FROM QA_PLAN_CHAR_ACTION_TRIGGERS
164: WHERE PLAN_ID = X_COPY_PLAN_ID;*/
165: -- AND PLAN_CHAR_ACTION_TRIGGER_ID NOT IN
166: -- (SELECT PLAN_CHAR_ACTION_TRIGGER_ID
167: -- FROM QA_PLAN_CHAR_ACTION_TRIGGERS
168: -- WHERE PLAN_ID = X_PLAN_ID)
169: -- ORDER BY TRIGGER_SEQUENCE,
170: -- PLAN_CHAR_ACTION_TRIGGER_ID;
171:

Line 194: FROM qa_plan_char_action_triggers a

190: a.low_value_other,
191: a.high_value_other,
192: a.low_value_other_id,
193: a.high_value_other_id
194: FROM qa_plan_char_action_triggers a
195: WHERE NOT EXISTS
196: (SELECT 1
197: FROM qa_plan_char_action_triggers b
198: WHERE b.plan_id = X_PLAN_ID

Line 197: FROM qa_plan_char_action_triggers b

193: a.high_value_other_id
194: FROM qa_plan_char_action_triggers a
195: WHERE NOT EXISTS
196: (SELECT 1
197: FROM qa_plan_char_action_triggers b
198: WHERE b.plan_id = X_PLAN_ID
199: AND a.char_id = b.char_id
200: --AND nvl(a.trigger_sequence, 0) = nvl(b.trigger_sequence, 0)
201: AND nvl(a.operator, 0) = nvl(b.operator, 0)

Line 222: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;

218: AND nvl(a.high_value_other_id, 0) = nvl(b.high_value_other_id, 0))
219: AND a.plan_id = X_COPY_PLAN_ID;
220:
221: CURSOR CS1 IS
222: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;
223:
224: ACTION_TRIGGER_ID NUMBER;
225:
226: QPCAT C1%ROWTYPE;

Line 269: FROM qa_plan_char_action_triggers a, qa_plan_char_action_triggers b

265: --
266: CURSOR C8 IS
267: SELECT a.plan_char_action_trigger_id temp_action_trigger_id,
268: b.plan_char_action_trigger_id action_trigger_id
269: FROM qa_plan_char_action_triggers a, qa_plan_char_action_triggers b
270: WHERE a.char_id = b.char_id
271: AND nvl(a.operator, 0) = nvl(b.operator, 0)
272: AND nvl(a.low_value_lookup, 0) = nvl(b.low_value_lookup, 0)
273: AND nvl(b.low_value_other, 0) = decode(nvl(a.low_value_other, 0),

Line 307: qa_plan_char_action_triggers c

303: ALR_ACTION_SET_ID,
304: ASSIGNED_CHAR_ID,
305: ASSIGN_TYPE
306: FROM qa_plan_char_actions a,
307: qa_plan_char_action_triggers c
308: WHERE NOT EXISTS
309: (SELECT 1
310: FROM qa_plan_char_actions b,
311: qa_plan_char_action_triggers d

Line 311: qa_plan_char_action_triggers d

307: qa_plan_char_action_triggers c
308: WHERE NOT EXISTS
309: (SELECT 1
310: FROM qa_plan_char_actions b,
311: qa_plan_char_action_triggers d
312: WHERE nvl(a.action_id, 0) = nvl(b.action_id, 0)
313: AND nvl(a.car_name_prefix, 0) = nvl(b.car_name_prefix, 0)
314: AND nvl(a.car_type_id, 0) = nvl(b.car_type_id, 0)
315: AND nvl(a.car_owner, 0) = nvl(b.car_owner, 0)

Line 406: FROM qa_plan_char_action_triggers

402: /*DELETE FROM qa_plan_char_actions
403: WHERE action_id in (25, 26)
404: AND plan_char_action_trigger_id IN
405: (SELECT plan_char_action_trigger_id
406: FROM qa_plan_char_action_triggers
407: WHERE plan_id = X_Plan_id
408: AND char_id = 8
409: AND low_value_other IN
410: (SELECT displayed_field

Line 414: DELETE FROM qa_plan_char_action_triggers

410: (SELECT displayed_field
411: FROM po_lookup_codes
412: WHERE lookup_type='ERT RESULTS ACTION'));
413:
414: DELETE FROM qa_plan_char_action_triggers
415: WHERE plan_id = X_Plan_id
416: AND char_id = 8
417: AND low_value_other IN
418: (SELECT displayed_field

Line 492: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (

488: OPEN CS1;
489: FETCH CS1 INTO ACTION_TRIGGER_ID;
490: CLOSE CS1;
491:
492: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (
493: PLAN_CHAR_ACTION_TRIGGER_ID,
494: LAST_UPDATE_DATE,
495: LAST_UPDATED_BY,
496: CREATION_DATE,

Line 537: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

533: -- Included Template OPM Recieving inspection plan because
534: -- conversion is required for these plans as well.
535:
536: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
537: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
538: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
539: FROM PO_LOOKUP_CODES
540: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
541: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)