APPS.GMS_PA_XFACE dependencies on GMS_AWARD_DISTRIBUTIONS

Line 67: adl_rec gms_award_distributions%ROWTYPE;

63: -- This will insert a reversed expendtiure_item record and two new expenditure_items records into ADL table.
64: -- =========================================================================================================
65: PROCEDURE GMS_SPLIT (x_expenditure_item_id IN NUMBER ) IS
66:
67: adl_rec gms_award_distributions%ROWTYPE;
68: x_flag varchar2(1);
69: CURSOR rev_item(x_expenditure_item_id NUMBER ) IS
70: SELECT * from pa_expenditure_items_all
71: WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;

Line 82: select award_id , bill_hold_flag into source_award_id ,x_flag from gms_award_distributions adl

78:
79: FOR rev_rec IN rev_item(x_expenditure_item_id) LOOP
80:
81: begin
82: select award_id , bill_hold_flag into source_award_id ,x_flag from gms_award_distributions adl
83: where adl.expenditure_item_id = x_expenditure_item_id
84: and adl.document_type = 'EXP' ;
85: exception
86: when too_many_rows then

Line 291: adl_rec gms_award_distributions%ROWTYPE;

287:
288: PROCEDURE GMS_ADJUST_ITEMS (X_CALLING_PROCESS IN VARCHAR2,
289: X_ROWS IN NUMBER ) IS
290:
291: adl_rec gms_award_distributions%ROWTYPE;
292: x_exp_item_id NUMBER;
293: x_new_item_id NUMBER;
294: x_flag varchar2(1) ;
295: CURSOR rev_item(x_exp_item_id NUMBER ) IS

Line 312: select bill_hold_flag, award_id into x_flag, source_award_id from gms_award_distributions

308:
309: x_exp_item_id := PA_TRANSACTIONS.TfrEiTab(i);
310:
311: begin
312: select bill_hold_flag, award_id into x_flag, source_award_id from gms_award_distributions
313: where expenditure_item_id = x_exp_item_id
314: and award_id = source_award_id
315: and document_type = 'EXP' ;
316: exception