DBA Data[Home] [Help]

APPS.AP_WEB_AME_PKG dependencies on GMS_AWARDS

Line 509: l_award_number GMS_AWARDS.AWARD_NUMBER%type;

505: FUNCTION GetAwardNumber(
506: p_award_id IN NUMBER
507: ) RETURN VARCHAR2 IS
508: -------------------------------------------------------------------
509: l_award_number GMS_AWARDS.AWARD_NUMBER%type;
510: BEGIN
511:
512: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
513:

Line 516: from GMS_AWARDS_ALL

512: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
513:
514: select award_number
515: into l_award_number
516: from GMS_AWARDS_ALL
517: where award_id = p_award_id;
518:
519: RETURN l_award_number;
520:

Line 669: l_award_number gms_awards.award_number%type;

665:
666: l_project_number pa_projects_all.segment1%type;
667: l_project_name pa_projects_all.name%type;
668:
669: l_award_number gms_awards.award_number%type;
670:
671: l_item_class ame_item_classes.name%type;
672: l_item_id ame_temp_old_approver_lists.item_id%type;
673: