APPS.QA_SS_PARENT_CHILD_PKG dependencies on DUAL

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 478: FROM DUAL;

474: l_request_id NUMBER;
475: BEGIN
476:
477: SELECT sysdate INTO l_sysdate
478: FROM DUAL;
479:
480: IF p_default_parent_spec = 'Y' THEN
481: l_default_parent_spec := 1;
482: END IF;

Line 633: FROM DUAL;

629:
630: BEGIN
631:
632: SELECT sysdate INTO l_sysdate
633: FROM DUAL;
634:
635: IF p_link_flag = 'Y' THEN
636: l_link_flag := 1;
637: ELSE

Line 675: FROM DUAL;

671:
672: BEGIN
673:
674: SELECT sysdate INTO l_sysdate
675: FROM DUAL;
676:
677: QA_PC_CRITERIA_PKG.Insert_Row(
678: X_Rowid => l_row_id,
679: X_Criteria_Id => x_criteria_id,

Line 723: FROM DUAL;

719:
720: BEGIN
721:
722: SELECT sysdate INTO l_sysdate
723: FROM DUAL;
724:
725: OPEN c ;
726: FETCH c INTO l_rowid;
727: CLOSE c;

Line 771: FROM DUAL;

767:
768: BEGIN
769:
770: SELECT sysdate INTO l_sysdate
771: FROM DUAL;
772:
773: IF p_link_flag = 'Y' THEN
774: l_link_flag := 1;
775: ELSE

Line 813: FROM DUAL;

809:
810: BEGIN
811:
812: SELECT sysdate INTO l_sysdate
813: FROM DUAL;
814:
815: QA_PC_CRITERIA_PKG.Update_Row(
816: X_Rowid => p_rowid,
817: X_Criteria_Id => p_criteria_id,