APPS.POS_SUPP_CLASSIFICATION_PKG dependencies on AP_SUPPLIERS

Line 439: from ap_suppliers

435:
436: select decode(WOMEN_OWNED_FLAG, 'Y', 'Y','N'),
437: SMALL_BUSINESS_FLAG, MINORITY_GROUP_LOOKUP_CODE
438: into l_women, l_small_business, l_minority
439: from ap_suppliers
440: where vendor_id = pVendorId;
441:
442: if (l_minority is null) then
443: l_minority := '__te_st__';

Line 469: update ap_suppliers

465:
466: if ( l_women <> l_women_status ) then
467: begin
468: --dbms_output.put_line('updating women owned status');
469: update ap_suppliers
470: set women_owned_flag = l_women_status
471: , last_update_date = l_women_update_date
472: where vendor_id = pVendorId;
473: end;

Line 498: update ap_suppliers

494: END;
495:
496: if ( l_small_business <> l_small_business_status ) then
497: begin
498: update ap_suppliers
499: set small_business_flag = l_small_business_status
500: , last_update_date = l_small_buss_update_date
501: where vendor_id = pVendorId;
502: end;

Line 530: update ap_suppliers

526:
527: if ( l_minority <> l_minority_status ) then
528: begin
529: --dbms_output.put_line('updating minority owned status');
530: update ap_suppliers
531: set MINORITY_GROUP_LOOKUP_CODE = l_minority_type
532: , last_update_date = l_minority_update_date
533: where vendor_id = pVendorId;
534: end;

Line 666: from ap_suppliers

662: BEGIN
663: select decode(WOMEN_OWNED_FLAG, 'Y', 'Y','N'), decode (SMALL_BUSINESS_FLAG, 'Y','Y','N'),
664: MINORITY_GROUP_LOOKUP_CODE, last_update_date
665: into l_women, l_small_business, l_minority, l_last_update_date
666: from ap_suppliers
667: where vendor_id = pVendorId;
668:
669: CHECK_AND_MV_CLASS
670: (