DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FND_LANGUAGES

Line 1656: l_iso_language FND_LANGUAGES.iso_language%TYPE;

1652: l_zero_amounts_allowed varchar2(1);
1653: l_zero_invoices_allowed varchar2(1);
1654: SELECTION_FAILURE EXCEPTION;
1655: l_xml_output BOOLEAN;
1656: l_iso_language FND_LANGUAGES.iso_language%TYPE;
1657: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1658: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; -- Bug 6969710
1659: /*bug 7519277*/
1660: l_ATTRIBUTE_CATEGORY VARCHAR2(150);

Line 1657: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;

1653: l_zero_invoices_allowed varchar2(1);
1654: SELECTION_FAILURE EXCEPTION;
1655: l_xml_output BOOLEAN;
1656: l_iso_language FND_LANGUAGES.iso_language%TYPE;
1657: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
1658: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; -- Bug 6969710
1659: /*bug 7519277*/
1660: l_ATTRIBUTE_CATEGORY VARCHAR2(150);
1661: l_ATTRIBUTE1 VARCHAR2(150);

Line 3932: FROM FND_LANGUAGES

3928:
3929: -- Bug 4681857
3930: SELECT lower(iso_language),iso_territory
3931: INTO l_iso_language,l_iso_territory
3932: FROM FND_LANGUAGES
3933: WHERE language_code = USERENV('LANG');
3934:
3935: --Bug 6969710
3936: SELECT nvl(template_code, 'APINVSEL' )

Line 4070: l_iso_language FND_LANGUAGES.iso_language%TYPE;

4066: l_batch_exchange_rate_type varchar2(30);
4067: l_batch_status varchar2(30);
4068: l_payment_document_id number(15); --4939405
4069: l_xml_output BOOLEAN;
4070: l_iso_language FND_LANGUAGES.iso_language%TYPE;
4071: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
4072: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; --Bug 6969710
4073: /*bug 7519277*/
4074: l_ATTRIBUTE_CATEGORY VARCHAR2(150);

Line 4071: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;

4067: l_batch_status varchar2(30);
4068: l_payment_document_id number(15); --4939405
4069: l_xml_output BOOLEAN;
4070: l_iso_language FND_LANGUAGES.iso_language%TYPE;
4071: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
4072: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; --Bug 6969710
4073: /*bug 7519277*/
4074: l_ATTRIBUTE_CATEGORY VARCHAR2(150);
4075: l_ATTRIBUTE1 VARCHAR2(150);

Line 4459: FROM FND_LANGUAGES

4455: where checkrun_id = p_checkrun_id;
4456:
4457: SELECT lower(iso_language),iso_territory
4458: INTO l_iso_language,l_iso_territory
4459: FROM FND_LANGUAGES
4460: WHERE language_code = USERENV('LANG');
4461:
4462: -- Bug 4681857
4463: