APPS.PA_CREATE_RESOURCE dependencies on DUAL

Line 138: FROM SYS.DUAL;

134:
135: CURSOR c_res_list_member_seq_csr IS
136: SELECT
137: pa_resource_list_members_s.NEXTVAL
138: FROM SYS.DUAL;
139:
140: l_err_code NUMBER := 0;
141: l_old_stack VARCHAR2(2000);
142: l_dummy VARCHAR2(1);

Line 512: sys.dual

508: l_resource_format_id,
509: l_resource_type_id,
510: l_res_type_code
511: FROM
512: sys.dual
513: WHERE NOT EXISTS
514: (SELECT 'x' FROM PA_RESOURCE_LIST_MEMBERS
515: WHERE resource_list_id = p_resource_list_id
516: AND resource_id = l_resource_id

Line 587: FROM SYS.DUAL;

583:
584: CURSOR c_res_list_member_seq_csr IS
585: SELECT
586: pa_resource_list_members_s.NEXTVAL
587: FROM SYS.DUAL;
588:
589: CURSOR csr_get_formats IS
590: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
591: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

Line 611: SYS.DUAL;

607:
608: CURSOR c_res_list_seq_csr IS
609: SELECT pa_resource_lists_s.NEXTVAL
610: FROM
611: SYS.DUAL;
612:
613: -- Added for Bug 2486405.
614: CURSOR c_job_group_csr IS
615: SELECT 1

Line 706: p_err_stage := 'Select pa_resource_lists_s.nextval from dual ';

702: CLOSE c_resource_groups_csr;
703: END IF;
704: END IF; -- Added by RM
705:
706: p_err_stage := 'Select pa_resource_lists_s.nextval from dual ';
707: OPEN c_res_list_seq_csr;
708: FETCH c_res_list_seq_csr INTO
709: l_resource_list_id;
710: IF c_res_list_seq_csr%NOTFOUND THEN

Line 1483: FROM SYS.DUAL;

1479: /* Bug # 932398 Fix : Added flags for non-labor resources in the above cursor */
1480:
1481: CURSOR c_res_txn_attr_seq_csr IS
1482: SELECT pa_resource_txn_attributes_s.NEXTVAL
1483: FROM SYS.DUAL;
1484:
1485: BEGIN
1486: l_old_stack := p_err_stack;
1487: p_err_code := 0;

Line 1561: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';

1557: ELSE
1558: CLOSE c_res_format_csr;
1559: END IF;
1560:
1561: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';
1562:
1563: OPEN c_res_txn_attr_seq_csr;
1564: FETCH c_res_txn_attr_seq_csr INTO
1565: l_resource_txn_attribute_id;

Line 2287: SYS.DUAL;

2283: CURSOR c_resource_seq_csr IS
2284: SELECT
2285: pa_resources_s.NEXTVAL
2286: FROM
2287: SYS.DUAL;
2288:
2289:
2290: l_err_code NUMBER := 0;
2291: l_old_stack VARCHAR2(2000);

Line 2642: FROM SYS.DUAL;

2638:
2639: CURSOR c_res_list_member_seq_csr IS
2640: SELECT
2641: pa_resource_list_members_s.NEXTVAL
2642: FROM SYS.DUAL;
2643:
2644: --Cursor added for resolution of bug 1889671
2645:
2646: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

Line 3363: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';

3359: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3360:
3361: FOR eachRL IN Seeded_RLs LOOP
3362:
3363: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3364:
3365: SELECT pa_resource_lists_s.NEXTVAL
3366: INTO X_resource_list_id
3367: FROM sys.dual;

Line 3367: FROM sys.dual;

3363: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3364:
3365: SELECT pa_resource_lists_s.NEXTVAL
3366: INTO X_resource_list_id
3367: FROM sys.dual;
3368:
3369: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';
3370:
3371: INSERT INTO pa_resource_lists_all_bg (

Line 3410: sys.dual

3406: , X_user_id
3407: , X_login_id
3408: , 1 -- record version number
3409: FROM
3410: sys.dual
3411: WHERE NOT EXISTS (
3412: SELECT NULL
3413: FROM pa_resource_lists rl
3414: WHERE business_group_id =

Line 3800: FROM dual --For perf bug 4067435

3796: * *****************************************************/
3797: BEGIN
3798: SELECT 'Y'
3799: INTO l_exist_record
3800: FROM dual --For perf bug 4067435
3801: WHERE EXISTS (SELECT resource_list_id,object_id
3802: FROM pa_resource_list_members
3803: WHERE object_id = p_project_id
3804: AND object_type = 'PROJECT'

Line 4951: FROM dual;

4947: WHERE resource_list_id = P_RESOURCE_LIST_ID;
4948:
4949: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)
4950: INTO l_resource_list_id
4951: FROM dual;
4952: */
4953: --End of Commenting for Bug#5094347
4954:
4955: /*Bug 4202015 - Changes Start*/