APPS.GMS_GROUP_REVERSAL_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 23: from pa_expenditure_items_all e1

19: e1.last_updated_by ,
20: e1.last_update_login ,
21: e1.adjusted_expenditure_item_id
22:
23: from pa_expenditure_items_all e1
24: ,pa_expenditures_all e2
25:
26: where e2.expenditure_group = x_reverse_group
27: and e2.expenditure_id = e1.expenditure_id ;

Line 83: -- and origional item. If a duplicate record is found in ADL table then this expenditure item is deleted from pa_expenditure_items_all

79: x_quantity NUMBER ;
80:
81: -- This cursor verifies whether any duplicate records are there in gms_award_distributions table before copying the items by
82: -- comparing the exp_type,task_id and quantity of origional and new items. This is done as there is no link between the new
83: -- and origional item. If a duplicate record is found in ADL table then this expenditure item is deleted from pa_expenditure_items_all
84: -- table otherwise adl is created .
85:
86: CURSOR NEW_ITEMS (x_new_group VARCHAR2 ) IS
87: select e1.expenditure_item_id,

Line 98: from pa_expenditure_items_all e1

94: e1.last_update_date ,
95: e1.last_updated_by ,
96: e1.last_update_login
97:
98: from pa_expenditure_items_all e1
99: ,pa_expenditures_all e2
100:
101: where e2.expenditure_group = x_new_group
102: and e2.expenditure_id = e1.expenditure_id

Line 123: from pa_expenditure_items_all e1

119: e1.last_update_date ,
120: e1.last_updated_by ,
121: e1.last_update_login
122:
123: from pa_expenditure_items_all e1
124: ,pa_expenditures_all e2
125: ,pa_expenditure_groups_all e3
126: where e3.expenditure_group = x_org_group
127: and e3.expenditure_group = e2.expenditure_group

Line 188: DELETE from pa_expenditure_items_all

184: gms_awards_dist_pkg.create_adls(x_adl_rec);
185:
186: ELSE
187:
188: DELETE from pa_expenditure_items_all
189: WHERE expenditure_item_id = new_rec.expenditure_item_id ;
190:
191: END IF ;
192: END LOOP;

Line 214: -- and origional item. If a duplicate record is found in ADL table then this expenditure item is deleted from pa_expenditure_items_all

210: x_amount NUMBER ;
211:
212: -- This cursor verifies whether any duplicate records are there in gms_award_distributions table before copying the items by
213: -- comparing the exp_type,task_id and quantity of origional and new items. This is done as there is no link between the new
214: -- and origional item. If a duplicate record is found in ADL table then this expenditure item is deleted from pa_expenditure_items_all
215: -- table otherwise adl is created .
216:
217: CURSOR NEW_ITEMS (x_new_group VARCHAR2 ) IS
218: select e1.encumbrance_item_id,