APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LISTS_S

Line 621: SELECT pa_resource_lists_s.NEXTVAL

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

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

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

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

5300: INTO l_row_id
5301: FROM pa_resource_lists_all_bg
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