APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LIST_MEMBERS_S

Line 137: pa_resource_list_members_s.NEXTVAL

133: organization_id = l_org_id ;
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);

Line 586: pa_resource_list_members_s.NEXTVAL

582: WHERE NAME = p_resource_list_name;
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

Line 886: pa_resource_list_members_s.NEXTVAL,

882: created_by,
883: last_update_login )
884: VALUES (
885: l_resource_list_id,
886: pa_resource_list_members_s.NEXTVAL,
887: l_resource_id,
888: l_resource_name,
889: NULL,
890: 9999999,

Line 978: pa_resource_list_members_s.NEXTVAL,

974: unit_of_measure
975: )
976: VALUES (
977: l_resource_list_id,
978: pa_resource_list_members_s.NEXTVAL,
979: -99,
980: initcap(replace(l_res_class_code, '_', ' ')),
981: 'Y',
982: 'Y',

Line 2641: pa_resource_list_members_s.NEXTVAL

2637: AND resource_list_member_id = p_parent_member_id;
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:

Line 3094: p_err_stage := 'Select pa_resource_list_members_s.nextval ';

3090: l_new_track_as_labor_flag := 'N';
3091: END IF;
3092:
3093: -- Need to generate the resource_list_member_id
3094: p_err_stage := 'Select pa_resource_list_members_s.nextval ';
3095:
3096: OPEN c_res_list_member_seq_csr;
3097: FETCH c_res_list_member_seq_csr INTO
3098: l_resource_list_member_id;

Line 3268: pa_resource_list_members_s.NEXTVAL,

3264: last_update_login )
3265:
3266: VALUES (
3267: p_resource_list_id,
3268: pa_resource_list_members_s.NEXTVAL,
3269: l_resource_id,
3270: l_resource_name,
3271: p_parent_member_id,
3272: 999999,

Line 3484: SELECT pa_resource_list_members_s.NEXTVAL

3480: , INCURRED_BY_RES_FLAG
3481: , WP_ELIGIBLE_FLAG
3482: , UNIT_OF_MEASURE
3483: )
3484: SELECT pa_resource_list_members_s.NEXTVAL
3485: , X_resource_list_id
3486: , rlm.resource_id
3487: , rlm.alias
3488: , rlm.parent_member_id

Line 3911: pa_resource_list_members_s.NEXTVAL,

3907: CREATION_DATE,
3908: CREATED_BY,
3909: LAST_UPDATE_LOGIN)
3910: SELECT
3911: pa_resource_list_members_s.NEXTVAL,
3912: a.RESOURCE_LIST_ID,
3913: a.RESOURCE_ID,
3914: a.ALIAS,
3915: a.DISPLAY_FLAG,

Line 4330: Pa_resource_list_members_S.NextVal,

4326: Old_Element_Id,
4327: Old_Parent_Element_Id,
4328: New_Parent_Element_Id )
4329: (Select
4330: Pa_resource_list_members_S.NextVal,
4331: resource_list_member_id,
4332: Parent_member_Id,
4333: Null
4334: From Pa_resource_list_members

Line 4757: pa_resource_list_members_s.NEXTVAL,

4753: CREATION_DATE,
4754: CREATED_BY,
4755: LAST_UPDATE_LOGIN)
4756: SELECT
4757: pa_resource_list_members_s.NEXTVAL,
4758: l_resource_list_id,
4759: a.RESOURCE_ID,
4760: a.ALIAS,
4761: a.DISPLAY_FLAG,