APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_DRAFT_REV_INV_TEMP

Line 210: from pa_draft_rev_inv_temp temp1 )

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

Line 361: INSERT INTO pa_draft_rev_inv_temp

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

Line 467: from pa_draft_rev_inv_temp temp1

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

Line 560: from pa_draft_rev_inv_temp temp1 )

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

Line 717: INSERT INTO pa_draft_rev_inv_temp

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: (
719: project_id ,
720: draft_rev_inv_num,
721: ubr_account_segment,

Line 821: from pa_draft_rev_inv_temp temp1

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

Line 920: from pa_draft_rev_inv_temp

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

Line 1131: UPDATE pa_draft_rev_inv_temp

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

Line 1139: UPDATE pa_draft_rev_inv_temp

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

Line 1155: UPDATE pa_draft_rev_inv_temp

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

Line 1164: UPDATE pa_draft_rev_inv_temp

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