APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_PLANS

Line 286: select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;

282: l_error_array.delete;
283: l_parent_plan_id := p_parent_plan_id;
284:
285: IF (p_parent_plan_id is NULL OR p_parent_plan_id <0) THEN
286: select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;
287: IF (result_num IS NULL OR result_num < 1) THEN
288: ret_status := 'F';
289: l_error_array(1) := 'QA_PC_SS_INVALID_PARENT_PLAN';
290: ELSE

Line 297: select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;

293: END IF;
294:
295: l_child_plan_id := p_child_plan_id;
296: IF (p_child_plan_id is NULL OR p_child_plan_id <0) THEN
297: select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;
298: IF (result_num IS NULL OR result_num < 1) THEN
299: ret_status := 'F';
300: l_count := l_error_array.count +1;
301: l_error_array(l_count) := 'QA_PC_SS_INVALID_CHILD_PLAN';

Line 395: select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;

391: l_error_array.delete;
392: l_parent_plan_id := p_parent_plan_id;
393:
394: IF (p_parent_plan_id is NULL OR p_parent_plan_id <0) THEN
395: select qa_plans_api.plan_id(p_parent_plan_name) into result_num from dual;
396: IF (result_num IS NULL OR result_num < 1) THEN
397: ret_status := 'F';
398: l_error_array(1) := 'QA_PC_SS_INVALID_PARENT_PLAN';
399: ELSE

Line 406: select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;

402: END IF;
403:
404: l_child_plan_id := p_child_plan_id;
405: IF (p_child_plan_id is NULL OR p_child_plan_id <0) THEN
406: select qa_plans_api.plan_id(p_child_plan_name) into result_num from dual;
407: IF (result_num IS NULL OR result_num < 1) THEN
408: ret_status := 'F';
409: l_count := l_error_array.count +1;
410: l_error_array(l_count) := 'QA_PC_SS_INVALID_CHILD_PLAN';

Line 904: p_object_name => 'QA_PLANS',

900: IF (security_profile = 1) THEN --make use of security
901: allow := fnd_data_security.check_function(
902: p_api_version => 1.0,
903: p_function => 'QA_RESULTS_VIEW',
904: p_object_name => 'QA_PLANS',
905: p_instance_pk1_value => p_plan_id
906: );
907: --user name is default current user
908: --not necessary to pass in

Line 1063: from qa_pc_plan_relationship qpr, qa_plans qp

1059: l_search_array qa_txn_grp.ElementsArray;
1060:
1061: cursor l_plans_cursor IS
1062: select distinct qpr.parent_plan_id
1063: from qa_pc_plan_relationship qpr, qa_plans qp
1064: where qpr.parent_plan_id = qp.plan_id
1065: and qp.organization_id = p_org_id;
1066: BEGIN
1067: --sanity check, don't let them blink search using an org