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 513: sys.dual

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

Line 590: FROM SYS.DUAL;

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

Line 623: SYS.DUAL;

619:
620: CURSOR c_res_list_seq_csr IS
621: SELECT pa_resource_lists_s.NEXTVAL
622: FROM
623: SYS.DUAL;
624:
625: -- Added for Bug 2486405.
626: CURSOR c_job_group_csr IS
627: SELECT 1

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

714: CLOSE c_resource_groups_csr;
715: END IF;
716: END IF; -- Added by RM
717:
718: p_err_stage := 'Select pa_resource_lists_s.nextval from dual ';
719: OPEN c_res_list_seq_csr;
720: FETCH c_res_list_seq_csr INTO
721: l_resource_list_id;
722: IF c_res_list_seq_csr%NOTFOUND THEN

Line 1831: FROM SYS.DUAL;

1827: /* Bug # 932398 Fix : Added flags for non-labor resources in the above cursor */
1828:
1829: CURSOR c_res_txn_attr_seq_csr IS
1830: SELECT pa_resource_txn_attributes_s.NEXTVAL
1831: FROM SYS.DUAL;
1832:
1833: BEGIN
1834: l_old_stack := p_err_stack;
1835: p_err_code := 0;

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

1905: ELSE
1906: CLOSE c_res_format_csr;
1907: END IF;
1908:
1909: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';
1910:
1911: OPEN c_res_txn_attr_seq_csr;
1912: FETCH c_res_txn_attr_seq_csr INTO
1913: l_resource_txn_attribute_id;

Line 2635: SYS.DUAL;

2631: CURSOR c_resource_seq_csr IS
2632: SELECT
2633: pa_resources_s.NEXTVAL
2634: FROM
2635: SYS.DUAL;
2636:
2637:
2638: l_err_code NUMBER := 0;
2639: l_old_stack VARCHAR2(2000);

Line 2990: FROM SYS.DUAL;

2986:
2987: CURSOR c_res_list_member_seq_csr IS
2988: SELECT
2989: pa_resource_list_members_s.NEXTVAL
2990: FROM SYS.DUAL;
2991:
2992: --Cursor added for resolution of bug 1889671
2993:
2994: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

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

3708: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3709:
3710: FOR eachRL IN Seeded_RLs LOOP
3711:
3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3713:
3714: SELECT pa_resource_lists_s.NEXTVAL
3715: INTO X_resource_list_id
3716: FROM sys.dual;

Line 3716: FROM sys.dual;

3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3713:
3714: SELECT pa_resource_lists_s.NEXTVAL
3715: INTO X_resource_list_id
3716: FROM sys.dual;
3717:
3718: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';
3719:
3720: INSERT INTO pa_resource_lists_all_bg (

Line 3759: sys.dual

3755: , X_user_id
3756: , X_login_id
3757: , 1 -- record version number
3758: FROM
3759: sys.dual
3760: WHERE NOT EXISTS (
3761: SELECT NULL
3762: FROM pa_resource_lists rl
3763: WHERE business_group_id =

Line 4149: FROM dual --For perf bug 4067435

4145: * *****************************************************/
4146: BEGIN
4147: SELECT 'Y'
4148: INTO l_exist_record
4149: FROM dual --For perf bug 4067435
4150: WHERE EXISTS (SELECT resource_list_id,object_id
4151: FROM pa_resource_list_members
4152: WHERE object_id = p_project_id
4153: AND object_type = 'PROJECT'

Line 5306: FROM dual;

5302: WHERE resource_list_id = P_RESOURCE_LIST_ID;
5303:
5304: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)
5305: INTO l_resource_list_id
5306: FROM dual;
5307: */
5308: --End of Commenting for Bug#5094347
5309:
5310: /*Bug 4202015 - Changes Start*/