DBA Data[Home] [Help]

APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_PLANS_API

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';