[Home] [Help]
2854: from pa_expenditure_items_all ei
2855: where ei.transferred_from_exp_item_id = l_exp_item_id_tab(exp_ind)
2856: and ei.transferred_from_exp_item_id is not null
2857: and not exists ( select pp.project_id
2858: from pa_purge_projects pp
2859: where pp.project_id = ei.project_id
2860: and pp.purge_batch_id = p_purge_batch_id ) ;
2861:
2862: FORALL exp_ind IN l_exp_item_id_tab.FIRST .. l_exp_item_id_tab.LAST
2864: set ei.transferred_from_exp_item_id = NULL
2865: where ei.transferred_from_exp_item_id = l_exp_item_id_tab(exp_ind)
2866: and ei.transferred_from_exp_item_id is not null
2867: and not exists ( select pp.project_id
2868: from pa_purge_projects pp
2869: where pp.project_id = ei.project_id
2870: and pp.purge_batch_id = p_purge_batch_id ) ;
2871:
2872: /* Each time thru the loop need to make sure that reset the
3013: and ei1.project_id = p_project_id )
3014: and ei.transferred_from_exp_item_id is not null
3015: and rownum < l_commit_size
3016: and not exists ( select pp.project_id
3017: from pa_purge_projects pp
3018: where pp.project_id = ei.project_id
3019: and pp.purge_batch_id = p_purge_batch_id ) ;
3020: else
3021: insert into Pa_Expend_item_Adj_Activities
3049: and ei.task_id = t.task_id
3050: and ei.transferred_from_exp_item_id is not null
3051: and rownum < l_commit_size
3052: and not exists ( select pp.project_id
3053: from pa_purge_projects pp
3054: where pp.project_id = t.project_id
3055: and pp.purge_batch_id = p_purge_batch_id ) ;
3056: end if;
3057:
3630: and ei1.transferred_from_exp_item_id is not null
3631: and ei1.project_id = p_project_id )
3632: and rownum < l_commit_size */
3633: and not exists ( select pp.project_id
3634: from pa_purge_projects pp
3635: where pp.project_id = ei.project_id
3636: and pp.purge_batch_id = p_purge_batch_id );
3637: /* else */
3638: /* end if; */