eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_LIST_MEMBERS_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 15: * Procedure and Insert into pa_resource_list_members

11: /*******************************************************
12: * Procedure : Insert_Row
13: * Description : This procedure is used to take in the parameters
14: * passed from pa_planning_resource_pub.create_planning_resource
15: * Procedure and Insert into pa_resource_list_members
16: * table.
17: ***********************************************************/
18: PROCEDURE Insert_Row
19: ( p_resource_list_member_id IN

Line 20: pa_resource_list_members.resource_list_member_id%TYPE,

16: * table.
17: ***********************************************************/
18: PROCEDURE Insert_Row
19: ( p_resource_list_member_id IN
20: pa_resource_list_members.resource_list_member_id%TYPE,
21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,

Line 21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,

17: ***********************************************************/
18: PROCEDURE Insert_Row
19: ( p_resource_list_member_id IN
20: pa_resource_list_members.resource_list_member_id%TYPE,
21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,

Line 22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,

18: PROCEDURE Insert_Row
19: ( p_resource_list_member_id IN
20: pa_resource_list_members.resource_list_member_id%TYPE,
21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,

Line 23: p_resource_alias IN pa_resource_list_members.alias%TYPE,

19: ( p_resource_list_member_id IN
20: pa_resource_list_members.resource_list_member_id%TYPE,
21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,

Line 24: p_person_id IN pa_resource_list_members.person_id%TYPE,

20: pa_resource_list_members.resource_list_member_id%TYPE,
21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,

Line 25: p_job_id IN pa_resource_list_members.job_id%TYPE ,

21: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,
22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,

Line 26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,

22: p_resource_id IN pa_resource_list_members.resource_id%TYPE,
23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN

Line 27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,

23: p_resource_alias IN pa_resource_list_members.alias%TYPE,
24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,

Line 28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,

24: p_person_id IN pa_resource_list_members.person_id%TYPE,
25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,
32: p_expenditure_category IN

Line 29: p_event_type IN pa_resource_list_members.event_type%TYPE ,

25: p_job_id IN pa_resource_list_members.job_id%TYPE ,
26: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,
32: p_expenditure_category IN
33: pa_resource_list_members.expenditure_category%TYPE,

Line 31: pa_resource_list_members.non_labor_resource%TYPE,

27: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
28: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,
32: p_expenditure_category IN
33: pa_resource_list_members.expenditure_category%TYPE,
34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35: p_role_id IN

Line 33: pa_resource_list_members.expenditure_category%TYPE,

29: p_event_type IN pa_resource_list_members.event_type%TYPE ,
30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,
32: p_expenditure_category IN
33: pa_resource_list_members.expenditure_category%TYPE,
34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35: p_role_id IN
36: pa_resource_list_members.project_role_id%TYPE ,
37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,

Line 34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,

30: p_non_labor_resource IN
31: pa_resource_list_members.non_labor_resource%TYPE,
32: p_expenditure_category IN
33: pa_resource_list_members.expenditure_category%TYPE,
34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35: p_role_id IN
36: pa_resource_list_members.project_role_id%TYPE ,
37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38: p_res_class_code IN

Line 36: pa_resource_list_members.project_role_id%TYPE ,

32: p_expenditure_category IN
33: pa_resource_list_members.expenditure_category%TYPE,
34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35: p_role_id IN
36: pa_resource_list_members.project_role_id%TYPE ,
37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38: p_res_class_code IN
39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,

Line 37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,

33: pa_resource_list_members.expenditure_category%TYPE,
34: p_revenue_category IN pa_resource_list_members.revenue_category%TYPE ,
35: p_role_id IN
36: pa_resource_list_members.project_role_id%TYPE ,
37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38: p_res_class_code IN
39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,
41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,

Line 39: pa_resource_list_members.resource_class_code%TYPE,

35: p_role_id IN
36: pa_resource_list_members.project_role_id%TYPE ,
37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38: p_res_class_code IN
39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,
41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,

Line 41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,

37: p_resource_class_id IN pa_resource_list_members.resource_class_id%TYPE ,
38: p_res_class_code IN
39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,
41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,

Line 42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,

38: p_res_class_code IN
39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,
41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,

Line 43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,

39: pa_resource_list_members.resource_class_code%TYPE,
40: p_res_format_id IN NUMBER ,
41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,

Line 45: pa_resource_list_members.resource_class_flag%TYPE ,

41: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

Line 46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,

42: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

Line 47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,

43: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

Line 48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,

44: p_res_class_flag IN
45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

Line 49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

45: pa_resource_list_members.resource_class_flag%TYPE ,
46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

Line 50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

46: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,
47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

Line 51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

47: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,
48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

Line 52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

48: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,
49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

Line 53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

49: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

Line 54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

50: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

Line 55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

51: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

Line 56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

52: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

Line 57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

53: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

Line 58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

54: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

Line 59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

55: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

Line 60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

56: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

Line 61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

57: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

Line 62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

58: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

Line 63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

59: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

Line 64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

60: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

Line 65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

61: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

Line 66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

62: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

Line 67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

63: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

Line 68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

64: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

Line 69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

65: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

Line 70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

66: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

Line 71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

67: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

Line 72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

68: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

Line 73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

69: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

Line 74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

70: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

Line 75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

71: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

Line 76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

72: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,

Line 77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

73: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,

Line 78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

74: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,

Line 79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

75: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN

Line 80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,

76: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,

Line 81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,

77: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN

Line 82: p_team_role IN pa_resource_list_members.team_role%TYPE,

78: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
79: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,

Line 84: pa_resource_list_members.incurred_by_res_flag%TYPE,

80: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,
81: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,
82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,

Line 86: pa_resource_list_members.incur_by_res_class_code%TYPE,

82: p_team_role IN pa_resource_list_members.team_role%TYPE,
83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,

Line 87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,

83: p_incur_by_res_flag IN
84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,

Line 88: p_object_type IN pa_resource_list_members.object_type%TYPE,

84: pa_resource_list_members.incurred_by_res_flag%TYPE,
85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,
92: x_msg_count IN OUT NOCOPY NUMBER,

Line 89: p_object_id IN pa_resource_list_members.object_id%TYPE,

85: p_incur_by_res_class_code IN
86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,
92: x_msg_count IN OUT NOCOPY NUMBER,
93: x_return_status OUT NOCOPY VARCHAR2,

Line 90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,

86: pa_resource_list_members.incur_by_res_class_code%TYPE,
87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,
92: x_msg_count IN OUT NOCOPY NUMBER,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_error_msg_data OUT NOCOPY VARCHAR2 )

Line 91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,

87: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,
88: p_object_type IN pa_resource_list_members.object_type%TYPE,
89: p_object_id IN pa_resource_list_members.object_id%TYPE,
90: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,
91: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,
92: x_msg_count IN OUT NOCOPY NUMBER,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_error_msg_data OUT NOCOPY VARCHAR2 )
95: IS

Line 99: INSERT INTO PA_RESOURCE_LIST_MEMBERS(

95: IS
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: INSERT INTO PA_RESOURCE_LIST_MEMBERS(
100: RESOURCE_LIST_MEMBER_ID,
101: RESOURCE_LIST_ID,
102: RESOURCE_ID,
103: ALIAS,

Line 265: * Procedure and Update the pa_resource_list_members

261: /*******************************************************
262: * Procedure : Update_Row
263: * Description : This procedure is used to take in the parameters
264: * passed from pa_planning_resource_pub.update_planning_resource
265: * Procedure and Update the pa_resource_list_members
266: * table.
267: ***********************************************************/
268: PROCEDURE Update_Row
269: (p_alias IN VARCHAR2,

Line 272: pa_resource_list_members.resource_list_member_id%TYPE,

268: PROCEDURE Update_Row
269: (p_alias IN VARCHAR2,
270: p_enabled_flag IN VARCHAR2,
271: p_resource_list_member_id IN
272: pa_resource_list_members.resource_list_member_id%TYPE,
273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

Line 273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,

269: (p_alias IN VARCHAR2,
270: p_enabled_flag IN VARCHAR2,
271: p_resource_list_member_id IN
272: pa_resource_list_members.resource_list_member_id%TYPE,
273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

Line 274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,

270: p_enabled_flag IN VARCHAR2,
271: p_resource_list_member_id IN
272: pa_resource_list_members.resource_list_member_id%TYPE,
273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

Line 275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,

271: p_resource_list_member_id IN
272: pa_resource_list_members.resource_list_member_id%TYPE,
273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

Line 276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

272: pa_resource_list_members.resource_list_member_id%TYPE,
273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

Line 277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

273: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

Line 278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

274: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

Line 279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

275: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

Line 280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

276: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

Line 281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

277: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

Line 282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

278: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

Line 283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

279: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

Line 284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

280: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

Line 285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

281: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

Line 286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

282: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

Line 287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

283: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

Line 288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

284: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

Line 289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

285: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

Line 290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

286: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

Line 291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

287: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

Line 292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

288: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

Line 293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

289: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

Line 294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

290: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

Line 295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

291: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

Line 296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

292: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

Line 297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

293: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

Line 298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

294: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

Line 299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

295: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

Line 300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

296: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

Line 301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

297: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

Line 302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

298: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

Line 303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

299: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
307: p_record_version_number IN

Line 304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

300: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
307: p_record_version_number IN
308: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,

Line 305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

301: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
307: p_record_version_number IN
308: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
309: x_msg_count IN OUT NOCOPY NUMBER,

Line 306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

302: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
303: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
307: p_record_version_number IN
308: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
309: x_msg_count IN OUT NOCOPY NUMBER,
310: x_return_status OUT NOCOPY VARCHAR2,

Line 308: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,

304: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
305: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
306: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
307: p_record_version_number IN
308: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
309: x_msg_count IN OUT NOCOPY NUMBER,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_error_msg_data OUT NOCOPY VARCHAR2)
312: IS

Line 333: FROM pa_resource_list_members

329: IF p_mfc_cost_type_id IS NULL THEN
330: BEGIN
331: SELECT mfc_cost_type_id
332: INTO l_mfc_cost_type_id
333: FROM pa_resource_list_members
334: WHERE resource_list_member_id = p_resource_list_member_id;
335: EXCEPTION
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 356: UPDATE PA_RESOURCE_LIST_MEMBERS

352: * attribute1 etc are passed in as Null then we just
353: * default it with the value that was originally present
354: * in the DB.
355: *****************************************************************/
356: UPDATE PA_RESOURCE_LIST_MEMBERS
357: SET alias = p_alias,
358: enabled_flag = p_enabled_flag,
359: spread_curve_id = nvl(p_spread_curve_id,spread_curve_id),
360: etc_method_code = nvl(p_etc_method_code,etc_method_code),

Line 421: * Procedure and delete from the pa_resource_list_members

417: /*******************************************************
418: * Procedure : Delete_Row
419: * Description : This procedure is used to take in the parameters
420: * passed from pa_planning_resource_pub.delete_planning_resource
421: * Procedure and delete from the pa_resource_list_members
422: * table.
423: ***********************************************************/
424: PROCEDURE Delete_Row
425: (p_resource_list_member_id IN VARCHAR2,

Line 439: UPDATE pa_resource_list_members

435: * we cannot Delete the resource list member. So
436: * we are just disabling it by setting the enabled flag = 'N'.
437: **************************************************/
438: BEGIN
439: UPDATE pa_resource_list_members
440: SET enabled_flag = 'N',
441: last_update_date = sysdate,
442: record_version_number = nvl(record_version_number,0) + 1
443: WHERE resource_list_member_id = p_resource_list_member_id;

Line 456: * pa_resource_list_members table.

452: ELSE
453: /****************************************************
454: * If 'N' is returned from the above select. Then it means no
455: * CHILD recs existing, so we can go ahead and delete from
456: * pa_resource_list_members table.
457: ********************************************************/
458: BEGIN
459: DELETE FROM pa_resource_list_members
460: WHERE resource_list_member_id = p_resource_list_member_id;

Line 459: DELETE FROM pa_resource_list_members

455: * CHILD recs existing, so we can go ahead and delete from
456: * pa_resource_list_members table.
457: ********************************************************/
458: BEGIN
459: DELETE FROM pa_resource_list_members
460: WHERE resource_list_member_id = p_resource_list_member_id;
461: EXCEPTION
462: WHEN OTHERS THEN
463: FND_MSG_PUB.add_exc_msg( p_pkg_name =>