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_PROCESS_CI_LINES_PKG dependencies on PA_NUM_TBL_TYPE

Line 22: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,

18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_bvid IN NUMBER,
21: p_project_id in NUMBER,
22: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
23: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
24: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
25: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
26: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 25: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

21: p_project_id in NUMBER,
22: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
23: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
24: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
25: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
26: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
27: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
28: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
29: ) IS

Line 26: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

22: p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
23: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
24: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
25: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
26: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
27: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
28: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
29: ) IS
30:

Line 27: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

23: p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
24: p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
25: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
26: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
27: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
28: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
29: ) IS
30:
31:

Line 36: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

32: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
33: l_task_number_tbl SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
34: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
35: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
36: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
37: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
38: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
39: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
40: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 37: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

33: l_task_number_tbl SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
34: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
35: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
36: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
37: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
38: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
39: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
40: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
41: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 39: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

35: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
36: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
37: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
38: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
39: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
40: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
41: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
42: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
43: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 43: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

39: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
40: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
41: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
42: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
43: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
44: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
45: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
46: l_resource_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
47: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 47: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

43: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
44: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
45: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
46: l_resource_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
47: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
48: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
49: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
50: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
51: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 49: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

45: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
46: l_resource_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
47: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
48: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
49: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
50: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
51: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
52: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
53: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 53: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

49: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
50: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
51: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
52: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
53: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
54: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
55: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
56: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
57: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 55: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

51: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
52: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
53: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
54: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
55: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
56: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
57: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
58: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
59: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 57: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

53: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
54: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
55: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
56: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
57: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
58: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
59: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
60: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
61: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 67: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

63: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
64: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
65: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
66: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
67: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
68: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

65: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
66: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
67: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
68: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

66: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
67: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
68: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

67: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
68: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
75: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

68: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
75: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
76: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

69: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
75: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
76: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
77: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

70: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
71: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
72: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
73: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
74: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
75: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
76: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
77: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
78: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 81: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

77: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
78: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
79: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
80: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
81: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
82: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
83: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 83: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

79: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
80: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
81: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
82: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
83: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

80: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
81: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
82: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
83: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

83: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

84: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:

Line 89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

85: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

86:
87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
94: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();

Line 91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

87: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
88: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
94: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
95: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

89: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
90: l_burdened_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
94: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
95: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
96: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
97:

Line 95: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

91: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
94: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
95: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
96: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
97:
98: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
99: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 96: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

92:
93: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
94: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
95: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
96: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
97:
98: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
99: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
100: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 104: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

100: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
101: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
102:
103: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
104: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
105:
106: l_struct_elem_version_id Pa_proj_element_versions.parent_structure_version_id%TYPE := -1;
107: l_elem_ver_id Pa_proj_element_versions.element_version_id%TYPE := -1;
108:

Line 649: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

645: x_msg_count OUT NOCOPY NUMBER,
646: x_msg_data OUT NOCOPY VARCHAR2,
647: p_bvid IN number,
648: p_project_id IN number,
649: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
650: p_currency_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
651: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE
652: ) IS
653:

Line 651: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE

647: p_bvid IN number,
648: p_project_id IN number,
649: p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
650: p_currency_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
651: p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE
652: ) IS
653:
654: cursor get_assignment_details(c_bvId number,
655: c_task_id number,

Line 679: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

675: -- gboomina modified for bug 9714622 to fetch correct element version id
676: and pevs.element_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(c_proj_id);
677:
678:
679: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
680: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
681: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
682: l_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
683:

Line 682: l_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

678:
679: l_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
680: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
681: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
682: l_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
683:
684: l_resource_assignment_id number;
685: l_task_number varchar2(30);
686: l_task_name varchar2(30);

Line 689: l_rbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

685: l_task_number varchar2(30);
686: l_task_name varchar2(30);
687: l_task_elem_version_id number;
688:
689: l_rbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
690: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.pa_varchar2_1_tbl_type();
691: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
692:
693: l_api_name CONSTANT VARCHAR2(30) := 'CI.delete_planning_trx';

Line 829: P_TASK_ID_TBL IN SYSTEM.pa_num_tbl_type,

825: x_msg_count OUT NOCOPY NUMBER,
826: x_msg_data OUT NOCOPY VARCHAR2,
827: P_BVID IN NUMBER,
828: P_PROJECT_ID IN NUMBER,
829: P_TASK_ID_TBL IN SYSTEM.pa_num_tbl_type,
830: P_RLMI_ID_TBL IN SYSTEM.pa_num_tbl_type,
831: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,
833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type

Line 830: P_RLMI_ID_TBL IN SYSTEM.pa_num_tbl_type,

826: x_msg_data OUT NOCOPY VARCHAR2,
827: P_BVID IN NUMBER,
828: P_PROJECT_ID IN NUMBER,
829: P_TASK_ID_TBL IN SYSTEM.pa_num_tbl_type,
830: P_RLMI_ID_TBL IN SYSTEM.pa_num_tbl_type,
831: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,
833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type
834: ) IS

Line 832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,

828: P_PROJECT_ID IN NUMBER,
829: P_TASK_ID_TBL IN SYSTEM.pa_num_tbl_type,
830: P_RLMI_ID_TBL IN SYSTEM.pa_num_tbl_type,
831: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,
833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type
834: ) IS
835: --{
836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type

829: P_TASK_ID_TBL IN SYSTEM.pa_num_tbl_type,
830: P_RLMI_ID_TBL IN SYSTEM.pa_num_tbl_type,
831: P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,
833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type
834: ) IS
835: --{
836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

832: P_QUANTITY_TBL IN SYSTEM.pa_num_tbl_type,
833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type
834: ) IS
835: --{
836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

833: P_RAW_COST_TBL IN SYSTEM.pa_num_tbl_type
834: ) IS
835: --{
836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

834: ) IS
835: --{
836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

836: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

837: l_resource_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

838: l_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
846: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

839: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
846: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
847: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

840: l_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
846: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
847: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
848:

Line 845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

841: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
842: l_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
843: l_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
844: l_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
845: l_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
846: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
847: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
848:
849:

Line 1016: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1012: p_calling_context IN VARCHAR2,
1013: p_action_type IN VARCHAR2,
1014: p_bvid IN NUMBER,
1015: p_ci_id IN NUMBER,
1016: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1017: p_project_id IN NUMBER,
1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1014: p_bvid IN NUMBER,
1015: p_ci_id IN NUMBER,
1016: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1017: p_project_id IN NUMBER,
1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1016: p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1017: p_project_id IN NUMBER,
1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1017: p_project_id IN NUMBER,
1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1018: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1026: ) IS

Line 1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

1019: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1026: ) IS
1027:

Line 1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1020: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1026: ) IS
1027:
1028:

Line 1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

1021: p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1022: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1023: DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
1024: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1025: DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1026: ) IS
1027:
1028:
1029: cursor dc_csr (p_ci_id number, p_project_id number,

Line 1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1058:
1059: j number := 0;
1060: TYPE varchar1_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1061:
1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1059: j number := 0;
1060: TYPE varchar1_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1061:
1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1060: TYPE varchar1_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1061:
1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1061:
1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1062: rollup_project_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1063: rollup_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1064: rollup_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1065: rollup_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1071: db_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1066: rollup_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1071: db_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1072: db_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1073:
1074: rollup_currency_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();

Line 1071: db_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1067: rollup_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1071: db_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1072: db_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1073:
1074: rollup_currency_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
1075: rollup_rate_based varchar1_tbl;

Line 1072: db_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1068: rollup_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1069: rollup_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1070: db_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1071: db_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1072: db_res_assgn_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1073:
1074: rollup_currency_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
1075: rollup_rate_based varchar1_tbl;
1076: rollup_ra_exists varchar1_tbl;

Line 1079: upd_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1075: rollup_rate_based varchar1_tbl;
1076: rollup_ra_exists varchar1_tbl;
1077: rolled_up varchar1_tbl;
1078:
1079: upd_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1080: upd_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1081: upd_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1082: upd_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1082: upd_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1078:
1079: upd_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1080: upd_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1081: upd_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1082: upd_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:

Line 1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1079: upd_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1080: upd_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1081: upd_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1082: upd_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1080: upd_effective_from SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1081: upd_effective_to SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
1082: upd_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1083: upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1084: upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1092:

Line 1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1085: upd_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1092:
1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1086:
1087: ins_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1088: ins_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1092:
1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1094: del_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1089: ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1092:
1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1094: del_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1095: del_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1096:
1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

Line 1094: del_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1090: ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1091: ins_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1092:
1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1094: del_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1095: del_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1096:
1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1098:

Line 1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1093: del_task_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1094: del_rlmi_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1095: del_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1096:
1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1098:
1099: qty_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1100: amt_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1101:

Line 1099: qty_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1095: del_currency_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1096:
1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1098:
1099: qty_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1100: amt_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1101:
1102: TYPE num_tbl is table of number index by binary_integer;
1103: rollup_count NUM_TBL;

Line 1100: amt_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();

1096:
1097: ip_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1098:
1099: qty_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1100: amt_from_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.pa_num_tbl_type();
1101:
1102: TYPE num_tbl is table of number index by binary_integer;
1103: rollup_count NUM_TBL;
1104:

Line 1136: txn_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1132: --and prc.total_txn_raw_cost is not null;
1133:
1134: l_rate_based_res_curr varchar2(15);
1135:
1136: txn_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1137: txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1138:
1139: subtype PaCiDirCostTblType is pa_ci_dir_cost_pvt.PaCiDirectCostDetailsTblType;
1140: DeleteDCTblRecs PaCiDirCostTblType;

Line 1137: txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1133:
1134: l_rate_based_res_curr varchar2(15);
1135:
1136: txn_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1137: txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1138:
1139: subtype PaCiDirCostTblType is pa_ci_dir_cost_pvt.PaCiDirectCostDetailsTblType;
1140: DeleteDCTblRecs PaCiDirCostTblType;
1141: