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 589: pa_resource_list_members_s.NEXTVAL

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

Line 902: pa_resource_list_members_s.NEXTVAL,

898: created_by,
899: last_update_login )
900: VALUES (
901: l_resource_list_id,
902: pa_resource_list_members_s.NEXTVAL,
903: l_resource_id,
904: l_resource_name,
905: NULL,
906: 9999999,

Line 998: pa_resource_list_members_s.NEXTVAL,

994: unit_of_measure
995: )
996: VALUES (
997: l_resource_list_id,
998: pa_resource_list_members_s.NEXTVAL,
999: -99,
1000: initcap(replace(l_res_class_code, '_', ' ')),
1001: 'Y',
1002: 'Y',

Line 1099: pa_resource_list_members_s.NEXTVAL,

1095: expenditure_type
1096: )
1097: VALUES (
1098: l_resource_list_id,
1099: pa_resource_list_members_s.NEXTVAL,
1100: -99,
1101: 'Project Resource',
1102: 'Y',
1103: 'Y',

Line 1565: pa_resource_list_members_s.NEXTVAL,

1561: unit_of_measure
1562: )
1563: VALUES (
1564: p_resource_list_id,
1565: pa_resource_list_members_s.NEXTVAL,
1566: -99,
1567: initcap(replace(l_res_class_code, '_', ' ')),
1568: 'Y',
1569: 'Y',

Line 1652: pa_resource_list_members_s.NEXTVAL,

1648: unit_of_measure
1649: )
1650: VALUES (
1651: p_resource_list_id,
1652: pa_resource_list_members_s.NEXTVAL,
1653: -99,
1654: 'Project Resource',
1655: 'Y',
1656: 'Y',

Line 2989: pa_resource_list_members_s.NEXTVAL

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

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

3439: l_new_track_as_labor_flag := 'N';
3440: END IF;
3441:
3442: -- Need to generate the resource_list_member_id
3443: p_err_stage := 'Select pa_resource_list_members_s.nextval ';
3444:
3445: OPEN c_res_list_member_seq_csr;
3446: FETCH c_res_list_member_seq_csr INTO
3447: l_resource_list_member_id;

Line 3617: pa_resource_list_members_s.NEXTVAL,

3613: last_update_login )
3614:
3615: VALUES (
3616: p_resource_list_id,
3617: pa_resource_list_members_s.NEXTVAL,
3618: l_resource_id,
3619: l_resource_name,
3620: p_parent_member_id,
3621: 999999,

Line 3833: SELECT pa_resource_list_members_s.NEXTVAL

3829: , INCURRED_BY_RES_FLAG
3830: , WP_ELIGIBLE_FLAG
3831: , UNIT_OF_MEASURE
3832: )
3833: SELECT pa_resource_list_members_s.NEXTVAL
3834: , X_resource_list_id
3835: , rlm.resource_id
3836: , rlm.alias
3837: , rlm.parent_member_id

Line 4261: pa_resource_list_members_s.NEXTVAL,

4257: CREATED_BY,
4258: LAST_UPDATE_LOGIN,
4259: expenditure_type_2) --Added for Bug13654538
4260: SELECT
4261: pa_resource_list_members_s.NEXTVAL,
4262: a.RESOURCE_LIST_ID,
4263: a.RESOURCE_ID,
4264: a.ALIAS,
4265: a.DISPLAY_FLAG,

Line 4683: Pa_resource_list_members_S.NextVal,

4679: Old_Element_Id,
4680: Old_Parent_Element_Id,
4681: New_Parent_Element_Id )
4682: (Select
4683: Pa_resource_list_members_S.NextVal,
4684: resource_list_member_id,
4685: Parent_member_Id,
4686: Null
4687: From Pa_resource_list_members

Line 5112: pa_resource_list_members_s.NEXTVAL,

5108: CREATION_DATE,
5109: CREATED_BY,
5110: LAST_UPDATE_LOGIN)
5111: SELECT
5112: pa_resource_list_members_s.NEXTVAL,
5113: l_resource_list_id,
5114: a.RESOURCE_ID,
5115: a.ALIAS,
5116: a.DISPLAY_FLAG,