[Home] [Help]
511: FUNCTION GetAwardNumber(
512: p_award_id IN NUMBER
513: ) RETURN VARCHAR2 IS
514: -------------------------------------------------------------------
515: l_award_number GMS_AWARDS.AWARD_NUMBER%type;
516: BEGIN
517:
518: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
519:
518: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AME_PKG', 'Start GetAwardNumber');
519:
520: select award_number
521: into l_award_number
522: from GMS_AWARDS_ALL
523: where award_id = p_award_id;
524:
525: RETURN l_award_number;
526:
671:
672: l_project_number pa_projects_all.segment1%type;
673: l_project_name pa_projects_all.name%type;
674:
675: l_award_number gms_awards.award_number%type;
676:
677: l_item_class ame_item_classes.name%type;
678: l_item_id ame_temp_old_approver_lists.item_id%type;
679: