DBA Data[Home] [Help]

APPS.AP_CUSTOM_INT_INV_PKG dependencies on FND_NUMBER

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

96:
97: ELSIF l_country_code = 'BR' then
98:
99: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
100: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
101: SELECT substr(global_attribute1,1,15) interest_type,
102: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
103: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
104: substr(global_attribute4,1,30) interest_formula,

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

98:
99: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
100: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
101: SELECT substr(global_attribute1,1,15) interest_type,
102: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
103: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
104: substr(global_attribute4,1,30) interest_formula,
105: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
106: substr(global_attribute6,1,15) penalty_type,

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

99: -- Get Global_Attribute1..7, due_date from ap_payment_schedule
100: --Bug6238399 Use fnd_number.canonical_to_number instead of to_number
101: SELECT substr(global_attribute1,1,15) interest_type,
102: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
103: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
104: substr(global_attribute4,1,30) interest_formula,
105: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
106: substr(global_attribute6,1,15) penalty_type,
107: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount

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

101: SELECT substr(global_attribute1,1,15) interest_type,
102: fnd_number.canonical_to_number(substr(global_attribute2,1,15)) interest_rate_amount,
103: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
104: substr(global_attribute4,1,30) interest_formula,
105: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
106: substr(global_attribute6,1,15) penalty_type,
107: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
108: INTO l_interest_type,
109: l_interest_rate_amount,

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

103: fnd_number.canonical_to_number(substr(global_attribute3,1,15)) interest_period,
104: substr(global_attribute4,1,30) interest_formula,
105: fnd_number.canonical_to_number(substr(global_attribute5,1,4)) interest_grace_days,
106: substr(global_attribute6,1,15) penalty_type,
107: fnd_number.canonical_to_number(substr(global_attribute7,1,15)) penalty_rate_amount
108: INTO l_interest_type,
109: l_interest_rate_amount,
110: l_interest_period,
111: l_interest_formula,