APPS.QA_PARENT_CHILD_COPY_PKG dependencies on ALR_ACTIONS

Line 514: --this cursor get's the body field from alr_actions for a given action_id

510: WHERE qp.plan_id = qpc.plan_id AND qpc.char_id = qpcat.char_id AND qp.plan_id = qpcat.plan_id
511: AND qpcat.plan_char_action_trigger_id = qpca.plan_char_action_trigger_id AND qp.plan_id=p_plan_id;
512: l_message qa_plan_char_actions.message%TYPE;
513:
514: --this cursor get's the body field from alr_actions for a given action_id
515: CURSOR C2 (p_alract_id NUMBER) IS
516: SELECT body
517: FROM alr_actions
518: WHERE action_id = p_alract_id AND application_id = 250;

Line 517: FROM alr_actions

513:
514: --this cursor get's the body field from alr_actions for a given action_id
515: CURSOR C2 (p_alract_id NUMBER) IS
516: SELECT body
517: FROM alr_actions
518: WHERE action_id = p_alract_id AND application_id = 250;
519: l_body alr_actions.body%TYPE;
520:
521: --initialize the list of suffixes

Line 519: l_body alr_actions.body%TYPE;

515: CURSOR C2 (p_alract_id NUMBER) IS
516: SELECT body
517: FROM alr_actions
518: WHERE action_id = p_alract_id AND application_id = 250;
519: l_body alr_actions.body%TYPE;
520:
521: --initialize the list of suffixes
522: ncm_suffix_list ncm_suffix_list_t := ncm_suffix_list_t(SP_NCM_PLAN_NAME_SUFFIX, SP_NCM_VIEW_NAME_SUFFIX, SP_NCM_IMPORT_NAME_SUFFIX);
523: BEGIN

Line 557: --and update the ALR_ACTIONS table

553:
554: --now we do the replacement function on l_body
555: execute_NCM_repl_func(l_body, repl_htable, ncm_suffix_list);
556:
557: --and update the ALR_ACTIONS table
558: UPDATE ALR_ACTIONS SET BODY = l_body WHERE APPLICATION_ID=250 AND ACTION_ID = c1_rec.alr_action_id;
559: END LOOP;
560: END IF;
561:

Line 558: UPDATE ALR_ACTIONS SET BODY = l_body WHERE APPLICATION_ID=250 AND ACTION_ID = c1_rec.alr_action_id;

554: --now we do the replacement function on l_body
555: execute_NCM_repl_func(l_body, repl_htable, ncm_suffix_list);
556:
557: --and update the ALR_ACTIONS table
558: UPDATE ALR_ACTIONS SET BODY = l_body WHERE APPLICATION_ID=250 AND ACTION_ID = c1_rec.alr_action_id;
559: END LOOP;
560: END IF;
561:
562: --dbms_output.put_line('begin actid '||c1_rec.plan_char_action_id);