eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_DEBUG

Line 8: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4: ----------------------------------------------------------------
5: --Procedure Transfer_ar_ap_invoices is a wrapper to convert the
6: --data types for input parameters
7: ----------------------------------------------------------------
8: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
9:
10: Procedure Create_Ubr_Uer_Summary_Balance(
11: p_from_project_number in varchar2,
12: p_to_project_number in varchar2,

Line 34: pa_debug.write_file('Create_Ubr_Uer_Summary_Balance: ' || 'START org id '||to_char(org_rec.org_id));

30:
31: FOR org_rec in org_cv LOOP
32:
33: IF g1_debug_mode = 'Y' THEN
34: pa_debug.write_file('Create_Ubr_Uer_Summary_Balance: ' || 'START org id '||to_char(org_rec.org_id));
35: END IF;
36:
37: if ( Initialize( org_rec.org_id ) ) then
38:

Line 39: -- pa_debug.write_file('--------------BEFORE DR---------------------- ');

35: END IF;
36:
37: if ( Initialize( org_rec.org_id ) ) then
38:
39: -- pa_debug.write_file('--------------BEFORE DR---------------------- ');
40: process_draft_revenues;
41:
42: -- pa_debug.write_file('--------------BEFORE DI---------------------- ');
43: process_draft_invoices;

Line 42: -- pa_debug.write_file('--------------BEFORE DI---------------------- ');

38:
39: -- pa_debug.write_file('--------------BEFORE DR---------------------- ');
40: process_draft_revenues;
41:
42: -- pa_debug.write_file('--------------BEFORE DI---------------------- ');
43: process_draft_invoices;
44:
45: -- pa_debug.write_file('--------------AFTER DR - DI---------------------- ');
46:

Line 45: -- pa_debug.write_file('--------------AFTER DR - DI---------------------- ');

41:
42: -- pa_debug.write_file('--------------BEFORE DI---------------------- ');
43: process_draft_invoices;
44:
45: -- pa_debug.write_file('--------------AFTER DR - DI---------------------- ');
46:
47: end if;
48: END LOOP;
49:

Line 56: -- pa_debug.write_file('BEFORE SELECT 1 ');

52:
53: function Initialize ( p_org_id in number ) return boolean is
54: begin
55:
56: -- pa_debug.write_file('BEFORE SELECT 1 ');
57:
58: G_org_id := p_org_id;
59:
60: SELECT

Line 82: -- pa_debug.write_file('AFTER SELECT 1 ');

78: and G_p_gl_period_name = gl1.period_name )
79: OR( G_p_gl_period_name is null
80: and trunc(sysdate) between gl1.start_date and gl1.end_date ));
81:
82: -- pa_debug.write_file('AFTER SELECT 1 ');
83: -- Get the segment number.
84:
85: IF (NOT fnd_flex_apis.get_qualifier_segnum(
86: appl_id => 101,

Line 103: pa_debug.write_file(' cost_num '||G_cost_seg_num);

99: app_exception.raise_exception;
100: END IF;
101:
102: /*
103: pa_debug.write_file(' cost_num '||G_cost_seg_num);
104: pa_debug.write_file(' acct_num '||G_acct_seg_num);
105: */
106:
107: -- Get the segment name.

Line 104: pa_debug.write_file(' acct_num '||G_acct_seg_num);

100: END IF;
101:
102: /*
103: pa_debug.write_file(' cost_num '||G_cost_seg_num);
104: pa_debug.write_file(' acct_num '||G_acct_seg_num);
105: */
106:
107: -- Get the segment name.
108:

Line 133: pa_debug.write_file(' G_cost_appcol_name '||G_cost_appcol_name);

129: app_exception.raise_exception;
130: END IF;
131:
132: /*
133: pa_debug.write_file(' G_cost_appcol_name '||G_cost_appcol_name);
134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);
135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:

Line 134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);

130: END IF;
131:
132: /*
133: pa_debug.write_file(' G_cost_appcol_name '||G_cost_appcol_name);
134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);
135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);

Line 135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);

131:
132: /*
133: pa_debug.write_file(' G_cost_appcol_name '||G_cost_appcol_name);
134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);
135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);

Line 136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);

132: /*
133: pa_debug.write_file(' G_cost_appcol_name '||G_cost_appcol_name);
134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);
135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);
140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);

Line 138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);

134: pa_debug.write_file(' G_cost_seg_name '||G_cost_seg_name);
135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);
140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);
141: pa_debug.write_file(' G_acct_value_set_name '||G_acct_value_set_name);
142: */

Line 139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);

135: pa_debug.write_file(' G_cost_prompt '||G_cost_prompt);
136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);
140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);
141: pa_debug.write_file(' G_acct_value_set_name '||G_acct_value_set_name);
142: */
143: return true;

Line 140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);

136: pa_debug.write_file(' G_cost_value_set_name '||G_cost_value_set_name);
137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);
140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);
141: pa_debug.write_file(' G_acct_value_set_name '||G_acct_value_set_name);
142: */
143: return true;
144:

Line 141: pa_debug.write_file(' G_acct_value_set_name '||G_acct_value_set_name);

137:
138: pa_debug.write_file(' G_acct_appcol_name '||G_acct_appcol_name);
139: pa_debug.write_file(' G_acct_seg_name '||G_acct_seg_name);
140: pa_debug.write_file(' G_acct_prompt '||G_acct_prompt);
141: pa_debug.write_file(' G_acct_value_set_name '||G_acct_value_set_name);
142: */
143: return true;
144:
145: exception

Line 297: -- pa_debug.write_file('*START DR PROCESSING**');

293: -- order by dr.project_id;
294:
295: begin
296:
297: -- pa_debug.write_file('*******START DR PROCESSING********');
298: OPEN dr_cv;
299:
300: -- pa_debug.write_file('After Open');
301:

Line 300: -- pa_debug.write_file('After Open');

296:
297: -- pa_debug.write_file('*******START DR PROCESSING********');
298: OPEN dr_cv;
299:
300: -- pa_debug.write_file('After Open');
301:
302: LOOP
303: -- pa_debug.write_file('Before fetch of draft revenues ');
304: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');

Line 303: -- pa_debug.write_file('Before fetch of draft revenues ');

299:
300: -- pa_debug.write_file('After Open');
301:
302: LOOP
303: -- pa_debug.write_file('Before fetch of draft revenues ');
304: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');
305:
306: l_project_id_arr.delete;
307: l_draft_rev_num_arr.delete;

Line 304: -- pa_debug.write_file('LEV2:*Start of the Batch***');

300: -- pa_debug.write_file('After Open');
301:
302: LOOP
303: -- pa_debug.write_file('Before fetch of draft revenues ');
304: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');
305:
306: l_project_id_arr.delete;
307: l_draft_rev_num_arr.delete;
308: l_ubr_acct_seg_arr.delete;

Line 334: pa_debug.write_file('Revenues : After fetch '||l_total_count);

330: l_row_count := l_total_count - l_prev_total_count ;
331: l_prev_total_count := l_total_count;
332:
333: IF g1_debug_mode = 'Y' THEN
334: pa_debug.write_file('Revenues : After fetch '||l_total_count);
335: END IF;
336:
337: if ( l_total_count = l_temp ) then
338: IF g1_debug_mode = 'Y' THEN

Line 339: pa_debug.write_file('REVENUE: Fetched Rows : '||to_char(l_total_count));

335: END IF;
336:
337: if ( l_total_count = l_temp ) then
338: IF g1_debug_mode = 'Y' THEN
339: pa_debug.write_file('REVENUE: Fetched Rows : '||to_char(l_total_count));
340: END IF;
341: l_temp := l_temp + 10000;
342: end if;
343:

Line 348: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);

344: if ( l_row_count = 0 ) then
345: exit;
346: end if;
347:
348: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);
349:
350: -- --pa_debug.write_file('Revenues : Before update of the statuses ');
351: /*
352: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST

Line 350: -- --pa_debug.write_file('Revenues : Before update of the statuses ');

346: end if;
347:
348: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);
349:
350: -- --pa_debug.write_file('Revenues : Before update of the statuses ');
351: /*
352: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
353: UPDATE pa_draft_revenues
354: SET ubr_uer_process_flag = 'S',

Line 390: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');

386: l_ubr_amount_arr(j),
387: l_uer_amount_arr(j)
388: );
389:
390: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');
391: process_ubr_uer_summary('DRAFT_REVENUES','UBR');
392: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
393: process_ubr_uer_summary('DRAFT_REVENUES','UER');
394:

Line 392: -- pa_debug.write_file('LEV2:UER Processing ----------------------');

388: );
389:
390: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');
391: process_ubr_uer_summary('DRAFT_REVENUES','UBR');
392: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
393: process_ubr_uer_summary('DRAFT_REVENUES','UER');
394:
395:
396: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');

Line 396: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');

392: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
393: process_ubr_uer_summary('DRAFT_REVENUES','UER');
394:
395:
396: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');
397:
398: l_sum_summary_id_arr.delete;
399: l_sum_project_id_arr.delete;
400: l_sum_cost_seg_arr.delete;

Line 421: -- pa_debug.write_file('LEV2:After Fetch '||l_sum_project_id_arr.count);

417: l_sum_uer_arr;
418:
419: CLOSE sum_cv;
420:
421: -- pa_debug.write_file('LEV2:After Fetch '||l_sum_project_id_arr.count);
422: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
423: UPDATE pa_ubr_uer_summ_acct
424: SET
425: UBR_BAL_PREV_PERIOD_DR =

Line 435: -- pa_debug.write_file('LEV2:After updating the higher gl date rows ');

431: AND cost_center_segment = l_sum_cost_seg_arr(J)
432: AND Account_segment = l_sum_acct_seg_arr(J)
433: AND gl_period_start_date > l_sum_gl_st_dt_arr(J);
434:
435: -- pa_debug.write_file('LEV2:After updating the higher gl date rows ');
436: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
437: UPDATE pa_ubr_uer_summ_acct upd1
438: SET ( upd1.UBR_BAL_PREV_PERIOD_DR, upd1.UER_BAL_PREV_PERIOD_CR ) =
439: ( select nvl(sum(sel1.UNBILLED_RECEIVABLE_DR),0),

Line 449: -- pa_debug.write_file('LEV2:After updating the previous balances ');

445: and sel1.gl_period_start_date < upd1.gl_period_start_date )
446: WHERE ubr_uer_summary_id = l_sum_summary_id_arr(J)
447: AND l_sum_proc_flag_arr(J) = 'I' ;
448:
449: -- pa_debug.write_file('LEV2:After updating the previous balances ');
450:
451: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
452: UPDATE pa_ubr_uer_summ_acct upd1
453: SET process_flag = 'P',

Line 461: -- pa_debug.write_file('LEV2:After Summary Processing ');

457: AND cost_center_segment = l_sum_cost_seg_arr(J)
458: AND Account_segment = l_sum_acct_seg_arr(J)
459: AND gl_period_start_date = l_sum_gl_st_dt_arr(J);
460:
461: -- pa_debug.write_file('LEV2:After Summary Processing ');
462:
463: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
464: UPDATE pa_draft_revenues_all dr1
465: SET ( dr1.request_id,dr1.ubr_uer_process_flag , dr1.ubr_summary_id ,dr1.uer_summary_id )

Line 473: -- pa_debug.write_file('LEV2:After Updating summary_id on pa_draft_revenue ');

469: and temp1.draft_rev_inv_num = dr1.draft_revenue_num )
470: WHERE dr1.project_id = l_project_id_arr(j)
471: and dr1.draft_revenue_num = l_draft_rev_num_arr(j);
472:
473: -- pa_debug.write_file('LEV2:After Updating summary_id on pa_draft_revenue ');
474:
475: -- Updating the zero_balance_flag.
476:
477: -- pa_debug.write_file('LEV2:Zero Balance Processing ');

Line 477: -- pa_debug.write_file('LEV2:Zero Balance Processing ');

473: -- pa_debug.write_file('LEV2:After Updating summary_id on pa_draft_revenue ');
474:
475: -- Updating the zero_balance_flag.
476:
477: -- pa_debug.write_file('LEV2:Zero Balance Processing ');
478: OPEN zero_cv;
479:
480: l_zer_project_id_arr.delete;
481: l_zer_gl_st_dt_arr.delete;

Line 489: -- pa_debug.write_file('LEV2:zero balance fetched '||to_char(l_zer_project_id_arr.count));

485: l_zer_project_id_arr,
486: l_zer_gl_st_dt_arr ,
487: l_zer_flag_arr ;
488:
489: -- pa_debug.write_file('LEV2:zero balance fetched '||to_char(l_zer_project_id_arr.count));
490: CLOSE zero_cv;
491:
492: if ( l_zer_project_id_arr.count > 0 ) then
493: FORALL j IN l_zer_project_id_arr.FIRST..l_zer_project_id_arr.LAST

Line 661: -- pa_debug.write_file('*START DI PROCESSING**');

657: -- order by di.project_id;
658:
659: begin
660:
661: -- pa_debug.write_file('*******START DI PROCESSING********');
662: OPEN di_cv;
663:
664: -- pa_debug.write_file('After Open');
665:

Line 664: -- pa_debug.write_file('After Open');

660:
661: -- pa_debug.write_file('*******START DI PROCESSING********');
662: OPEN di_cv;
663:
664: -- pa_debug.write_file('After Open');
665:
666: LOOP
667: -- pa_debug.write_file('Before fetch of draft revenues ');
668: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');

Line 667: -- pa_debug.write_file('Before fetch of draft revenues ');

663:
664: -- pa_debug.write_file('After Open');
665:
666: LOOP
667: -- pa_debug.write_file('Before fetch of draft revenues ');
668: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');
669:
670: l_project_id_arr.delete;
671: l_draft_inv_num_arr.delete;

Line 668: -- pa_debug.write_file('LEV2:*Start of the Batch***');

664: -- pa_debug.write_file('After Open');
665:
666: LOOP
667: -- pa_debug.write_file('Before fetch of draft revenues ');
668: -- pa_debug.write_file('LEV2:*******Start of the Batch*********');
669:
670: l_project_id_arr.delete;
671: l_draft_inv_num_arr.delete;
672: l_ubr_acct_seg_arr.delete;

Line 698: pa_debug.write_file('Invoice : After fetch '||l_total_count);

694: l_row_count := l_total_count - l_prev_total_count ;
695: l_prev_total_count := l_total_count;
696:
697: IF g1_debug_mode = 'Y' THEN
698: pa_debug.write_file('Invoice : After fetch '||l_total_count);
699: END IF;
700:
701: if ( l_total_count = l_temp ) then
702: IF g1_debug_mode = 'Y' THEN

Line 703: pa_debug.write_file('INVOICE: Fetched Rows : '||to_char(l_total_count));

699: END IF;
700:
701: if ( l_total_count = l_temp ) then
702: IF g1_debug_mode = 'Y' THEN
703: pa_debug.write_file('INVOICE: Fetched Rows : '||to_char(l_total_count));
704: END IF;
705: l_temp := l_temp + 10000;
706: end if;
707:

Line 712: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);

708: if ( l_row_count = 0 ) then
709: exit;
710: end if;
711:
712: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);
713:
714: -- --pa_debug.write_file('Revenues : Before update of the statuses ');
715:
716: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST

Line 714: -- --pa_debug.write_file('Revenues : Before update of the statuses ');

710: end if;
711:
712: -- pa_debug.write_file('LEV2:Before For Loop '||l_project_id_arr.count);
713:
714: -- --pa_debug.write_file('Revenues : Before update of the statuses ');
715:
716: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
717: INSERT INTO pa_draft_rev_inv_temp
718: (

Line 746: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');

742: l_ubr_amount_arr(j),
743: l_uer_amount_arr(j)
744: );
745:
746: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');
747: process_ubr_uer_summary('DRAFT_REVENUES','UBR');
748: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
749: process_ubr_uer_summary('DRAFT_REVENUES','UER');
750:

Line 748: -- pa_debug.write_file('LEV2:UER Processing ----------------------');

744: );
745:
746: -- pa_debug.write_file('LEV2:UBR Processing ----------------------');
747: process_ubr_uer_summary('DRAFT_REVENUES','UBR');
748: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
749: process_ubr_uer_summary('DRAFT_REVENUES','UER');
750:
751:
752: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');

Line 752: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');

748: -- pa_debug.write_file('LEV2:UER Processing ----------------------');
749: process_ubr_uer_summary('DRAFT_REVENUES','UER');
750:
751:
752: -- pa_debug.write_file('LEV2:Summary Processing ----------------------');
753:
754: l_sum_project_id_arr.delete;
755: l_sum_cost_seg_arr.delete;
756: l_sum_acct_seg_arr.delete;

Line 776: -- pa_debug.write_file('LEV2:After Fetch '||l_sum_project_id_arr.count);

772: l_sum_uer_arr;
773:
774: CLOSE sum_cv;
775:
776: -- pa_debug.write_file('LEV2:After Fetch '||l_sum_project_id_arr.count);
777: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
778: UPDATE pa_ubr_uer_summ_acct
779: SET
780: UBR_BAL_PREV_PERIOD_DR =

Line 789: -- pa_debug.write_file('LEV2:After updating the higher gl date rows ');

785: AND cost_center_segment = l_sum_cost_seg_arr(J)
786: AND Account_segment = l_sum_acct_seg_arr(J)
787: AND gl_period_start_date > l_sum_gl_st_dt_arr(J);
788:
789: -- pa_debug.write_file('LEV2:After updating the higher gl date rows ');
790: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
791: UPDATE pa_ubr_uer_summ_acct upd1
792: SET ( upd1.UBR_BAL_PREV_PERIOD_DR, upd1.UER_BAL_PREV_PERIOD_CR ) =
793: ( select nvl(sum(sel1.UNBILLED_RECEIVABLE_DR),0),nvl(sum(sel1.UNEARNED_REVENUE_CR),0)

Line 802: -- pa_debug.write_file('LEV2:After updating the previous balances ');

798: and sel1.gl_period_start_date < upd1.gl_period_start_date )
799: WHERE ubr_uer_summary_id = l_sum_summary_id_arr(J)
800: AND l_sum_proc_flag_arr(J) = 'I' ;
801:
802: -- pa_debug.write_file('LEV2:After updating the previous balances ');
803:
804: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
805: UPDATE pa_ubr_uer_summ_acct upd1
806: SET process_flag = 'P',

Line 815: -- pa_debug.write_file('LEV2:After Summary Processing ');

811: AND Account_segment = l_sum_acct_seg_arr(J)
812: AND gl_period_start_date = l_sum_gl_st_dt_arr(J);
813:
814:
815: -- pa_debug.write_file('LEV2:After Summary Processing ');
816:
817: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
818: UPDATE pa_draft_invoices_all di1
819: SET ( di1.request_id,di1.ubr_uer_process_flag , di1.ubr_summary_id ,di1.uer_summary_id )

Line 827: -- pa_debug.write_file('LEV2:After Updating summary_id on pa_draft_invoices ');

823: and temp1.draft_rev_inv_num = di1.draft_invoice_num )
824: WHERE di1.project_id = l_project_id_arr(j)
825: and di1.draft_invoice_num = l_draft_inv_num_arr(j);
826:
827: -- pa_debug.write_file('LEV2:After Updating summary_id on pa_draft_invoices ');
828:
829:
830: --
831:

Line 832: -- pa_debug.write_file('LEV2:Zero Balance Processing ');

828:
829:
830: --
831:
832: -- pa_debug.write_file('LEV2:Zero Balance Processing ');
833: OPEN zero_cv;
834:
835: l_zer_project_id_arr.delete;
836: l_zer_gl_st_dt_arr.delete;

Line 844: -- pa_debug.write_file('LEV2:zero balance fetched '||to_char(l_zer_project_id_arr.count));

840: l_zer_project_id_arr,
841: l_zer_gl_st_dt_arr ,
842: l_zer_flag_arr ;
843:
844: -- pa_debug.write_file('LEV2:zero balance fetched '||to_char(l_zer_project_id_arr.count));
845: CLOSE zero_cv;
846:
847: if ( l_zer_project_id_arr.count > 0 ) then
848: FORALL j IN l_zer_project_id_arr.FIRST..l_zer_project_id_arr.LAST

Line 937: -- pa_debug.write_file('START OF PROCEDURE ');

933:
934:
935: begin
936:
937: -- pa_debug.write_file('START OF PROCEDURE ');
938:
939: l_acct_seg_arr.delete;
940: l_cost_seg_arr.delete;
941: l_gl_period_arr.delete;

Line 947: -- pa_debug.write_file('Before summary fetch ');

943: l_sum_amt_arr.delete;
944: l_process_ubr_uer_arr.delete;
945:
946:
947: -- pa_debug.write_file('Before summary fetch ');
948:
949: OPEN sum_cv;
950:
951: FETCH sum_cv

Line 961: -- pa_debug.write_file('LEV2:after sumary fetch '||sum_cv%rowcount);

957: l_process_ubr_uer_arr,
958: l_sum_project_id_arr,
959: l_sum_amt_arr ;
960:
961: -- pa_debug.write_file('LEV2:after sumary fetch '||sum_cv%rowcount);
962: CLOSE sum_cv;
963:
964:
965: -- pa_debug.write_file('after close ');

Line 965: -- pa_debug.write_file('after close ');

961: -- pa_debug.write_file('LEV2:after sumary fetch '||sum_cv%rowcount);
962: CLOSE sum_cv;
963:
964:
965: -- pa_debug.write_file('after close ');
966:
967:
968: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
969: UPDATE pa_ubr_uer_summ_acct

Line 1025: -- pa_debug.write_file('LEV2:Rows Updated in summary table '||to_char(l_upd_project_id_arr.count));

1021: l_upd_acct_seg_arr ,
1022: l_upd_cost_seg_arr ,
1023: l_upd_gl_per_stdt_arr ;
1024:
1025: -- pa_debug.write_file('LEV2:Rows Updated in summary table '||to_char(l_upd_project_id_arr.count));
1026:
1027: ins_j := 0;
1028:
1029: FOR i in l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST LOOP

Line 1063: -- pa_debug.write_file('LEV2:Rows Inserted in summary table '||to_char(ins_j));

1059: l_sum_project_id_arr.delete;
1060: l_sum_amt_arr.delete;
1061: l_process_ubr_uer_arr.delete;
1062:
1063: -- pa_debug.write_file('LEV2:Rows Inserted in summary table '||to_char(ins_j));
1064:
1065:
1066: if ( l_ins_sum_project_id_arr.count > 0 ) then
1067: FORALL j IN l_ins_sum_project_id_arr.FIRST..l_ins_sum_project_id_arr.LAST

Line 1122: -- pa_debug.write_file('LEV2:After insert into summary table ');

1118: 'UER',l_ins_sum_amt_arr(J),
1119: 'UBR', 0, 0 )
1120: );
1121:
1122: -- pa_debug.write_file('LEV2:After insert into summary table ');
1123: end if;
1124:
1125:
1126: if ( l_upd_project_id_arr.count > 0 ) then

Line 1146: -- pa_debug.write_file('LEV2:After update of summary_id for updated rows ');

1142: AND uer_cost_center_segment = l_upd_cost_seg_arr(J)
1143: AND uer_account_segment = l_upd_acct_seg_arr(J)
1144: AND gl_period_start_date = l_upd_gl_per_stdt_arr(J);
1145: end if;
1146: -- pa_debug.write_file('LEV2:After update of summary_id for updated rows ');
1147: end if;
1148:
1149: if ( l_ins_sum_project_id_arr.count > 0 ) then
1150:

Line 1173: -- pa_debug.write_file('LEV2:After update of summary_id for inserted rows ');

1169: AND uer_account_segment = l_ins_acct_seg_arr(J)
1170: AND gl_period_start_date = l_ins_gl_per_stdt_arr(J);
1171: end if;
1172:
1173: -- pa_debug.write_file('LEV2:After update of summary_id for inserted rows ');
1174:
1175: -- Update for Multi- Cost Center projects.
1176:
1177: FORALL j IN l_ins_sum_project_id_arr.FIRST..l_ins_sum_project_id_arr.LAST

Line 1189: -- pa_debug.write_file('LEV2:After update of the multi cost center flag ' );

1185: where sum2.project_id = sum1.project_id
1186: and sum2.gl_period_name = sum1.gl_period_name
1187: and sum2.cost_center_segment <> l_ins_cost_seg_arr(J) );
1188:
1189: -- pa_debug.write_file('LEV2:After update of the multi cost center flag ' );
1190:
1191: end if;
1192:
1193: