[Home] [Help]
17: -- ===================================================================================================
18: -- This cursor verifies whether any duplicate records are there in gms_award_distributions table
19: -- before copying the items by comparing the exp_type,task_id and quantity of origional and new items.
20: -- This is done as there is no link between the new and origional item. If a duplicate record is
21: -- found in ADL table then this expenditure item is deleted from pa_expenditure_items_all
22: -- table otherwise adl is created .
23: -- ===================================================================================================
24:
25: CURSOR NEW_ITEMS (x_new_group VARCHAR2 ) IS
32: e1.created_by ,
33: e1.last_update_date ,
34: e1.last_updated_by ,
35: e1.last_update_login
36: from pa_expenditure_items_all e1
37: ,pa_expenditures_all e2
38:
39: where e2.expenditure_group = x_new_group
40: and e2.expenditure_id = e1.expenditure_id
60: e1.last_update_date ,
61: e1.last_updated_by ,
62: e1.last_update_login
63:
64: from pa_expenditure_items_all e1
65: ,pa_expenditures_all e2
66: ,pa_expenditure_groups_all e3
67: where e3.expenditure_group = x_org_group
68: and e3.expenditure_group = e2.expenditure_group
140: END IF ; -- if for IF GMS_PA_API.IS_SPONSORED_PROJECT(x_project_id ) Check
141:
142: ELSE
143:
144: DELETE from pa_expenditure_items_all
145: WHERE expenditure_item_id = new_rec.expenditure_item_id ;
146:
147: END IF ; -- End if for IF NEW_ITEMS%FOUND check
148:
172: e1.last_updated_by ,
173: e1.last_update_login ,
174: e1.adjusted_expenditure_item_id
175:
176: from pa_expenditure_items_all e1
177: ,pa_expenditures_all e2
178:
179: where e2.expenditure_group = x_reverse_group
180: and e2.expenditure_id = e1.expenditure_id ;