[Home] [Help]
8: End of Comments
9: */
10:
11: FUNCTION calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER
76: end calculate_gl_total;
77: /* ------------------------------------------------------------------ */
78:
79: FUNCTION calculate_pa_total
80: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
81: p_project_id IN pa_resource_assignments.project_id%TYPE,
82: p_task_id IN pa_resource_assignments.task_id%TYPE,
83: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
84: return NUMBER
4824: end roll_up_budget_lines;
4825:
4826:
4827: FUNCTION get_amttype_id
4828: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4829: is
4830: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
4831: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
4832: l_amt_id pa_fp_view_plans_util.number_data_type_table;
4826:
4827: FUNCTION get_amttype_id
4828: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4829: is
4830: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
4831: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
4832: l_amt_id pa_fp_view_plans_util.number_data_type_table;
4833:
4834: l_debug_mode VARCHAR2(30);
4835:
4836: CURSOR get_amt_det IS
4837: SELECT atb.amount_type_id
4838: ,atb.amount_type_code
4839: FROM pa_amount_types_b atb
4840: WHERE atb.amount_type_class = 'R';
4841:
4842: l_stage number := 0;
4843: