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 32: pa_debug.write_file('Create_Ubr_Uer_Summary_Balance: ' || 'START org id '||to_char(org_rec.org_id));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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