APPS.GMS_PO_API2_GRP dependencies on GMS_AWARDS_ALL

Line 578: -- Logic : get the award number from the adl and gms_awards_all..

574: -- Pre Reqs : None
575: -- Function : This API is for deriving the award number for the award_set_id
576: -- passed to the api. This is used in PO Fundscheck code to
577: -- populate reference column in gl bc packet with award number.
578: -- Logic : get the award number from the adl and gms_awards_all..
579: -- Calling API : PO funds check code PL/SQL Version.
580: -- Parameters :
581: -- : Standard parameters
582: -- p_api_version, p_commit, p_init_msg_list,

Line 608: l_award_number gms_awards_all.award_number%TYPE ;

604: l_msg_data varchar2(2000) ;
605: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
606: l_api_name varchar2(45) := 'get_award_number' ;
607: l_award_set_id NUMBER ;
608: l_award_number gms_awards_all.award_number%TYPE ;
609: l_count NUMBER ;
610: begin
611:
612: -- Standrad call to check API compatibility.

Line 636: from gms_awards_all awd, gms_award_distributions adl

632: l_count := l_index ;
633:
634: select awd.award_number
635: into l_award_number
636: from gms_awards_all awd, gms_award_distributions adl
637: where adl.award_set_id = l_award_set_id
638: and adl.award_id = awd.award_id ;
639:
640: x_award_num_tbl(l_index) := l_award_number ;