136: End Get_RPT_Budget_Type;
137:
138: -------------------------------------------------------------------------
139: Begin
140: cost_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE1_COST');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
137:
138: -------------------------------------------------------------------------
139: Begin
140: cost_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE1_COST');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
138: -------------------------------------------------------------------------
139: Begin
140: cost_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE1_COST');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
139: Begin
140: cost_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE1_COST');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
140: cost_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE1_COST');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
141: cost_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE2_COST');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
149: class_category3 := fnd_profile.value('PA_RPT_CLASS_CATEGORY3');
142: revenue_budget_typecode1 := fnd_profile.value('PA_RPT_BUDGET_TYPE3_REV');
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
149: class_category3 := fnd_profile.value('PA_RPT_CLASS_CATEGORY3');
150: Unassigned_txt := fnd_message.get_string('PA',
143: revenue_budget_typecode2 := fnd_profile.value('PA_RPT_BUDGET_TYPE4_REV');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
149: class_category3 := fnd_profile.value('PA_RPT_CLASS_CATEGORY3');
150: Unassigned_txt := fnd_message.get_string('PA',
151: 'PA_BIS_PAPFPJCL_UNASSIGNED');
144: role_type1 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE1');
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
149: class_category3 := fnd_profile.value('PA_RPT_CLASS_CATEGORY3');
150: Unassigned_txt := fnd_message.get_string('PA',
151: 'PA_BIS_PAPFPJCL_UNASSIGNED');
152:
145: role_type2 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE2');
146: role_type3 := fnd_profile.value('PA_RPT_PROJ_ROLE_TYPE3');
147: class_category1 := fnd_profile.value('PA_RPT_CLASS_CATEGORY1');
148: class_category2 := fnd_profile.value('PA_RPT_CLASS_CATEGORY2');
149: class_category3 := fnd_profile.value('PA_RPT_CLASS_CATEGORY3');
150: Unassigned_txt := fnd_message.get_string('PA',
151: 'PA_BIS_PAPFPJCL_UNASSIGNED');
152:
153: Select Start_date, End_date