[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;
264: /* Bug#3033030 Added the following to check if the project status allows creation of
265: burden trasanction */
266: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'
267: and (exists (select 1
268: /* Removed ei ,pa_tasks table and changed cdl_all table to cdl view for bug# 1668634 */
269: from pa_cost_distribution_lines cdl,
270: /*2255068*/ pa_expenditure_items ei
271: where cdl.line_type = 'R'
272: and nvl(cdl.amount,0) <> 0
313: /* Bug#3033030 Added the following to check if the project status allows creation of
314: burden trasanction */
315: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'
316: and (( x_end_date is not null and exists (select 1
317: /* Removed ei ,pa_tasks table and changed cdl_all table to cdl view for bug# 1668634 */
318: /* Removed rownum=1 condition for the bug 4527643 (Basebug#4391999) */
319: from pa_cost_distribution_lines cdl,
320: /*2255068*/ pa_expenditure_items ei
321: where cdl.line_type = 'R'
691: IF P_DEBUG_MODE THEN
692: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '450:before update CDL for error:project_task_null');
693: END IF;
694:
695: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
696: bug# 1668634 */
697:
698: /*Bug#2255068:Added loop and committed by batch.*/
699:
1230: * pa_date.
1231: */
1232: IF ( X_end_date IS NOT NULL )
1233: THEN
1234: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
1235: bug# 1668634
1236: */
1237: update pa_cost_distribution_lines cdl
1238: set burden_sum_rejection_code = NULL,
2453: * ** Update those CDLs which are successfully processed with run id
2454: *
2455: * pa_cc_utils.log_message('2400:Update successful CDLs');
2456: *
2457: * ** Removed ei table and pa_tasks table and
2458: * changed cdl_all table to cdl view for
2459: * bug# 1668634
2460: *
2461: * update pa_cost_distribution_lines cdl