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 16: * procedure and insert into the pa_resource_list_members

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

Line 21: pa_resource_list_members.resource_list_member_id%TYPE,

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

Line 22: p_resource_list_id IN pa_resource_list_members.resource_list_id%TYPE,

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

Line 23: p_resource_id IN pa_resource_list_members.resource_id%TYPE,

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

Line 24: p_resource_alias IN pa_resource_list_members.alias%TYPE,

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

Line 25: p_person_id IN pa_resource_list_members.person_id%TYPE,

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

Line 26: p_job_id IN pa_resource_list_members.job_id%TYPE ,

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

Line 27: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,

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

Line 28: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,

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

Line 29: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,

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

Line 30: p_event_type IN pa_resource_list_members.event_type%TYPE ,

26: p_job_id IN pa_resource_list_members.job_id%TYPE ,
27: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
28: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
29: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
30: p_event_type IN pa_resource_list_members.event_type%TYPE ,
31: p_non_labor_resource IN 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 ,

Line 31: p_non_labor_resource IN pa_resource_list_members.non_labor_resource%TYPE ,

27: p_organization_id IN pa_resource_list_members.organization_id%TYPE ,
28: p_vendor_id IN pa_resource_list_members.vendor_id%TYPE ,
29: p_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
30: p_event_type IN pa_resource_list_members.event_type%TYPE ,
31: p_non_labor_resource IN 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_expenditure_type IN pa_resource_list_members.expenditure_type%TYPE ,
30: p_event_type IN pa_resource_list_members.event_type%TYPE ,
31: p_non_labor_resource IN 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_event_type IN pa_resource_list_members.event_type%TYPE ,
31: p_non_labor_resource IN 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 pa_resource_list_members.resource_class_code%TYPE,

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 pa_resource_list_members.resource_class_code%TYPE,
39: p_res_format_id IN NUMBER ,
40: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,

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 pa_resource_list_members.resource_class_code%TYPE,
39: p_res_format_id IN NUMBER ,
40: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
41: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,

Line 38: p_res_class_code IN pa_resource_list_members.resource_class_code%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 pa_resource_list_members.resource_class_code%TYPE,
39: p_res_format_id IN NUMBER ,
40: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
41: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
42: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,

Line 40: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,

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 pa_resource_list_members.resource_class_code%TYPE,
39: p_res_format_id IN NUMBER ,
40: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE ,
41: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,
42: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,
43: p_res_class_flag IN pa_resource_list_members.resource_class_flag%TYPE ,
44: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,

Line 41: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE ,

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

Line 42: p_mfc_cost_type_id IN pa_resource_list_members.mfc_cost_type_id%TYPE ,

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

Line 43: p_res_class_flag IN pa_resource_list_members.resource_class_flag%TYPE ,

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

Line 44: p_fc_res_type_code IN pa_resource_list_members.fc_res_type_code%TYPE ,

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

Line 45: p_inventory_item_id IN pa_resource_list_members.inventory_item_id%TYPE ,

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

Line 46: p_item_category_id IN pa_resource_list_members.item_category_id%TYPE,

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

Line 47: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

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

Line 48: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

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

Line 49: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

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

Line 50: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

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

Line 51: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

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

Line 52: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

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

Line 53: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

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

Line 54: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

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

Line 55: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

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

Line 56: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

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

Line 57: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

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

Line 58: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

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

Line 59: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

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

Line 60: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

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

Line 61: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

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

Line 62: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

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

Line 63: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

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

Line 64: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

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

Line 65: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

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

Line 66: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

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

Line 67: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

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

Line 68: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

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

Line 69: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

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

Line 70: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

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

Line 71: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

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

Line 72: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

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

Line 73: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

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

Line 74: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

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

Line 75: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

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

Line 76: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

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

Line 77: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

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

Line 78: p_person_type_code IN pa_resource_list_members.person_type_code%TYPE,

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

Line 79: p_bom_resource_id IN pa_resource_list_members.bom_resource_id%TYPE,

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

Line 80: p_team_role IN pa_resource_list_members.team_role%TYPE,

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

Line 82: pa_resource_list_members.incurred_by_res_flag%TYPE,

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

Line 84: pa_resource_list_members.incur_by_res_class_code%TYPE,

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

Line 85: p_incur_by_role_id IN pa_resource_list_members.incur_by_role_id%TYPE,

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

Line 86: p_object_type IN pa_resource_list_members.object_type%TYPE,

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

Line 87: p_object_id IN pa_resource_list_members.object_id%TYPE,

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

Line 88: p_wp_eligible_flag IN pa_resource_list_members.wp_eligible_flag%TYPE,

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

Line 89: p_unit_of_measure IN pa_resource_list_members.unit_of_measure%TYPE,

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

Line 99: * procedure and update the pa_resource_list_members

95: * Procedure : Update_Row
96: * Description : This procedure is used to take in parameters
97: * passed from the
98: * pa_planning_resource_pub.update_planning_resource
99: * procedure and update the pa_resource_list_members
100: * table.
101: ****************************************************/
102: PROCEDURE UPDATE_ROW
103: (p_alias IN VARCHAR2,

Line 106: pa_resource_list_members.resource_list_member_id%TYPE,

102: PROCEDURE UPDATE_ROW
103: (p_alias IN VARCHAR2,
104: p_enabled_flag IN VARCHAR2,
105: p_resource_list_member_id IN
106: pa_resource_list_members.resource_list_member_id%TYPE,
107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

Line 107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,

103: (p_alias IN VARCHAR2,
104: p_enabled_flag IN VARCHAR2,
105: p_resource_list_member_id IN
106: pa_resource_list_members.resource_list_member_id%TYPE,
107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

Line 108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,

104: p_enabled_flag IN VARCHAR2,
105: p_resource_list_member_id IN
106: pa_resource_list_members.resource_list_member_id%TYPE,
107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

Line 109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,

105: p_resource_list_member_id IN
106: pa_resource_list_members.resource_list_member_id%TYPE,
107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

Line 110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,

106: pa_resource_list_members.resource_list_member_id%TYPE,
107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

Line 111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,

107: p_spread_curve_id IN pa_resource_list_members.spread_curve_id%TYPE,
108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

Line 112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,

108: p_etc_method_code IN pa_resource_list_members.etc_method_code%TYPE,
109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

Line 113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,

109: p_mfc_cost_type_id IN pa_resource_list_members.MFC_COST_TYPE_ID%TYPE ,
110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

Line 114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,

110: p_attribute_category IN pa_resource_list_members.attribute_category%TYPE,
111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

Line 115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,

111: p_attribute1 IN pa_resource_list_members.attribute1%TYPE,
112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

Line 116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,

112: p_attribute2 IN pa_resource_list_members.attribute2%TYPE,
113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

Line 117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,

113: p_attribute3 IN pa_resource_list_members.attribute3%TYPE,
114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

Line 118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,

114: p_attribute4 IN pa_resource_list_members.attribute4%TYPE,
115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

Line 119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,

115: p_attribute5 IN pa_resource_list_members.attribute5%TYPE,
116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

Line 120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,

116: p_attribute6 IN pa_resource_list_members.attribute6%TYPE,
117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

Line 121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,

117: p_attribute7 IN pa_resource_list_members.attribute7%TYPE,
118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

Line 122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,

118: p_attribute8 IN pa_resource_list_members.attribute8%TYPE,
119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

Line 123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,

119: p_attribute9 IN pa_resource_list_members.attribute9%TYPE,
120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

Line 124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,

120: p_attribute10 IN pa_resource_list_members.attribute10%TYPE,
121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

Line 125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,

121: p_attribute11 IN pa_resource_list_members.attribute11%TYPE,
122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

Line 126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,

122: p_attribute12 IN pa_resource_list_members.attribute12%TYPE,
123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

Line 127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,

123: p_attribute13 IN pa_resource_list_members.attribute13%TYPE,
124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

Line 128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,

124: p_attribute14 IN pa_resource_list_members.attribute14%TYPE,
125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

Line 129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,

125: p_attribute15 IN pa_resource_list_members.attribute15%TYPE,
126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

Line 130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,

126: p_attribute16 IN pa_resource_list_members.attribute16%TYPE,
127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

Line 131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,

127: p_attribute17 IN pa_resource_list_members.attribute17%TYPE,
128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

Line 132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,

128: p_attribute18 IN pa_resource_list_members.attribute18%TYPE,
129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

Line 133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,

129: p_attribute19 IN pa_resource_list_members.attribute19%TYPE,
130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

Line 134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,

130: p_attribute20 IN pa_resource_list_members.attribute20%TYPE,
131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

Line 135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,

131: p_attribute21 IN pa_resource_list_members.attribute21%TYPE,
132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

Line 136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,

132: p_attribute22 IN pa_resource_list_members.attribute22%TYPE,
133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

Line 137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,

133: p_attribute23 IN pa_resource_list_members.attribute23%TYPE,
134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141: p_record_version_number IN

Line 138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,

134: p_attribute24 IN pa_resource_list_members.attribute24%TYPE,
135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141: p_record_version_number IN
142: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,

Line 139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,

135: p_attribute25 IN pa_resource_list_members.attribute25%TYPE,
136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141: p_record_version_number IN
142: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
143: x_msg_count IN OUT NOCOPY NUMBER,

Line 140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,

136: p_attribute26 IN pa_resource_list_members.attribute26%TYPE,
137: p_attribute27 IN pa_resource_list_members.attribute27%TYPE,
138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141: p_record_version_number IN
142: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
143: x_msg_count IN OUT NOCOPY NUMBER,
144: x_return_status OUT NOCOPY VARCHAR2,

Line 142: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,

138: p_attribute28 IN pa_resource_list_members.attribute28%TYPE,
139: p_attribute29 IN pa_resource_list_members.attribute29%TYPE,
140: p_attribute30 IN pa_resource_list_members.attribute30%TYPE,
141: p_record_version_number IN
142: pa_resource_list_members.RECORD_VERSION_NUMBER%TYPE,
143: x_msg_count IN OUT NOCOPY NUMBER,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_error_msg_data OUT NOCOPY VARCHAR2 )
146: ;

Line 153: * procedure and update the pa_resource_list_members

149: * Procedure : Delete_Row
150: * Description : This procedure is used to take in parameters
151: * passed from the
152: * pa_planning_resource_pub.update_planning_resource
153: * procedure and update the pa_resource_list_members
154: * table.
155: ****************************************************/
156: PROCEDURE DELETE_ROW
157: (p_resource_list_member_id IN VARCHAR2,