APPS.GMS_PO_API_GRP dependencies on GMS_AWARDS_ALL

Line 646: l_award_number gms_awards_all.award_number%TYPE ;

642: l_msg_data varchar2(2000) ;
643: l_return_status varchar2(1) ;
644: l_api_name varchar2(45) := 'get_award_number' ;
645:
646: l_award_number gms_awards_all.award_number%TYPE ;
647:
648: cursor c1 is
649: select awd.award_number
650: from gms_awards_all awd,

Line 650: from gms_awards_all awd,

646: l_award_number gms_awards_all.award_number%TYPE ;
647:
648: cursor c1 is
649: select awd.award_number
650: from gms_awards_all awd,
651: gms_award_distributions adl
652: where adl.award_id = awd.award_id
653: and adl.award_set_id = p_award_set_id
654: and adl.adl_line_num = 1 ;

Line 730: -- Logic : select the award id from gms_awards_all

726: -- Return value : NUMBER ( award_id )
727: -- Pre Reqs : None
728: -- Function : API will determine the value of award_id for the award_number
729: -- passed.
730: -- Logic : select the award id from gms_awards_all
731: -- Calling API : PO_PDOI_DISTRIBUTIONS_SV1 and PO_VENDORS_SV1
732: -- Parameters :
733: -- : Standard parameters
734: -- p_api_version, p_commit, p_init_msg_list,

Line 810: from gms_awards_all

806: END IF ;
807:
808: select award_id
809: into l_award_id
810: from gms_awards_all
811: where award_number = p_award_number ;
812:
813: x_msg_count := l_msg_count ;
814: x_msg_data := l_msg_data ;

Line 1243: l_award_number gms_awards_all.award_number%TYPE ;

1239: -- SQL.
1240: --
1241: FUNCTION GET_AWARD_NUMBER( p_award_set_id IN NUMBER)
1242: return varchar2 is
1243: l_award_number gms_awards_all.award_number%TYPE ;
1244: BEGIN
1245: IF p_award_set_id is NULL THEN
1246: return NULL ;
1247: END IF ;

Line 1251: from gms_awards_all awd,

1247: END IF ;
1248:
1249: select awd.award_number
1250: into l_award_number
1251: from gms_awards_all awd,
1252: gms_award_distributions adl
1253: where adl.award_set_id = p_award_set_id
1254: and adl.award_id = awd.award_id
1255: and adl.adl_line_num = 1 ;

Line 1295: l_award_id gms_awards_all.award_id%TYPE ;

1291: p_po_distribution_id in number,
1292: x_award_set_id_out out nocopy number ) is
1293:
1294: l_adl_rec gms_award_distributions%ROWTYPE ;
1295: l_award_id gms_awards_all.award_id%TYPE ;
1296: l_msg_count number ;
1297: l_msg_data varchar2(2000) ;
1298: l_return_status varchar2(1) ;
1299: l_api_name varchar2(50) := 'CREATE_PO_ADL' ;

Line 1335: from gms_awards_all

1331: END IF ;
1332:
1333: select award_id
1334: into l_award_id
1335: from gms_awards_all
1336: where award_number = p_award_number ;
1337:
1338: l_adl_rec.last_update_date := sysdate ;
1339: l_adl_rec.last_updated_by := nvl(fnd_global.user_id,0) ;

Line 1424: l_award_id gms_awards_all.award_id%TYPE ;

1420: l_adl_rec gms_award_distributions%ROWTYPE ;
1421: l_create_flag varchar2(1) ;
1422: l_update_flag varchar2(1) ;
1423: l_award_set_id_out number ;
1424: l_award_id gms_awards_all.award_id%TYPE ;
1425:
1426: l_msg_count number ;
1427: l_msg_data varchar2(2000) ;
1428: l_return_status varchar2(1) ;

Line 1598: from gms_awards_all

1594: l_award_set_id_out := p_award_set_id_in ;
1595:
1596: select award_id
1597: into l_award_id
1598: from gms_awards_all
1599: where award_number = p_award_number ;
1600:
1601: l_adl_rec.award_id := l_award_id ;
1602: l_adl_rec.last_update_date := sysdate ;