[Home] [Help]
90: exp_org_id pa_expenditure_items_all.organization_id%type;
91: -- expenditure organization/override organization
92: over_project_id pa_projects_all.project_id%type;
93: -- project id of the source cdl or the project type level override
94: over_task_id pa_tasks.task_id%type;
95: -- task id of the source cdl or the project type level override
96: prev_bcc_rec pa_cdl_burden_summary_v%rowtype;
97: -- Record to hold previous record from bcc_cur Cursor
98: l_attribute1 pa_projects_all.attribute1%type;
208: segment1 pa_projects_all.segment1%TYPE,
209: org_id pa_projects_all.org_id%TYPE,
210: burden_account_flag pa_project_types.burden_account_flag%TYPE,
211: dest_project_id pa_projects_all.project_id%TYPE,
212: dest_task_id pa_tasks.task_id%TYPE,
213: burden_amt_display_method pa_project_types.burden_amt_display_method%TYPE
214: );
215:
216: proj_rec proj_rec_type;
222: TYPE Typ_segment1 IS TABLE OF pa_projects_all.segment1%TYPE INDEX BY BINARY_INTEGER;
223: TYPE Typ_org_id IS TABLE OF pa_projects_all.org_id%TYPE INDEX BY BINARY_INTEGER;
224: TYPE Typ_burden_account_flag IS TABLE OF pa_project_types.burden_account_flag%TYPE INDEX BY BINARY_INTEGER;
225: TYPE Typ_dest_project_id IS TABLE OF pa_projects_all.project_id%TYPE INDEX BY BINARY_INTEGER;
226: TYPE Typ_dest_task_id IS TABLE OF pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
227: TYPE Typ_burden_amt_display_method IS TABLE OF pa_project_types.burden_amt_display_method%TYPE INDEX BY BINARY_INTEGER;
228:
229: l_tbl_project_id Typ_project_id;
230: l_tbl_segment1 Typ_segment1;
266: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'
267: and (exists (select --1 /*Added for bug#14367928 */
268: /*+ no_unnest index(CDL PA_COST_DISTRIBUTION_LINES_N10 ) */ 1
269: /*Added for bug#14531616*/
270: /* Removed ei ,pa_tasks table and changed cdl_all table to cdl view for bug# 1668634 */
271: from pa_cost_distribution_lines cdl,
272: /*2255068*/ pa_expenditure_items ei
273: where cdl.line_type = 'R'
274: and cdl.amount <> 0 --Bug 10174581
687: IF P_DEBUG_MODE THEN
688: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '450:before update CDL for error:project_task_null');
689: END IF;
690:
691: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
692: bug# 1668634 */
693:
694: /*Bug#2255068:Added loop and committed by batch.*/
695:
1265: * pa_date.
1266: */
1267: IF ( X_end_date IS NOT NULL )
1268: THEN
1269: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
1270: bug# 1668634
1271: */
1272: if PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG = 'N' then -- bug 9165385
1273:
2597: * ** Update those CDLs which are successfully processed with run id
2598: *
2599: * pa_cc_utils.log_message('2400:Update successful CDLs');
2600: *
2601: * ** Removed ei table and pa_tasks table and
2602: * changed cdl_all table to cdl view for
2603: * bug# 1668634
2604: *
2605: * update pa_cost_distribution_lines cdl