APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_PLANS

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

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

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

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

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

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

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

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

Line 900: p_object_name => 'QA_PLANS',

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

Line 1052: from qa_pc_plan_relationship qpr, qa_plans qp

1048: l_search_array qa_txn_grp.ElementsArray;
1049:
1050: cursor l_plans_cursor IS
1051: select distinct qpr.parent_plan_id
1052: from qa_pc_plan_relationship qpr, qa_plans qp
1053: where qpr.parent_plan_id = qp.plan_id
1054: and qp.organization_id = p_org_id;
1055: BEGIN
1056: --sanity check, don't let them blink search using an org