APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_DRAFT_REV_INV_TEMP

Line 208: from pa_draft_rev_inv_temp temp1 )

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
210: sel1.project_id,
211: sel1.gl_period_start_date ,
212: sel1.zero_balance_flag

Line 359: INSERT INTO pa_draft_rev_inv_temp

355: and draft_revenue_num = l_draft_rev_num_arr(j);
356: */
357:
358: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
359: INSERT INTO pa_draft_rev_inv_temp
360: (
361: project_id ,
362: draft_rev_inv_num,
363: ubr_account_segment,

Line 465: from pa_draft_rev_inv_temp temp1

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 )
464: = ( select G_p_request_id,'Y',temp1.ubr_summary_id, temp1.uer_summary_id
465: from pa_draft_rev_inv_temp temp1
466: where temp1.project_id = dr1.project_id
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);

Line 558: from pa_draft_rev_inv_temp temp1 )

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
560: sel1.project_id,
561: sel1.gl_period_start_date ,
562: sel1.zero_balance_flag

Line 715: INSERT INTO pa_draft_rev_inv_temp

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: (
717: project_id ,
718: draft_rev_inv_num,
719: ubr_account_segment,

Line 819: from pa_draft_rev_inv_temp temp1

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 )
818: = ( select G_p_request_id,'Y',temp1.ubr_summary_id, temp1.uer_summary_id
819: from pa_draft_rev_inv_temp temp1
820: where temp1.project_id = di1.project_id
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);

Line 918: from pa_draft_rev_inv_temp

914: project_id,
915: decode(p_process_ubr_uer,
916: 'UBR',sum(unbilled_receivable_dr),
917: 'UER',sum(unearned_revenue_cr),-1)
918: from pa_draft_rev_inv_temp
919: group by
920: decode(p_process_ubr_uer,
921: 'UBR',ubr_account_segment,
922: 'UER',uer_account_segment,

Line 1129: UPDATE pa_draft_rev_inv_temp

1125:
1126: -- Update the summary_id
1127: if ( p_process_ubr_uer = 'UBR' ) then
1128: FORALL j IN l_upd_project_id_arr.FIRST..l_upd_project_id_arr.LAST
1129: UPDATE pa_draft_rev_inv_temp
1130: SET ubr_summary_id = l_upd_summary_id_arr(J)
1131: where project_id = l_upd_project_id_arr(J)
1132: AND ubr_cost_center_segment = l_upd_cost_seg_arr(J)
1133: AND ubr_account_segment = l_upd_acct_seg_arr(J)

Line 1137: UPDATE pa_draft_rev_inv_temp

1133: AND ubr_account_segment = l_upd_acct_seg_arr(J)
1134: AND gl_period_start_date = l_upd_gl_per_stdt_arr(J);
1135: else
1136: FORALL j IN l_upd_project_id_arr.FIRST..l_upd_project_id_arr.LAST
1137: UPDATE pa_draft_rev_inv_temp
1138: SET uer_summary_id = l_upd_summary_id_arr(J)
1139: where project_id = l_upd_project_id_arr(J)
1140: AND uer_cost_center_segment = l_upd_cost_seg_arr(J)
1141: AND uer_account_segment = l_upd_acct_seg_arr(J)

Line 1153: UPDATE pa_draft_rev_inv_temp

1149: -- Update the insert_update_flag
1150:
1151: if ( p_process_ubr_uer = 'UBR' ) then
1152: FORALL j IN l_ins_sum_project_id_arr.FIRST..l_ins_sum_project_id_arr.LAST
1153: UPDATE pa_draft_rev_inv_temp
1154: SET insert_update_flag = l_ins_ins_upd_flag_arr(J),
1155: ubr_summary_id = l_ins_summary_id_arr(J)
1156: where project_id = l_ins_sum_project_id_arr(J)
1157: AND ubr_cost_center_segment = l_ins_cost_seg_arr(J)

Line 1162: UPDATE pa_draft_rev_inv_temp

1158: AND ubr_account_segment = l_ins_acct_seg_arr(J)
1159: AND gl_period_start_date = l_ins_gl_per_stdt_arr(J);
1160: else
1161: FORALL j IN l_ins_sum_project_id_arr.FIRST..l_ins_sum_project_id_arr.LAST
1162: UPDATE pa_draft_rev_inv_temp
1163: SET insert_update_flag = l_ins_ins_upd_flag_arr(J),
1164: uer_summary_id = l_ins_summary_id_arr(J)
1165: where project_id = l_ins_sum_project_id_arr(J)
1166: AND uer_cost_center_segment = l_ins_cost_seg_arr(J)