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_FP_GEN_PUB dependencies on PA_PLSQL_DATATYPES

Line 63: l_rlmid_index_map PA_PLSQL_DATATYPES.IdTabTyp;

59: --l_rat_incured_by_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
60: l_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
61:
62: -- Maps rlm_ids to indexes for l_resource_list_members_tab
63: l_rlmid_index_map PA_PLSQL_DATATYPES.IdTabTyp;
64: l_index NUMBER;
65: l_dummy NUMBER;
66:
67: --Local Variables for storing default attribute to be used in UPDATE.

Line 68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW

64: l_index NUMBER;
65: l_dummy NUMBER;
66:
67: --Local Variables for storing default attribute to be used in UPDATE.
68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW
69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;

65: l_dummy NUMBER;
66:
67: --Local Variables for storing default attribute to be used in UPDATE.
68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW
69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

66:
67: --Local Variables for storing default attribute to be used in UPDATE.
68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW
69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

67: --Local Variables for storing default attribute to be used in UPDATE.
68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW
69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

68: l_da_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp; -- NEW
69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

69: l_da_resource_list_members_tab PA_PLSQL_DATATYPES.IdTabTyp;
70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

70: l_da_resource_class_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

71: l_da_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;

Line 76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

72: l_da_resource_class_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;

73: l_da_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

74: l_da_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;

75: l_da_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

76: l_da_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

77: l_da_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

78: l_da_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

79: l_da_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

80: l_da_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

81: l_da_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;

82: l_da_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

83: l_da_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

84: l_da_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

85: l_da_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

86: l_da_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

87: l_da_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

88: l_da_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

89: l_da_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

90: l_da_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

91: l_da_etc_method_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;

92: l_da_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

93: l_da_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

94: l_da_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

95: l_da_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
103:

Line 100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

96: l_da_unit_of_measure_tab PA_PLSQL_DATATYPES.Char30TabTyp;
97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
103:
104: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

97: l_da_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
103:
104: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
105: l_etc_start_date DATE;

Line 102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

98: l_da_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
99: l_da_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
100: l_da_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
101: --l_da_rat_incured_by_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
102: l_da_incur_by_res_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
103:
104: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
105: l_etc_start_date DATE;
106: BEGIN

Line 735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

731: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UNSPENT_AMOUNT';
732:
733: l_fp_cols_rec_app_cost PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
734:
735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

732:
733: l_fp_cols_rec_app_cost PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
734:
735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

733: l_fp_cols_rec_app_cost PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
734:
735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:

Line 738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

734:
735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

Line 739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

Line 740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

736: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
737: l_rate_based_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
738: l_res_list_mem_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
739: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;

Line 751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
749:
750: /* Plan amount pl/sql tables */
751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
749:
750: /* Plan amount pl/sql tables */
751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

749:
750: /* Plan amount pl/sql tables */
751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

750: /* Plan amount pl/sql tables */
751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:

Line 755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

751: l_plan_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:
759: /* Actual amount pl/sql tables */

Line 756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

752: l_plan_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:
759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

753: l_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
754: l_plan_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
755: l_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:
759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

756: l_plan_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:
759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

757: l_plan_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
758:
759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

758:
759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

759: /* Actual amount pl/sql tables */
760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
767:

Line 764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

760: l_init_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
767:
768: /* Indices for Plan and Actual pl/sql tables */

Line 765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

761: l_init_txn_cur_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
767:
768: /* Indices for Plan and Actual pl/sql tables */
769: p_index NUMBER;

Line 766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

762: l_init_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
763: l_init_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
764: l_init_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
765: l_init_pc_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
766: l_init_txn_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
767:
768: /* Indices for Plan and Actual pl/sql tables */
769: p_index NUMBER;
770: i_index NUMBER;

Line 782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:
784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

Line 790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:
792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;

Line 817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

815:
816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

818: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:

Line 823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

819: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:
827: /* Tables for budget line Update */

Line 824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

820: l_ins_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:
827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

821: l_ins_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
822: l_ins_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
823: l_ins_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:
827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

824: l_ins_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:
827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
830: l_upd_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
832:

Line 829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

825: l_ins_burd_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
826:
827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
830: l_upd_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
832:
833: /* Variables for Fixed Dates spread curve logic */

Line 830: l_upd_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

826:
827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
830: l_upd_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
832:
833: /* Variables for Fixed Dates spread curve logic */
834: lc_fixed_date_code VARCHAR2(30) := 'FIXED_DATE';

Line 831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

827: /* Tables for budget line Update */
828: l_upd_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
829: l_upd_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
830: l_upd_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
832:
833: /* Variables for Fixed Dates spread curve logic */
834: lc_fixed_date_code VARCHAR2(30) := 'FIXED_DATE';
835: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;

Line 836: l_fixed_date_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

832:
833: /* Variables for Fixed Dates spread curve logic */
834: lc_fixed_date_code VARCHAR2(30) := 'FIXED_DATE';
835: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
836: l_fixed_date_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
837:
838: l_count NUMBER;
839: l_msg_count NUMBER;
840: l_data VARCHAR2(1000);

Line 1493: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1489: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1490: X_MSG_COUNT OUT NOCOPY NUMBER,
1491: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1492:
1493: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1494: l_wbs_element_ver_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1495: l_structure_version_id NUMBER;
1496: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
1497:

Line 1494: l_wbs_element_ver_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1490: X_MSG_COUNT OUT NOCOPY NUMBER,
1491: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1492:
1493: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1494: l_wbs_element_ver_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1495: l_structure_version_id NUMBER;
1496: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
1497:
1498: BEGIN

Line 1575: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,

1571: and the other is GL), then amounts from the less granular period must be pro-rated when
1572: copied over to the more granular period.
1573: */
1574: PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
1575: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

Line 1843: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1839: AND bl.resource_assignment_id = ra.resource_assignment_id
1840: AND ra.sp_fixed_date NOT BETWEEN bl.start_date AND bl.end_date;
1841:
1842: /* PL/SQL table variable for the cursors */
1843: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1844:
1845: l_count NUMBER;
1846: l_msg_count NUMBER;
1847: l_data VARCHAR2(1000);

Line 2017: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2013: l_log_level CONSTANT PLS_INTEGER := 5;
2014:
2015: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2016:
2017: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2018: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2020: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2021: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 2018: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2014:
2015: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
2016:
2017: l_src_version_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2018: l_gen_etc_src_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2020: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2021: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2022:

Line 2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2019: l_src_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2020: l_gen_etc_src_code PA_PROJ_FP_OPTIONS.GEN_COST_ETC_SRC_CODE%TYPE;
2021: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2022:
2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2024:
2025: /* PL/SQL tables for copying source resource assignment attributes */
2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;

2022:
2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2024:
2025: /* PL/SQL tables for copying source resource assignment attributes */
2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2023: l_tgt_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2024:
2025: /* PL/SQL tables for copying source resource assignment attributes */
2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2024:
2025: /* PL/SQL tables for copying source resource assignment attributes */
2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;

Line 2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2025: /* PL/SQL tables for copying source resource assignment attributes */
2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2026: l_resource_class_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;

Line 2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2027: l_resource_class_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;

2028: l_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2029: l_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;

2030: l_job_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2031: l_person_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2032: l_named_role_tab PA_PLSQL_DATATYPES.Char80TabTyp;
2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2033: l_bom_resource_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2034: l_non_labor_resource_tab PA_PLSQL_DATATYPES.Char20TabTyp;
2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2035: l_inventory_item_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2036: l_item_category_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2037: l_project_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2038: l_organization_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2039: l_fc_res_type_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2040: l_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2041: l_expenditure_category_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2042: l_event_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2043: l_revenue_category_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;

2044: l_supplier_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2045: l_spread_curve_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2046: l_sp_fixed_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2054: -- IPM: Added table for copying source resource_rate_based_flag values.

Line 2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2047: l_mfc_cost_type_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2054: -- IPM: Added table for copying source resource_rate_based_flag values.
2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2048: l_incurred_by_res_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2054: -- IPM: Added table for copying source resource_rate_based_flag values.
2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2056:

Line 2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2049: l_incur_by_res_cls_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2050: l_incur_by_role_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2054: -- IPM: Added table for copying source resource_rate_based_flag values.
2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2056:
2057: l_sysdate DATE;

Line 2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;

2051: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2052: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2053: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2054: -- IPM: Added table for copying source resource_rate_based_flag values.
2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2056:
2057: l_sysdate DATE;
2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2059: := FND_GLOBAL.user_id;