APPS.QLTAUFLB dependencies on QA_PLAN_CHAR_ACTIONS

Line 247: FROM QA_PLAN_CHAR_ACTIONS

243: ALR_ACTION_ID,
244: ALR_ACTION_SET_ID,
245: ASSIGNED_CHAR_ID,
246: ASSIGN_TYPE
247: FROM QA_PLAN_CHAR_ACTIONS
248: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID
249: ORDER BY PLAN_CHAR_ACTION_ID;
250:
251: QPCA C2%ROWTYPE;

Line 254: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;

250:
251: QPCA C2%ROWTYPE;
252:
253: CURSOR CS2 IS
254: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;
255:
256: QPC_ACTION_ID NUMBER;
257:
258: --

Line 306: FROM qa_plan_char_actions a,

302: ALR_ACTION_ID,
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,

Line 310: FROM qa_plan_char_actions b,

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

Line 402: /*DELETE FROM qa_plan_char_actions

398: -- since there can be other actions associated to it which will get orphaned
399: -- SHKALYAN. 20-Feb-2007.
400: --
401:
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

Line 425: -- from cursor C9 and inserting it into QA_PLAN_CHAR_ACTIONS

421:
422: --
423: -- Bug# 5739330.
424: -- Added this part of code to insert the missing actions fetched
425: -- from cursor C9 and inserting it into QA_PLAN_CHAR_ACTIONS
426: -- The C8 cursor gets the action_triggers which are already present
427: -- in the plan and it is used for getting the actions in C9
428: -- SHKALYAN. 20-Feb-2007.
429: --

Line 444: INSERT INTO QA_PLAN_CHAR_ACTIONS

440: OPEN CS2;
441: FETCH CS2 INTO QPC_ACTION_ID;
442: CLOSE CS2;
443:
444: INSERT INTO QA_PLAN_CHAR_ACTIONS
445: (PLAN_CHAR_ACTION_ID,
446: LAST_UPDATE_DATE,
447: LAST_UPDATED_BY,
448: CREATION_DATE,

Line 555: INSERT INTO QA_PLAN_CHAR_ACTIONS (

551: OPEN CS2;
552: FETCH CS2 INTO QPC_ACTION_ID;
553: CLOSE CS2;
554:
555: INSERT INTO QA_PLAN_CHAR_ACTIONS (
556: PLAN_CHAR_ACTION_ID,
557: LAST_UPDATE_DATE,
558: LAST_UPDATED_BY,
559: CREATION_DATE,