APPS.LNS_APPROVAL_ACTION_PUB dependencies on FND_LANGUAGES

Line 451: l_iso_language FND_LANGUAGES.iso_language%TYPE;

447: l_secondary_status varchar2(30);
448: l_prev_sec_status varchar2(30);
449: l_prev_loan_status varchar2(30);
450: l_xml_output BOOLEAN;
451: l_iso_language FND_LANGUAGES.iso_language%TYPE;
452: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
453: l_dates_shifted_flag VARCHAR2(1);
454: --Bug 6938125 - FP:11i-R12:ENHANCEMENTS TO CUSTOM AMORTIZATION SCHEDULE
455: l_customized varchar2(1);

Line 452: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;

448: l_prev_sec_status varchar2(30);
449: l_prev_loan_status varchar2(30);
450: l_xml_output BOOLEAN;
451: l_iso_language FND_LANGUAGES.iso_language%TYPE;
452: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
453: l_dates_shifted_flag VARCHAR2(1);
454: --Bug 6938125 - FP:11i-R12:ENHANCEMENTS TO CUSTOM AMORTIZATION SCHEDULE
455: l_customized varchar2(1);
456: l_offset number(38);

Line 1219: FND_LANGUAGES

1215: lower(iso_language),iso_territory
1216: INTO
1217: l_iso_language,l_iso_territory
1218: FROM
1219: FND_LANGUAGES
1220: WHERE
1221: language_code = USERENV('LANG');
1222:
1223:

Line 1620: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;

1616: l_msg_data VARCHAR2(32767);
1617: l_trx_number varchar2(20);
1618: l_loan_id number;
1619: -- l_xml_output BOOLEAN;
1620: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;
1621: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1622: l_agreement_reason varchar2(500);
1623: -- l_notify boolean;
1624: -- l_request_id number;

Line 1621: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;

1617: l_trx_number varchar2(20);
1618: l_loan_id number;
1619: -- l_xml_output BOOLEAN;
1620: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;
1621: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1622: l_agreement_reason varchar2(500);
1623: -- l_notify boolean;
1624: -- l_request_id number;
1625: l_version_number number;

Line 1898: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;

1894: l_msg_count NUMBER;
1895: l_msg_data VARCHAR2(32767);
1896: l_loan_id number;
1897: -- l_xml_output BOOLEAN;
1898: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;
1899: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1900: l_agreement_reason varchar2(500);
1901: -- l_notify boolean;
1902: -- l_request_id number;

Line 1899: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;

1895: l_msg_data VARCHAR2(32767);
1896: l_loan_id number;
1897: -- l_xml_output BOOLEAN;
1898: -- l_iso_language FND_LANGUAGES.iso_language%TYPE;
1899: -- l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1900: l_agreement_reason varchar2(500);
1901: -- l_notify boolean;
1902: -- l_request_id number;
1903: l_cond_count number;