DBA Data[Home] [Help]

APPS.GMS_AP_API2 dependencies on GMS_AWARDS_DIST_PKG

Line 246: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID

242: A.creation_date CREATION_DATE,
243: A.last_updated_by LAST_UPDATED_BY,
244: A.created_by CREATED_BY,
245: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
246: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
247: FROM ap_invoice_distributions_all A,
248: GMS_AWARD_DISTRIBUTIONS ADL
249: WHERE a.invoice_id = p_invoice_id
250: AND adl.award_set_id = a.award_id

Line 266: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID

262: A.creation_date CREATION_DATE,
263: A.last_updated_by LAST_UPDATED_BY,
264: a.CREATED_BY CREATED_BY,
265: NVL(a.LAST_UPDATE_LOGIN,0) LAST_UPDATE_LOGIN,
266: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
267: FROM ap_self_assessed_tax_dist_all A,
268: GMS_AWARD_DISTRIBUTIONS ADL
269: WHERE a.invoice_id = p_invoice_id
270: AND ADL.AWARD_SET_ID = a.AWARD_ID

Line 381: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID

377: A.creation_date CREATION_DATE,
378: A.last_updated_by LAST_UPDATED_BY,
379: A.created_by CREATED_BY,
380: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
381: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
382: BULK COLLECT INTO l_invoice_id,
383: l_distribution_line_number,
384: l_invoice_distribution_id,
385: l_project_id ,

Line 612: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;

608: l_creation_date(l_count) := ap_rec.creation_date;
609: l_last_updated_by(l_count) := ap_rec.last_updated_by;
610: l_created_by(l_count) := NVL(ap_rec.created_by,0);
611: l_last_update_login(l_count) := ap_rec.last_update_login;
612: l_new_award_set_id(l_count) := gms_awards_dist_pkg.get_award_set_id ;
613:
614: END IF ;
615:
616: END LOOP ;