APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on FND_NUMBER

Line 152: /* Bug 3465021 - Added fnd_number.canonical_to_number api to amount related GDFs */

148: row_number IN NUMBER,
149: Errcd IN OUT NOCOPY NUMBER) IS
150: BEGIN
151: Errcd := 0;
152: /* Bug 3465021 - Added fnd_number.canonical_to_number api to amount related GDFs */
153: SELECT SUBSTR (global_attribute1, 1, 15),
154: fnd_number.canonical_to_number(SUBSTR (global_attribute2, 1, 38)),
155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),
156: SUBSTR (global_attribute4, 1, 30),

Line 154: fnd_number.canonical_to_number(SUBSTR (global_attribute2, 1, 38)),

150: BEGIN
151: Errcd := 0;
152: /* Bug 3465021 - Added fnd_number.canonical_to_number api to amount related GDFs */
153: SELECT SUBSTR (global_attribute1, 1, 15),
154: fnd_number.canonical_to_number(SUBSTR (global_attribute2, 1, 38)),
155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),
156: SUBSTR (global_attribute4, 1, 30),
157: fnd_number.canonical_to_number(SUBSTR (global_attribute5, 1, 4)),
158: SUBSTR (global_attribute6, 1, 15),

Line 155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),

151: Errcd := 0;
152: /* Bug 3465021 - Added fnd_number.canonical_to_number api to amount related GDFs */
153: SELECT SUBSTR (global_attribute1, 1, 15),
154: fnd_number.canonical_to_number(SUBSTR (global_attribute2, 1, 38)),
155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),
156: SUBSTR (global_attribute4, 1, 30),
157: fnd_number.canonical_to_number(SUBSTR (global_attribute5, 1, 4)),
158: SUBSTR (global_attribute6, 1, 15),
159: fnd_number.canonical_to_number(SUBSTR (global_attribute7, 1, 38))

Line 157: fnd_number.canonical_to_number(SUBSTR (global_attribute5, 1, 4)),

153: SELECT SUBSTR (global_attribute1, 1, 15),
154: fnd_number.canonical_to_number(SUBSTR (global_attribute2, 1, 38)),
155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),
156: SUBSTR (global_attribute4, 1, 30),
157: fnd_number.canonical_to_number(SUBSTR (global_attribute5, 1, 4)),
158: SUBSTR (global_attribute6, 1, 15),
159: fnd_number.canonical_to_number(SUBSTR (global_attribute7, 1, 38))
160: INTO interest_type, interest_rate_amount, interest_period, interest_formula,
161: interest_grace_days, penalty_type, penalty_rate_amount

Line 159: fnd_number.canonical_to_number(SUBSTR (global_attribute7, 1, 38))

155: fnd_number.canonical_to_number(SUBSTR (global_attribute3, 1, 15)),
156: SUBSTR (global_attribute4, 1, 30),
157: fnd_number.canonical_to_number(SUBSTR (global_attribute5, 1, 4)),
158: SUBSTR (global_attribute6, 1, 15),
159: fnd_number.canonical_to_number(SUBSTR (global_attribute7, 1, 38))
160: INTO interest_type, interest_rate_amount, interest_period, interest_formula,
161: interest_grace_days, penalty_type, penalty_rate_amount
162: FROM ra_customer_trx
163: WHERE customer_trx_id = cust_trx_id