APPS.QA_SS_PARENT_CHILD_PKG dependencies on DUAL

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

478: l_request_id NUMBER;
479: BEGIN
480:
481: SELECT sysdate INTO l_sysdate
482: FROM DUAL;
483:
484: IF p_default_parent_spec = 'Y' THEN
485: l_default_parent_spec := 1;
486: END IF;

Line 637: FROM DUAL;

633:
634: BEGIN
635:
636: SELECT sysdate INTO l_sysdate
637: FROM DUAL;
638:
639: IF p_link_flag = 'Y' THEN
640: l_link_flag := 1;
641: ELSE

Line 679: FROM DUAL;

675:
676: BEGIN
677:
678: SELECT sysdate INTO l_sysdate
679: FROM DUAL;
680:
681: QA_PC_CRITERIA_PKG.Insert_Row(
682: X_Rowid => l_row_id,
683: X_Criteria_Id => x_criteria_id,

Line 727: FROM DUAL;

723:
724: BEGIN
725:
726: SELECT sysdate INTO l_sysdate
727: FROM DUAL;
728:
729: OPEN c ;
730: FETCH c INTO l_rowid;
731: CLOSE c;

Line 775: FROM DUAL;

771:
772: BEGIN
773:
774: SELECT sysdate INTO l_sysdate
775: FROM DUAL;
776:
777: IF p_link_flag = 'Y' THEN
778: l_link_flag := 1;
779: ELSE

Line 817: FROM DUAL;

813:
814: BEGIN
815:
816: SELECT sysdate INTO l_sysdate
817: FROM DUAL;
818:
819: QA_PC_CRITERIA_PKG.Update_Row(
820: X_Rowid => p_rowid,
821: X_Criteria_Id => p_criteria_id,