DBA Data[Home] [Help]

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 604: standard_industry_class, -- Bug 5066199

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

Line 933: x_Standard_Industry_Class VARCHAR2,

929: x_Bank_Num VARCHAR2,
930: x_Bank_Account_Type VARCHAR2,
931: x_Women_Owned_Flag VARCHAR2,
932: x_Small_Business_Flag VARCHAR2,
933: x_Standard_Industry_Class VARCHAR2,
934: x_Attribute_Category VARCHAR2,
935: x_Attribute1 VARCHAR2,
936: x_Attribute2 VARCHAR2,
937: x_Attribute3 VARCHAR2,

Line 1097: standard_industry_class = x_Standard_Industry_Class,

1093: bank_num = x_Bank_Num,
1094: bank_account_type = x_Bank_Account_Type,
1095: women_owned_flag = x_Women_Owned_Flag,
1096: small_business_flag = x_Small_Business_Flag,
1097: standard_industry_class = x_Standard_Industry_Class,
1098: attribute_category = x_Attribute_Category,
1099: attribute1 = x_Attribute1,
1100: attribute2 = x_Attribute2,
1101: attribute3 = x_Attribute3,

Line 1351: standard_industry_class = p_vendor_rec.sic_code -- 5066199

1347: global_attribute19 = p_vendor_rec.global_attribute19,
1348: global_attribute20 = p_vendor_rec.global_attribute20,
1349: bank_charge_bearer = p_vendor_rec.Bank_Charge_Bearer,
1350: NI_Number = p_vendor_rec.NI_Number,
1351: standard_industry_class = p_vendor_rec.sic_code -- 5066199
1352: WHERE vendor_id = p_vendor_id;
1353: if (SQL%NOTFOUND) then
1354: Raise NO_DATA_FOUND;
1355: end if;

Line 1434: x_Standard_Industry_Class VARCHAR2,

1430: x_Bank_Num VARCHAR2,
1431: x_Bank_Account_Type VARCHAR2,
1432: x_Women_Owned_Flag VARCHAR2,
1433: x_Small_Business_Flag VARCHAR2,
1434: x_Standard_Industry_Class VARCHAR2,
1435: x_Attribute_Category VARCHAR2,
1436: x_Attribute1 VARCHAR2,
1437: x_Attribute2 VARCHAR2,
1438: x_Attribute3 VARCHAR2,

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

1678: AND (x_Women_Owned_Flag IS NULL)))
1679: AND ((Recinfo.small_business_flag = x_Small_Business_Flag)
1680: OR ((Recinfo.small_business_flag IS NULL)
1681: AND (x_Small_Business_Flag IS NULL)))
1682: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1683: OR ((Recinfo.standard_industry_class IS NULL)
1684: AND (x_Standard_Industry_Class IS NULL)))
1685: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1686: --Bug :2809214 MOAC - Supplier Attribute Change Project

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

1679: AND ((Recinfo.small_business_flag = x_Small_Business_Flag)
1680: OR ((Recinfo.small_business_flag IS NULL)
1681: AND (x_Small_Business_Flag IS NULL)))
1682: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1683: OR ((Recinfo.standard_industry_class IS NULL)
1684: AND (x_Standard_Industry_Class IS NULL)))
1685: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1686: --Bug :2809214 MOAC - Supplier Attribute Change Project
1687: AND ((Recinfo.NI_Number = x_NI_Number)

Line 1684: AND (x_Standard_Industry_Class IS NULL)))

1680: OR ((Recinfo.small_business_flag IS NULL)
1681: AND (x_Small_Business_Flag IS NULL)))
1682: AND ((Recinfo.standard_industry_class = x_Standard_Industry_Class)
1683: OR ((Recinfo.standard_industry_class IS NULL)
1684: AND (x_Standard_Industry_Class IS NULL)))
1685: AND (NVL(Recinfo.Bank_Charge_Bearer,'I') = x_Bank_Charge_Bearer)
1686: --Bug :2809214 MOAC - Supplier Attribute Change Project
1687: AND ((Recinfo.NI_Number = x_NI_Number)
1688: OR ((Recinfo.NI_Number IS NULL)