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_UBR_UER_SUMM_ACCT

Line 193: from pa_ubr_uer_summ_acct

189: gl_period_start_date,
190: process_flag,
191: delta_ubr,
192: delta_uer
193: from pa_ubr_uer_summ_acct
194: where request_id = G_p_request_id
195: and process_flag in ('I','U');
196:
197: CURSOR zero_cv IS

Line 207: from pa_ubr_uer_summ_acct sel1

203: (UBR_BAL_PREV_PERIOD_DR+UNBILLED_RECEIVABLE_DR) -
204: (UER_BAL_PREV_PERIOD_CR + UNEARNED_REVENUE_CR) )),
205: 0, decode(zero_balance_flag,'N','Y','X'),
206: decode(zero_balance_flag,'Y','N','X')) zero_bal_flag
207: from pa_ubr_uer_summ_acct sel1
208: where sel1.project_id in
209: ( select distinct temp1.project_id
210: from pa_draft_rev_inv_temp temp1 )
211: group by

Line 423: UPDATE pa_ubr_uer_summ_acct

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 =
426: nvl(UBR_BAL_PREV_PERIOD_DR,0) + l_sum_ubr_arr(J),
427: UER_BAL_PREV_PERIOD_CR =

Line 437: UPDATE pa_ubr_uer_summ_acct upd1

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),
440: nvl(sum(sel1.UNEARNED_REVENUE_CR),0)
441: from pa_ubr_uer_summ_acct sel1

Line 441: from pa_ubr_uer_summ_acct sel1

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),
440: nvl(sum(sel1.UNEARNED_REVENUE_CR),0)
441: from pa_ubr_uer_summ_acct sel1
442: where sel1.project_id = upd1.project_id
443: and sel1.account_segment = upd1.account_segment
444: and sel1.cost_center_segment = upd1.cost_center_segment
445: and sel1.gl_period_start_date < upd1.gl_period_start_date )

Line 452: UPDATE pa_ubr_uer_summ_acct upd1

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',
454: delta_ubr = 0,
455: delta_uer = 0
456: WHERE project_id = l_sum_project_id_arr(J)

Line 494: UPDATE pa_ubr_uer_summ_acct

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
494: UPDATE pa_ubr_uer_summ_acct
495: SET zero_balance_flag = l_zer_flag_arr(J)
496: WHERE project_id = l_zer_project_id_arr(J)
497: and gl_period_start_date = l_zer_gl_st_dt_arr(J)
498: and l_zer_flag_arr(J) <> 'X';

Line 557: from pa_ubr_uer_summ_acct sel1

553: (UBR_BAL_PREV_PERIOD_DR+UNBILLED_RECEIVABLE_DR) -
554: (UER_BAL_PREV_PERIOD_CR + UNEARNED_REVENUE_CR) )),
555: 0, decode(zero_balance_flag,'N','Y','X'),
556: decode(zero_balance_flag,'Y','N','X')) zero_bal_flag
557: from pa_ubr_uer_summ_acct sel1
558: where sel1.project_id in
559: ( select distinct temp1.project_id
560: from pa_draft_rev_inv_temp temp1 )
561: group by

Line 584: from pa_ubr_uer_summ_acct

580: gl_period_start_date,
581: process_flag,
582: delta_ubr,
583: delta_uer
584: from pa_ubr_uer_summ_acct
585: where request_id = G_p_request_id
586: and process_flag in ('I','U');
587:
588: CURSOR di_cv IS

Line 778: UPDATE pa_ubr_uer_summ_acct

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 =
781: nvl(UBR_BAL_PREV_PERIOD_DR,0) + l_sum_ubr_arr(J),
782: UER_BAL_PREV_PERIOD_CR =

Line 791: UPDATE pa_ubr_uer_summ_acct upd1

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)
794: from pa_ubr_uer_summ_acct sel1
795: where sel1.project_id = upd1.project_id

Line 794: from pa_ubr_uer_summ_acct sel1

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)
794: from pa_ubr_uer_summ_acct sel1
795: where sel1.project_id = upd1.project_id
796: and sel1.account_segment = upd1.account_segment
797: and sel1.cost_center_segment = upd1.cost_center_segment
798: and sel1.gl_period_start_date < upd1.gl_period_start_date )

Line 805: UPDATE pa_ubr_uer_summ_acct upd1

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',
807: delta_ubr = 0,
808: delta_uer = 0
809: WHERE project_id = l_sum_project_id_arr(J)

Line 849: UPDATE pa_ubr_uer_summ_acct

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
849: UPDATE pa_ubr_uer_summ_acct
850: SET zero_balance_flag = l_zer_flag_arr(J)
851: WHERE project_id = l_zer_project_id_arr(J)
852: and gl_period_start_date = l_zer_gl_st_dt_arr(J)
853: and l_zer_flag_arr(J) <> 'X';

Line 969: UPDATE pa_ubr_uer_summ_acct

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
970: SET
971: unbilled_receivable_dr =
972: decode(l_process_ubr_uer_arr(j),
973: 'UBR',unbilled_receivable_dr + l_sum_amt_arr(j),

Line 1045: select pa_ubr_uer_summ_acct_s.nextval

1041: l_ins_sum_amt_arr(ins_j) := l_sum_amt_arr(i);
1042: l_ins_process_ubr_uer_arr(ins_j) := l_process_ubr_uer_arr(i);
1043: l_ins_gl_per_stdt_arr(ins_j) := l_gl_period_start_date_arr(i);
1044:
1045: select pa_ubr_uer_summ_acct_s.nextval
1046: into l_ins_summary_id_arr(ins_j)
1047: from dual;
1048:
1049: l_ins_ins_upd_flag_arr(ins_j) := 'I';

Line 1068: INSERT INTO pa_ubr_uer_summ_acct

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
1068: INSERT INTO pa_ubr_uer_summ_acct
1069: ( ubr_uer_summary_id ,
1070: Account_segment ,
1071: cost_center_segment ,
1072: project_id ,

Line 1178: UPDATE pa_ubr_uer_summ_acct sum1

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
1178: UPDATE pa_ubr_uer_summ_acct sum1
1179: set multi_cost_center_flag = 'Y'
1180: where project_id = l_ins_sum_project_id_arr(J)
1181: and gl_period_name = l_ins_gl_period_arr(J)
1182: and multi_cost_center_flag = 'N'

Line 1184: from pa_ubr_uer_summ_acct sum2

1180: where project_id = l_ins_sum_project_id_arr(J)
1181: and gl_period_name = l_ins_gl_period_arr(J)
1182: and multi_cost_center_flag = 'N'
1183: and EXISTS ( select 'x'
1184: from pa_ubr_uer_summ_acct sum2
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: