DBA Data[Home] [Help]

APPS.POS_AP_SUPPLIER_BO_PKG dependencies on STANDARD

Line 116: -- Added the decode funtion to avoid the ASCII 0 character present in the Standard industry class column for some suppliers,

112: bank_account_type,
113: women_owned_flag,
114: small_business_flag,
115: -- Bug 9509201, 9535269
116: -- Added the decode funtion to avoid the ASCII 0 character present in the Standard industry class column for some suppliers,
117: -- as it is creating problems in the XML payload creation for SDH Generate Report and Publish Supplier functionality.
118: -- Bug 8246403 addressed this exact issue. The error is considered to be a correct behavior, but a DB level option can be set by alter session to encode invalid characters.
119: decode(standard_industry_class, chr(0), NULL, standard_industry_class),
120: hold_flag,

Line 119: decode(standard_industry_class, chr(0), NULL, standard_industry_class),

115: -- Bug 9509201, 9535269
116: -- Added the decode funtion to avoid the ASCII 0 character present in the Standard industry class column for some suppliers,
117: -- as it is creating problems in the XML payload creation for SDH Generate Report and Publish Supplier functionality.
118: -- Bug 8246403 addressed this exact issue. The error is considered to be a correct behavior, but a DB level option can be set by alter session to encode invalid characters.
119: decode(standard_industry_class, chr(0), NULL, standard_industry_class),
120: hold_flag,
121: purchasing_hold_reason,
122: hold_by,
123: hold_date,