APPS.AP_VENDORS_PKG dependencies on STANDARD

Line 66: x_Standard_Industry_Class VARCHAR2,

62: x_Bank_Num VARCHAR2,
63: x_Bank_Account_Type VARCHAR2,
64: x_Women_Owned_Flag VARCHAR2,
65: x_Small_Business_Flag VARCHAR2,
66: x_Standard_Industry_Class VARCHAR2,
67: x_Attribute_Category VARCHAR2,
68: x_Attribute1 VARCHAR2,
69: x_Attribute2 VARCHAR2,
70: x_Attribute3 VARCHAR2,

Line 293: standard_industry_class,

289: bank_num,
290: bank_account_type,
291: women_owned_flag,
292: small_business_flag,
293: standard_industry_class,
294: attribute_category,
295: attribute1,
296: attribute2,
297: attribute3,

Line 425: x_Standard_Industry_Class,

421: x_Bank_Num,
422: x_Bank_Account_Type,
423: x_Women_Owned_Flag,
424: x_Small_Business_Flag,
425: x_Standard_Industry_Class,
426: x_Attribute_Category,
427: x_Attribute1,
428: x_Attribute2,
429: x_Attribute3,

Line 603: standard_industry_class, -- Bug 5066199

599: employee_id,
600: validation_number,
601: vendor_type_lookup_code,
602: customer_num,
603: standard_industry_class, -- Bug 5066199
604: one_time_flag,
605: parent_vendor_id,
606: min_order_amount,
607: terms_id,

Line 915: x_Standard_Industry_Class VARCHAR2,

911: x_Bank_Num VARCHAR2,
912: x_Bank_Account_Type VARCHAR2,
913: x_Women_Owned_Flag VARCHAR2,
914: x_Small_Business_Flag VARCHAR2,
915: x_Standard_Industry_Class VARCHAR2,
916: x_Attribute_Category VARCHAR2,
917: x_Attribute1 VARCHAR2,
918: x_Attribute2 VARCHAR2,
919: x_Attribute3 VARCHAR2,

Line 1079: standard_industry_class = x_Standard_Industry_Class,

1075: bank_num = x_Bank_Num,
1076: bank_account_type = x_Bank_Account_Type,
1077: women_owned_flag = x_Women_Owned_Flag,
1078: small_business_flag = x_Small_Business_Flag,
1079: standard_industry_class = x_Standard_Industry_Class,
1080: attribute_category = x_Attribute_Category,
1081: attribute1 = x_Attribute1,
1082: attribute2 = x_Attribute2,
1083: attribute3 = x_Attribute3,

Line 1325: standard_industry_class = p_vendor_rec.sic_code -- 5066199

1321: global_attribute19 = p_vendor_rec.global_attribute19,
1322: global_attribute20 = p_vendor_rec.global_attribute20,
1323: bank_charge_bearer = p_vendor_rec.Bank_Charge_Bearer,
1324: NI_Number = p_vendor_rec.NI_Number,
1325: standard_industry_class = p_vendor_rec.sic_code -- 5066199
1326: WHERE vendor_id = p_vendor_id;
1327: if (SQL%NOTFOUND) then
1328: Raise NO_DATA_FOUND;
1329: end if;

Line 1408: x_Standard_Industry_Class VARCHAR2,

1404: x_Bank_Num VARCHAR2,
1405: x_Bank_Account_Type VARCHAR2,
1406: x_Women_Owned_Flag VARCHAR2,
1407: x_Small_Business_Flag VARCHAR2,
1408: x_Standard_Industry_Class VARCHAR2,
1409: x_Attribute_Category VARCHAR2,
1410: x_Attribute1 VARCHAR2,
1411: x_Attribute2 VARCHAR2,
1412: x_Attribute3 VARCHAR2,

Line 1656: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)

1652: AND (x_Women_Owned_Flag IS NULL)))
1653: AND ((Recinfo.small_business_flag = x_Small_Business_Flag)
1654: OR ((Recinfo.small_business_flag IS NULL)
1655: AND (x_Small_Business_Flag IS NULL)))
1656: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1657: OR ((Recinfo.standard_industry_class IS NULL)
1658: AND (x_Standard_Industry_Class IS NULL)))
1659: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1660: --Bug :2809214 MOAC - Supplier Attribute Change Project

Line 1657: OR ((Recinfo.standard_industry_class IS NULL)

1653: AND ((Recinfo.small_business_flag = x_Small_Business_Flag)
1654: OR ((Recinfo.small_business_flag IS NULL)
1655: AND (x_Small_Business_Flag IS NULL)))
1656: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1657: OR ((Recinfo.standard_industry_class IS NULL)
1658: AND (x_Standard_Industry_Class IS NULL)))
1659: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1660: --Bug :2809214 MOAC - Supplier Attribute Change Project
1661: AND ((Recinfo.NI_Number = x_NI_Number)

Line 1658: AND (x_Standard_Industry_Class IS NULL)))

1654: OR ((Recinfo.small_business_flag IS NULL)
1655: AND (x_Small_Business_Flag IS NULL)))
1656: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1657: OR ((Recinfo.standard_industry_class IS NULL)
1658: AND (x_Standard_Industry_Class IS NULL)))
1659: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1660: --Bug :2809214 MOAC - Supplier Attribute Change Project
1661: AND ((Recinfo.NI_Number = x_NI_Number)
1662: OR ((Recinfo.NI_Number IS NULL)