APPS.AP_AUTOSELECT_PKG dependencies on XDO_TEMPLATES_B

Line 2297: l_output_format XDO_TEMPLATES_B.DEFAULT_OUTPUT_TYPE%TYPE; /* Bug#12917747 */

2293: l_xml_output BOOLEAN;
2294: l_iso_language FND_LANGUAGES.iso_language%TYPE;
2295: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
2296: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; -- Bug 6969710
2297: l_output_format XDO_TEMPLATES_B.DEFAULT_OUTPUT_TYPE%TYPE; /* Bug#12917747 */
2298: /*bug 7519277*/
2299: l_ATTRIBUTE_CATEGORY VARCHAR2(150);
2300: l_ATTRIBUTE1 VARCHAR2(150);
2301: l_ATTRIBUTE2 VARCHAR2(150);

Line 5192: FROM XDO_TEMPLATES_B xtb

5188:
5189: /* Added for bug#12917747 Start */
5190: SELECT nvl(template_code, 'APINVSEL' )
5191: , (SELECT Nvl(DEFAULT_OUTPUT_TYPE,'PDF')
5192: FROM XDO_TEMPLATES_B xtb
5193: WHERE xtb.TEMPLATE_CODE = nvl(fcp.template_code, 'APINVSEL' )
5194: AND APPLICATION_ID = 200
5195: AND rownum = 1
5196: )

Line 5337: l_output_format XDO_TEMPLATES_B.DEFAULT_OUTPUT_TYPE%TYPE; /* Bug#12917747 */

5333: l_xml_output BOOLEAN;
5334: l_iso_language FND_LANGUAGES.iso_language%TYPE;
5335: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
5336: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; --Bug 6969710
5337: l_output_format XDO_TEMPLATES_B.DEFAULT_OUTPUT_TYPE%TYPE; /* Bug#12917747 */
5338: /*bug 7519277*/
5339: l_ATTRIBUTE_CATEGORY VARCHAR2(150);
5340: l_ATTRIBUTE1 VARCHAR2(150);
5341: l_ATTRIBUTE2 VARCHAR2(150);

Line 6031: FROM XDO_TEMPLATES_B xtb

6027:
6028: /* Added for bug#12917747 Start */
6029: SELECT nvl(template_code, 'APINVSEL' )
6030: , (SELECT Nvl(DEFAULT_OUTPUT_TYPE,'PDF')
6031: FROM XDO_TEMPLATES_B xtb
6032: WHERE xtb.TEMPLATE_CODE = nvl(fcp.template_code, 'APINVSEL' )
6033: AND APPLICATION_ID = 200
6034: AND rownum = 1
6035: )