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 191: from pa_ubr_uer_summ_acct

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

Line 205: from pa_ubr_uer_summ_acct sel1

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

Line 421: UPDATE pa_ubr_uer_summ_acct

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

Line 435: UPDATE pa_ubr_uer_summ_acct upd1

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

Line 439: from pa_ubr_uer_summ_acct sel1

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

Line 450: UPDATE pa_ubr_uer_summ_acct upd1

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

Line 492: UPDATE pa_ubr_uer_summ_acct

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

Line 555: from pa_ubr_uer_summ_acct sel1

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

Line 582: from pa_ubr_uer_summ_acct

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

Line 776: UPDATE pa_ubr_uer_summ_acct

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

Line 789: UPDATE pa_ubr_uer_summ_acct upd1

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

Line 792: from pa_ubr_uer_summ_acct sel1

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

Line 803: UPDATE pa_ubr_uer_summ_acct upd1

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

Line 847: UPDATE pa_ubr_uer_summ_acct

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

Line 967: UPDATE pa_ubr_uer_summ_acct

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

Line 1043: select pa_ubr_uer_summ_acct_s.nextval

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

Line 1066: INSERT INTO pa_ubr_uer_summ_acct

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

Line 1176: UPDATE pa_ubr_uer_summ_acct sum1

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

Line 1182: from pa_ubr_uer_summ_acct sum2

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