APPS.QA_PARENT_CHILD_COPY_PKG dependencies on QA_PLANS

Line 281: --get_plan_view and get_import_view are copied from qa_plans_pub to build the view names in the view_name and import_view_name

277: RETURN u_name;
278: END IF;
279: END get_user_name;
280:
281: --get_plan_view and get_import_view are copied from qa_plans_pub to build the view names in the view_name and import_view_name
282: --for a given plan name
283: FUNCTION get_plan_view_name(p_name VARCHAR2) RETURN VARCHAR2 IS
284: BEGIN
285: return 'Q_' || translate(substr(p_name, 1, 26), ' ''', '__') || '_V';

Line 313: value qa_plans.name%TYPE;

309: p IN OUT NOCOPY INTEGER)
310: RETURN plan_info
311: IS
312: new_info plan_info;
313: value qa_plans.name%TYPE;
314: c VARCHAR2(10);
315: separator CONSTANT VARCHAR2(1) := '@';
316: subseparator CONSTANT VARCHAR2(1) := ',';
317: BEGIN

Line 509: FROM qa_plans qp, qa_plan_chars qpc, qa_plan_char_action_triggers qpcat, qa_plan_char_actions qpca

505:
506: --this cursor selects all actions for a given plan_id
507: CURSOR C1 (p_plan_id NUMBER) IS
508: SELECT qpca.plan_char_action_id, qpca.alr_action_id, qpca.message
509: FROM qa_plans qp, qa_plan_chars qpc, qa_plan_char_action_triggers qpcat, qa_plan_char_actions qpca
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:

Line 656: (SELECT 1 FROM qa_plans

652: -- Changing SYS.DUAL to DUAL as this is the correct coding standard
653: -- The code may fail in databases that do not have SYS schema
654: SELECT 1 FROM DUAL
655: WHERE NOT EXISTS
656: (SELECT 1 FROM qa_plans
657: WHERE translate(substr(upper(name),1,25),' ''','__') =
658: translate(substr(upper(p_plan_name),1,25),' ''','__'));
659:
660: C1_rec C1%ROWTYPE;

Line 708: select_string := 'select plan_id, effective_from, effective_to from qa_plans where plan_id in (';

704: RETURN;
705: END IF;
706:
707: --init the sql string
708: select_string := 'select plan_id, effective_from, effective_to from qa_plans where plan_id in (';
709: FOR i in 1..n LOOP
710: IF i <> n THEN
711: select_string := select_string || ':' || to_char(i) || ', ';
712: ELSE

Line 767: update_string := 'UPDATE QA_PLANS SET effective_from = :1, effective_to = :2 WHERE plan_id = :3';

763: END IF;
764: END LOOP;
765:
766: --now perform the bulk DML update
767: update_string := 'UPDATE QA_PLANS SET effective_from = :1, effective_to = :2 WHERE plan_id = :3';
768: c2 := dbms_sql.open_cursor;
769: dbms_sql.parse(c2, update_string, dbms_sql.native);
770: dbms_sql.bind_array(c2, ':1', from_table);
771: dbms_sql.bind_array(c2, ':2', to_table);

Line 898: qa_plans_pub.copy_collection_plan(

894: RETURN -1;
895: END IF;
896:
897: --call the copy_collection_plan procedure
898: qa_plans_pub.copy_collection_plan(
899: p_api_version => 1.0,
900: p_user_name => user_name,
901: p_plan_name => this_plan.src_name,
902: p_organization_code => src_org_code,