[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
4994: end roll_up_budget_lines;
4995:
4996:
4997: FUNCTION get_amttype_id
4998: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4999: is
5000: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
5001: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
5002: l_amt_id pa_fp_view_plans_util.number_data_type_table;
4996:
4997: FUNCTION get_amttype_id
4998: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4999: is
5000: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
5001: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
5002: l_amt_id pa_fp_view_plans_util.number_data_type_table;
5003:
5004: l_debug_mode VARCHAR2(30);
5005:
5006: CURSOR get_amt_det IS
5007: SELECT atb.amount_type_id
5008: ,atb.amount_type_code
5009: FROM pa_amount_types_b atb
5010: WHERE atb.amount_type_class = 'R';
5011:
5012: l_stage number := 0;
5013: