APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LISTS_S

Line 609: SELECT pa_resource_lists_s.NEXTVAL

605: pa_resource_groups_valid_v
606: WHERE resource_group = p_group_resource_type;
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.

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 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 3365: SELECT pa_resource_lists_s.NEXTVAL

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;
3368:
3369: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';

Line 4949: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)

4945: INTO l_row_id
4946: FROM pa_resource_lists_all_bg
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