DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on FND_NUMBER

Line 74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number

70:
71: ELSIF l_country_code = 'BR' then
72:
73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,

Line 76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,

72:
73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,

Line 77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,

73: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
74: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount

Line 79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,

75: SELECT substr(global_attribute1,1,15) interest_type,
76: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
82: INTO l_interest_type,
83: l_interest_rate_amount,

Line 81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount

77: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
78: substr(global_attribute4,1,30) interest_formula,
79: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
80: substr(global_attribute6,1,15) penalty_type,
81: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
82: INTO l_interest_type,
83: l_interest_rate_amount,
84: l_interest_period,
85: l_interest_formula,