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_TASK_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 21: ,start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL

17: ,task_elem_version_id NUMBER DEFAULT NULL
18: ,struct_elem_version_id NUMBER DEFAULT NULL
19: ,task_name pa_proj_elements.name%TYPE DEFAULT NULL
20: ,task_number pa_proj_elements.element_number%TYPE DEFAULT NULL
21: ,start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
22: ,end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
23: ,planned_people_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
24: ,planned_equip_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
25: ,latest_eff_pub_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE DEFAULT NULL

Line 22: ,end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL

18: ,struct_elem_version_id NUMBER DEFAULT NULL
19: ,task_name pa_proj_elements.name%TYPE DEFAULT NULL
20: ,task_number pa_proj_elements.element_number%TYPE DEFAULT NULL
21: ,start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
22: ,end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
23: ,planned_people_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
24: ,planned_equip_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
25: ,latest_eff_pub_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE DEFAULT NULL
26: );

Line 23: ,planned_people_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL

19: ,task_name pa_proj_elements.name%TYPE DEFAULT NULL
20: ,task_number pa_proj_elements.element_number%TYPE DEFAULT NULL
21: ,start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
22: ,end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
23: ,planned_people_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
24: ,planned_equip_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
25: ,latest_eff_pub_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE DEFAULT NULL
26: );
27:

Line 24: ,planned_equip_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL

20: ,task_number pa_proj_elements.element_number%TYPE DEFAULT NULL
21: ,start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
22: ,end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
23: ,planned_people_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
24: ,planned_equip_effort pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
25: ,latest_eff_pub_flag pa_proj_elem_ver_structure.latest_eff_published_flag%TYPE DEFAULT NULL
26: );
27:
28: /* This record type is used to pass the details of the resource assignments that should to be

Line 34: ,assignment_description pa_resource_assignments.assignment_description%TYPE DEFAULT NULL

30: validation API from add_planning_transactions API and update_planninng_transactions API*/
31: TYPE resource_rec_type IS RECORD
32: (
33: resource_assignment_id NUMBER DEFAULT NULL
34: ,assignment_description pa_resource_assignments.assignment_description%TYPE DEFAULT NULL
35: ,resource_list_member_id NUMBER DEFAULT NULL
36: ,planning_resource_alias pa_resource_list_members.alias%TYPE DEFAULT NULL
37: ,resource_class_flag pa_resource_list_members.resource_class_flag%TYPE DEFAULT NULL
38: ,resource_class_code pa_resource_assignments.resource_class_code%TYPE DEFAULT NULL

Line 38: ,resource_class_code pa_resource_assignments.resource_class_code%TYPE DEFAULT NULL

34: ,assignment_description pa_resource_assignments.assignment_description%TYPE DEFAULT NULL
35: ,resource_list_member_id NUMBER DEFAULT NULL
36: ,planning_resource_alias pa_resource_list_members.alias%TYPE DEFAULT NULL
37: ,resource_class_flag pa_resource_list_members.resource_class_flag%TYPE DEFAULT NULL
38: ,resource_class_code pa_resource_assignments.resource_class_code%TYPE DEFAULT NULL
39: ,resource_class_id NUMBER DEFAULT NULL
40: ,res_type_code pa_resource_assignments.res_type_code%TYPE DEFAULT NULL
41: ,resource_code VARCHAR2(30) DEFAULT NULL
42: ,resource_name VARCHAR2(240) DEFAULT NULL

Line 40: ,res_type_code pa_resource_assignments.res_type_code%TYPE DEFAULT NULL

36: ,planning_resource_alias pa_resource_list_members.alias%TYPE DEFAULT NULL
37: ,resource_class_flag pa_resource_list_members.resource_class_flag%TYPE DEFAULT NULL
38: ,resource_class_code pa_resource_assignments.resource_class_code%TYPE DEFAULT NULL
39: ,resource_class_id NUMBER DEFAULT NULL
40: ,res_type_code pa_resource_assignments.res_type_code%TYPE DEFAULT NULL
41: ,resource_code VARCHAR2(30) DEFAULT NULL
42: ,resource_name VARCHAR2(240) DEFAULT NULL
43: ,person_id NUMBER DEFAULT NULL
44: ,job_id NUMBER DEFAULT NULL

Line 45: ,person_type_code pa_resource_assignments.person_type_code%TYPE DEFAULT NULL

41: ,resource_code VARCHAR2(30) DEFAULT NULL
42: ,resource_name VARCHAR2(240) DEFAULT NULL
43: ,person_id NUMBER DEFAULT NULL
44: ,job_id NUMBER DEFAULT NULL
45: ,person_type_code pa_resource_assignments.person_type_code%TYPE DEFAULT NULL
46: ,bom_resource_id NUMBER DEFAULT NULL
47: ,non_labor_resource pa_resource_assignments.non_labor_resource%TYPE DEFAULT NULL
48: ,inventory_item_id NUMBER DEFAULT NULL
49: ,item_category_id NUMBER DEFAULT NULL

Line 47: ,non_labor_resource pa_resource_assignments.non_labor_resource%TYPE DEFAULT NULL

43: ,person_id NUMBER DEFAULT NULL
44: ,job_id NUMBER DEFAULT NULL
45: ,person_type_code pa_resource_assignments.person_type_code%TYPE DEFAULT NULL
46: ,bom_resource_id NUMBER DEFAULT NULL
47: ,non_labor_resource pa_resource_assignments.non_labor_resource%TYPE DEFAULT NULL
48: ,inventory_item_id NUMBER DEFAULT NULL
49: ,item_category_id NUMBER DEFAULT NULL
50: ,project_role_id NUMBER DEFAULT NULL
51: ,project_role_name pa_proj_roles_v.meaning%TYPE DEFAULT NULL

Line 54: ,fc_res_type_code pa_resource_assignments.fc_res_type_code%TYPE DEFAULT NULL

50: ,project_role_id NUMBER DEFAULT NULL
51: ,project_role_name pa_proj_roles_v.meaning%TYPE DEFAULT NULL
52: ,organization_id NUMBER DEFAULT NULL
53: ,organization_name hr_all_organization_units.name%TYPE DEFAULT NULL
54: ,fc_res_type_code pa_resource_assignments.fc_res_type_code%TYPE DEFAULT NULL
55: ,financial_category_code VARCHAR2(30) DEFAULT NULL
56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL
57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL
58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL

Line 56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL

52: ,organization_id NUMBER DEFAULT NULL
53: ,organization_name hr_all_organization_units.name%TYPE DEFAULT NULL
54: ,fc_res_type_code pa_resource_assignments.fc_res_type_code%TYPE DEFAULT NULL
55: ,financial_category_code VARCHAR2(30) DEFAULT NULL
56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL
57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL
58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL
59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL
60: ,supplier_id NUMBER DEFAULT NULL

Line 57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL

53: ,organization_name hr_all_organization_units.name%TYPE DEFAULT NULL
54: ,fc_res_type_code pa_resource_assignments.fc_res_type_code%TYPE DEFAULT NULL
55: ,financial_category_code VARCHAR2(30) DEFAULT NULL
56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL
57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL
58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL
59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL
60: ,supplier_id NUMBER DEFAULT NULL
61: ,project_assignment_id NUMBER DEFAULT NULL

Line 58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL

54: ,fc_res_type_code pa_resource_assignments.fc_res_type_code%TYPE DEFAULT NULL
55: ,financial_category_code VARCHAR2(30) DEFAULT NULL
56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL
57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL
58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL
59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL
60: ,supplier_id NUMBER DEFAULT NULL
61: ,project_assignment_id NUMBER DEFAULT NULL
62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL

Line 59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL

55: ,financial_category_code VARCHAR2(30) DEFAULT NULL
56: ,expenditure_type pa_resource_assignments.expenditure_type%TYPE DEFAULT NULL
57: ,expenditure_category pa_resource_assignments.expenditure_category%TYPE DEFAULT NULL
58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL
59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL
60: ,supplier_id NUMBER DEFAULT NULL
61: ,project_assignment_id NUMBER DEFAULT NULL
62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL
63: ,spread_curve_id NUMBER DEFAULT NULL

Line 62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL

58: ,event_type pa_resource_assignments.event_type%TYPE DEFAULT NULL
59: ,revenue_category_code pa_resource_assignments.revenue_category_code%TYPE DEFAULT NULL
60: ,supplier_id NUMBER DEFAULT NULL
61: ,project_assignment_id NUMBER DEFAULT NULL
62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL
63: ,spread_curve_id NUMBER DEFAULT NULL
64: ,etc_method_code pa_resource_assignments.etc_method_code%TYPE DEFAULT NULL
65: ,mfc_cost_type_id NUMBER DEFAULT NULL
66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL

Line 64: ,etc_method_code pa_resource_assignments.etc_method_code%TYPE DEFAULT NULL

60: ,supplier_id NUMBER DEFAULT NULL
61: ,project_assignment_id NUMBER DEFAULT NULL
62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL
63: ,spread_curve_id NUMBER DEFAULT NULL
64: ,etc_method_code pa_resource_assignments.etc_method_code%TYPE DEFAULT NULL
65: ,mfc_cost_type_id NUMBER DEFAULT NULL
66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL
67: ,incurred_by_res_flag pa_resource_assignments.incurred_by_res_flag%TYPE DEFAULT NULL
68: ,incur_by_resource_code VARCHAR2(30) DEFAULT NULL

Line 66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL

62: ,unit_of_measure pa_resource_assignments.unit_of_measure%TYPE DEFAULT NULL
63: ,spread_curve_id NUMBER DEFAULT NULL
64: ,etc_method_code pa_resource_assignments.etc_method_code%TYPE DEFAULT NULL
65: ,mfc_cost_type_id NUMBER DEFAULT NULL
66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL
67: ,incurred_by_res_flag pa_resource_assignments.incurred_by_res_flag%TYPE DEFAULT NULL
68: ,incur_by_resource_code VARCHAR2(30) DEFAULT NULL
69: ,incur_by_resource_name VARCHAR2(240) DEFAULT NULL
70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL

Line 67: ,incurred_by_res_flag pa_resource_assignments.incurred_by_res_flag%TYPE DEFAULT NULL

63: ,spread_curve_id NUMBER DEFAULT NULL
64: ,etc_method_code pa_resource_assignments.etc_method_code%TYPE DEFAULT NULL
65: ,mfc_cost_type_id NUMBER DEFAULT NULL
66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL
67: ,incurred_by_res_flag pa_resource_assignments.incurred_by_res_flag%TYPE DEFAULT NULL
68: ,incur_by_resource_code VARCHAR2(30) DEFAULT NULL
69: ,incur_by_resource_name VARCHAR2(240) DEFAULT NULL
70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL
71: ,Incur_by_role_id NUMBER DEFAULT NULL

Line 70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL

66: ,procure_resource_flag pa_resource_assignments.procure_resource_flag%TYPE DEFAULT NULL
67: ,incurred_by_res_flag pa_resource_assignments.incurred_by_res_flag%TYPE DEFAULT NULL
68: ,incur_by_resource_code VARCHAR2(30) DEFAULT NULL
69: ,incur_by_resource_name VARCHAR2(240) DEFAULT NULL
70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL
71: ,Incur_by_role_id NUMBER DEFAULT NULL
72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL

Line 72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL

68: ,incur_by_resource_code VARCHAR2(30) DEFAULT NULL
69: ,incur_by_resource_name VARCHAR2(240) DEFAULT NULL
70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL
71: ,Incur_by_role_id NUMBER DEFAULT NULL
72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL

Line 73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL

69: ,incur_by_resource_name VARCHAR2(240) DEFAULT NULL
70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL
71: ,Incur_by_role_id NUMBER DEFAULT NULL
72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL

Line 74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL

70: ,Incur_by_res_class_code pa_resource_assignments.Incur_by_res_class_code%TYPE DEFAULT NULL
71: ,Incur_by_role_id NUMBER DEFAULT NULL
72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL

Line 75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL

71: ,Incur_by_role_id NUMBER DEFAULT NULL
72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL
79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL

Line 76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL

72: ,use_task_schedule_flag pa_resource_assignments.use_task_schedule_flag%TYPE DEFAULT NULL
73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL
79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL
80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL

Line 77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL

73: ,planning_start_date pa_resource_assignments.planning_start_date%TYPE DEFAULT NULL
74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL
79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL
80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL
81: ,cost_rate_override NUMBER DEFAULT NULL

Line 78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL

74: ,planning_end_date pa_resource_assignments.planning_end_date%TYPE DEFAULT NULL
75: ,schedule_start_date pa_resource_assignments.schedule_start_date%TYPE DEFAULT NULL
76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL
79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL
80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL
81: ,cost_rate_override NUMBER DEFAULT NULL
82: ,burdened_rate_override NUMBER DEFAULT NULL

Line 80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL

76: ,schedule_end_date pa_resource_assignments.schedule_end_date%TYPE DEFAULT NULL
77: ,total_quantity pa_resource_assignments.total_plan_quantity%TYPE DEFAULT NULL
78: ,total_raw_cost pa_resource_assignments.total_plan_raw_cost%TYPE DEFAULT NULL
79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL
80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL
81: ,cost_rate_override NUMBER DEFAULT NULL
82: ,burdened_rate_override NUMBER DEFAULT NULL
83: ,sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE DEFAULT NULL
84: ,named_role pa_resource_assignments.named_role%TYPE DEFAULT NULL

Line 83: ,sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE DEFAULT NULL

79: ,override_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE DEFAULT NULL
80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL
81: ,cost_rate_override NUMBER DEFAULT NULL
82: ,burdened_rate_override NUMBER DEFAULT NULL
83: ,sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE DEFAULT NULL
84: ,named_role pa_resource_assignments.named_role%TYPE DEFAULT NULL
85: ,financial_category_name VARCHAR2(80) DEFAULT NULL
86: ,supplier_name VARCHAR2(240) DEFAULT NULL
87: ,wbs_element_version_id NUMBER DEFAULT NULL

Line 84: ,named_role pa_resource_assignments.named_role%TYPE DEFAULT NULL

80: ,billable_percent pa_resource_assignments.billable_percent%TYPE DEFAULT NULL
81: ,cost_rate_override NUMBER DEFAULT NULL
82: ,burdened_rate_override NUMBER DEFAULT NULL
83: ,sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE DEFAULT NULL
84: ,named_role pa_resource_assignments.named_role%TYPE DEFAULT NULL
85: ,financial_category_name VARCHAR2(80) DEFAULT NULL
86: ,supplier_name VARCHAR2(240) DEFAULT NULL
87: ,wbs_element_version_id NUMBER DEFAULT NULL
88: ,unplanned_flag VARCHAR2(1) DEFAULT NULL

Line 89: ,org_id pa_resource_assignments.rate_expenditure_org_id%TYPE DEFAULT NULL

85: ,financial_category_name VARCHAR2(80) DEFAULT NULL
86: ,supplier_name VARCHAR2(240) DEFAULT NULL
87: ,wbs_element_version_id NUMBER DEFAULT NULL
88: ,unplanned_flag VARCHAR2(1) DEFAULT NULL
89: ,org_id pa_resource_assignments.rate_expenditure_org_id%TYPE DEFAULT NULL
90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL
91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL
92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..

Line 90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL

86: ,supplier_name VARCHAR2(240) DEFAULT NULL
87: ,wbs_element_version_id NUMBER DEFAULT NULL
88: ,unplanned_flag VARCHAR2(1) DEFAULT NULL
89: ,org_id pa_resource_assignments.rate_expenditure_org_id%TYPE DEFAULT NULL
90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL
91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL
92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..
94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL

Line 91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL

87: ,wbs_element_version_id NUMBER DEFAULT NULL
88: ,unplanned_flag VARCHAR2(1) DEFAULT NULL
89: ,org_id pa_resource_assignments.rate_expenditure_org_id%TYPE DEFAULT NULL
90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL
91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL
92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..
94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL
95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL

Line 92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL

88: ,unplanned_flag VARCHAR2(1) DEFAULT NULL
89: ,org_id pa_resource_assignments.rate_expenditure_org_id%TYPE DEFAULT NULL
90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL
91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL
92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..
94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL
95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL
96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL

Line 94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL

90: ,rate_based_flag pa_resource_assignments.rate_based_flag%TYPE DEFAULT NULL
91: ,rate_expenditure_type pa_resource_assignments.rate_expenditure_type%TYPE DEFAULT NULL
92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..
94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL
95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL
96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL
97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL

Line 96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL

92: ,rate_func_curr_code pa_resource_assignments.rate_exp_func_curr_code%TYPE DEFAULT NULL
93: --parameter not used for resource defaults anymore..
94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL
95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL
96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL
97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL

Line 98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL

94: -- ,rate_incurred_by_org_id pa_resource_assignments.rate_incurred_by_organz_id%TYPE DEFAULT NULL
95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL
96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL
97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL

Line 99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL

95: ,incur_by_res_type VARCHAR2(30) DEFAULT NULL
96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL
97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL

Line 100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL

96: ,task_id pa_resource_assignments.task_id%TYPE DEFAULT NULL
97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL

Line 101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL

97: ,structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE DEFAULT NULL
98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL

Line 102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL

98: ,ATTRIBUTE_CATEGORY pa_resource_assignments.attribute_category%TYPE DEFAULT NULL
99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL

Line 103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL

99: ,ATTRIBUTE1 pa_resource_assignments.attribute1%TYPE DEFAULT NULL
100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL

Line 104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL

100: ,ATTRIBUTE2 pa_resource_assignments.attribute2%TYPE DEFAULT NULL
101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL

Line 105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL

101: ,ATTRIBUTE3 pa_resource_assignments.attribute3%TYPE DEFAULT NULL
102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL

Line 106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL

102: ,ATTRIBUTE4 pa_resource_assignments.attribute4%TYPE DEFAULT NULL
103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL

Line 107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL

103: ,ATTRIBUTE5 pa_resource_assignments.attribute5%TYPE DEFAULT NULL
104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL

Line 108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL

104: ,ATTRIBUTE6 pa_resource_assignments.attribute6%TYPE DEFAULT NULL
105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL

Line 109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL

105: ,ATTRIBUTE7 pa_resource_assignments.attribute7%TYPE DEFAULT NULL
106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL

Line 110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL

106: ,ATTRIBUTE8 pa_resource_assignments.attribute8%TYPE DEFAULT NULL
107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL

Line 111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL

107: ,ATTRIBUTE9 pa_resource_assignments.attribute9%TYPE DEFAULT NULL
108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL

Line 112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL

108: ,ATTRIBUTE10 pa_resource_assignments.attribute10%TYPE DEFAULT NULL
109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL

Line 113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL

109: ,ATTRIBUTE11 pa_resource_assignments.attribute11%TYPE DEFAULT NULL
110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL

Line 114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL

110: ,ATTRIBUTE12 pa_resource_assignments.attribute12%TYPE DEFAULT NULL
111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL

Line 115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL

111: ,ATTRIBUTE13 pa_resource_assignments.attribute13%TYPE DEFAULT NULL
112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL

Line 116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL

112: ,ATTRIBUTE14 pa_resource_assignments.attribute14%TYPE DEFAULT NULL
113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL

Line 117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL

113: ,ATTRIBUTE15 pa_resource_assignments.attribute15%TYPE DEFAULT NULL
114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL

Line 118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL

114: ,ATTRIBUTE16 pa_resource_assignments.attribute16%TYPE DEFAULT NULL
115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL

Line 119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL

115: ,ATTRIBUTE17 pa_resource_assignments.attribute17%TYPE DEFAULT NULL
116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL

Line 120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL

116: ,ATTRIBUTE18 pa_resource_assignments.attribute18%TYPE DEFAULT NULL
117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL

Line 121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL

117: ,ATTRIBUTE19 pa_resource_assignments.attribute19%TYPE DEFAULT NULL
118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL

Line 122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL

118: ,ATTRIBUTE20 pa_resource_assignments.attribute20%TYPE DEFAULT NULL
119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL

Line 123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL

119: ,ATTRIBUTE21 pa_resource_assignments.attribute21%TYPE DEFAULT NULL
120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL

Line 124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL

120: ,ATTRIBUTE22 pa_resource_assignments.attribute22%TYPE DEFAULT NULL
121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL

Line 125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL

121: ,ATTRIBUTE23 pa_resource_assignments.attribute23%TYPE DEFAULT NULL
122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL
129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL

Line 126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL

122: ,ATTRIBUTE24 pa_resource_assignments.attribute24%TYPE DEFAULT NULL
123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL
129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL
130: );

Line 127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL

123: ,ATTRIBUTE25 pa_resource_assignments.attribute25%TYPE DEFAULT NULL
124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL
129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL
130: );
131:

Line 128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL

124: ,ATTRIBUTE26 pa_resource_assignments.attribute26%TYPE DEFAULT NULL
125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL
129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL
130: );
131:
132: --

Line 129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL

125: ,ATTRIBUTE27 pa_resource_assignments.attribute27%TYPE DEFAULT NULL
126: ,ATTRIBUTE28 pa_resource_assignments.attribute28%TYPE DEFAULT NULL
127: ,ATTRIBUTE29 pa_resource_assignments.attribute29%TYPE DEFAULT NULL
128: ,ATTRIBUTE30 pa_resource_assignments.attribute30%TYPE DEFAULT NULL
129: ,scheduled_delay pa_resource_assignments.scheduled_delay%TYPE DEFAULT NULL
130: );
131:
132: --
133: -- Global Variables

Line 135: g_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;

131:
132: --
133: -- Global Variables
134: --
135: g_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
136:
137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;
138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:

Line 137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;

133: -- Global Variables
134: --
135: g_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
136:
137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;
138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;

Line 138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;

134: --
135: g_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
136:
137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;
138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;

Line 140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;

136:
137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;
138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;

Line 141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;

137: g_baselined_asgmt_start_date pa_resource_assignments.planning_end_date%TYPE;
138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;

Line 142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;

138: g_baselined_asgmt_end_date pa_resource_assignments.planning_start_date%TYPE;
139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;

Line 143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;

139:
140: g_baselined_planned_qty pa_resource_assignments.total_plan_quantity%TYPE;
141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:

Line 145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;

141: g_bl_planned_bur_cost_txn_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:

Line 146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;

142: g_bl_bur_cost_proj_cur pa_resource_assignments.total_project_burdened_cost%TYPE;
143: g_bl_bur_cost_projfunc_cur pa_resource_assignments.total_plan_burdened_cost%TYPE;
144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;

Line 148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;

144: g_bl_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;
145: g_bl_raw_cost_proj_cur pa_resource_assignments.total_project_raw_cost%TYPE;
146: g_bl_raw_cost_projfunc_cur pa_resource_assignments.total_plan_raw_cost%TYPE;
147:
148: g_pl_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
149:
150: g_planned_quantity pa_budget_lines.quantity%TYPE;
151: g_planned_bur_cost_txn_cur pa_budget_lines.txn_burdened_cost%TYPE;
152: g_planned_raw_cost_txn_cur pa_budget_lines.txn_raw_cost%TYPE;

Line 159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;

155: g_act_raw_cost_txn_cur pa_budget_lines.init_raw_cost%TYPE;
156: g_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
157: g_avg_bur_cost_rate pa_budget_lines.burden_cost_rate%TYPE;
158:
159: g_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE := -999;
160:
161: g_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
162:
163: g_ta_display_flag VARCHAR2(1) := 'N';

Line 339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

335:
336: FUNCTION get_baselined_asgmt_dates(
337: p_project_id IN pa_projects_all.project_id%TYPE,
338: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
339: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
340: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
341: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
342: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
343: p_code IN VARCHAR2) RETURN DATE;

Line 348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

344:
345: FUNCTION get_baselined_asgmt_amounts(
346: p_project_id IN pa_projects_all.project_id%TYPE,
347: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
348: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
349: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
350: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
351: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
352: p_code IN VARCHAR2) RETURN NUMBER;

Line 356: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

352: p_code IN VARCHAR2) RETURN NUMBER;
353:
354: /*Commented for bug#6798529
355: FUNCTION get_planned_asgmt_amounts(
356: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
357: p_code IN VARCHAR2) RETURN NUMBER;
358: */
359:
360: FUNCTION get_planned_currency_info(

Line 361: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

357: p_code IN VARCHAR2) RETURN NUMBER;
358: */
359:
360: FUNCTION get_planned_currency_info(
361: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
362: p_project_id IN pa_projects_all.project_id%TYPE,
363: p_code IN VARCHAR2) RETURN VARCHAR2;
364:
365: FUNCTION get_task_level_record(