[Home] [Help]
771: FROM pa_alloc_GL_lines
772: WHERE rule_id = p_rule_id ;
773: CURSOR C_target_lines IS
774: SELECT project_id, task_id, exclude_flag, billable_only_flag
775: FROM pa_alloc_target_lines
776: WHERE rule_id = p_rule_id;
777: CURSOR C_pa_trg_exists IS
778: SELECT 1
779: FROM pa_alloc_target_lines
775: FROM pa_alloc_target_lines
776: WHERE rule_id = p_rule_id;
777: CURSOR C_pa_trg_exists IS
778: SELECT 1
779: FROM pa_alloc_target_lines
780: WHERE rule_id = p_rule_id;
781: CURSOR C_check_task( p_project_id IN NUMBER
782: , p_task_id IN NUMBER
783: , p_expnd_item_date IN DATE ) IS
796: AND TRUNC(G_sysdate) BETWEEN TRUNC(start_date_active)
797: AND TRUNC(nvl(end_date_active, G_sysdate));
798: CURSOR C_fixed_percent IS
799: SELECT nvl(sum(NVL(line_percent,0)),0)
800: FROM pa_alloc_target_lines
801: WHERE rule_id = p_rule_id;
802: CURSOR C_billable_task( p_task_id IN NUMBER
803: , p_billable_only_flag IN VARCHAR2 ) IS
804: SELECT 1
2053: , project_id
2054: , task_id
2055: , billable_only_flag
2056: , line_percent
2057: FROM pa_alloc_target_lines
2058: WHERE rule_id = p_rule_id
2059: ORDER BY 1, 2;
2060: target_lines_rec c_alloc_target_lines%ROWTYPE;
2061: Cursor c_chargeable_tasks_in_proj (x_project_id IN NUMBER,
2084: AND budget_type_code = p_bas_budget_type_code
2085: AND budget_entry_method_code = p_bas_budget_entry_method_code );
2086: CURSOR C_target_line_exists IS
2087: SELECT 1
2088: FROM pa_alloc_target_lines
2089: WHERE rule_id = p_rule_id;
2090: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;
2091: v_top_task_id NUMBER;
2092: v_retcode NUMBER;
8888: )
8889: IS
8890: cursor c_target_lines is
8891: select line_num
8892: from pa_alloc_target_lines patl
8893: where rule_id = p_rule_id;
8894: v_commit_count NUMBER ;
8895: v_do_commit VARCHAR2(1);
8896: BEGIN