APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on AP_SUPPLIERS

Line 450: from ap_suppliers

446:
447: select decode(WOMEN_OWNED_FLAG, 'Y', 'Y','N'),
448: decode(SMALL_BUSINESS_FLAG,'Y','Y','N'), MINORITY_GROUP_LOOKUP_CODE
449: into l_women, l_small_business, l_minority
450: from ap_suppliers
451: where vendor_id = pVendorId;
452:
453: if (l_minority is null) then
454: l_minority := '__te_st__';

Line 482: update ap_suppliers

478:
479: if ( l_women <> l_women_status ) then
480: begin
481: --dbms_output.put_line('updating women owned status');
482: update ap_suppliers
483: set women_owned_flag = l_women_status
484: , last_update_date = l_women_update_date
485: where vendor_id = pVendorId;
486: end;

Line 513: update ap_suppliers

509: END;
510:
511: if ( l_small_business <> l_small_business_status ) then
512: begin
513: update ap_suppliers
514: set small_business_flag = l_small_business_status
515: , last_update_date = l_small_buss_update_date
516: where vendor_id = pVendorId;
517: end;

Line 547: update ap_suppliers

543:
544: if ( l_minority <> l_minority_type ) and (l_minority_type is not null) then
545: begin
546: --dbms_output.put_line('updating minority owned status');
547: update ap_suppliers
548: set MINORITY_GROUP_LOOKUP_CODE = l_minority_type
549: , last_update_date = l_minority_update_date
550: where vendor_id = pVendorId;
551: end;

Line 685: from ap_suppliers

681: BEGIN
682: select decode(WOMEN_OWNED_FLAG, 'Y', 'Y','N'), decode (SMALL_BUSINESS_FLAG, 'Y','Y','N'),
683: MINORITY_GROUP_LOOKUP_CODE, last_update_date
684: into l_women, l_small_business, l_minority, l_last_update_date
685: from ap_suppliers
686: where vendor_id = pVendorId;
687:
688: CHECK_AND_MV_CLASS
689: (

Line 921: SELECT party_id INTO p_party_id FROM ap_suppliers WHERE vendor_id = p_vendor_id;

917: BEGIN
918:
919: x_status := 'S';
920:
921: SELECT party_id INTO p_party_id FROM ap_suppliers WHERE vendor_id = p_vendor_id;
922:
923: OPEN AddrBusClass;
924:
925: LOOP