1320: l_rate NUMBER;
1321: l_due_date DATE;
1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN
1321: l_due_date DATE;
1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN
1329: -- Get the Translatable Words for filling the description
1322: l_int_invoice_days NUMBER;
1323: /* Datatype for following variables changed for MLS */
1324: l_nls_interest ap_lookup_codes.displayed_field%TYPE; -- **1**
1325: l_nls_days ap_lookup_codes.displayed_field%TYPE; -- **1**
1326: l_nls_percent ap_lookup_codes.displayed_field%TYPE; -- **1**
1327:
1328: BEGIN
1329: -- Get the Translatable Words for filling the description
1330: SELECT l1.displayed_field,
1332: l3.displayed_field
1333: INTO l_nls_interest,
1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'
1333: INTO l_nls_interest,
1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'
1341: AND l2.lookup_type = 'NLS TRANSLATION'
1334: l_nls_days,
1335: l_nls_percent
1336: FROM ap_lookup_codes l1,
1337: ap_lookup_codes l2,
1338: ap_lookup_codes l3
1339: WHERE l1.lookup_type = 'NLS TRANSLATION'
1340: AND l1.lookup_code = 'INTEREST'
1341: AND l2.lookup_type = 'NLS TRANSLATION'
1342: AND l2.lookup_code = 'DAYS'