APPS.AP_AUTOSELECT_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 2296: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; -- Bug 6969710

2292: SELECTION_FAILURE EXCEPTION;
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);

Line 5185: FROM Fnd_Concurrent_Programs

5181: --Bug 6969710
5182: /* Commented for bug#12917747 Start
5183: SELECT nvl(template_code, 'APINVSEL' )
5184: INTO l_template_code
5185: FROM Fnd_Concurrent_Programs
5186: WHERE concurrent_program_name = 'APINVSEL'; --Bug 6969710
5187: Commented for bug#12917747 End */
5188:
5189: /* Added for bug#12917747 Start */

Line 5199: FROM Fnd_Concurrent_Programs fcp

5195: AND rownum = 1
5196: )
5197: INTO l_template_code
5198: , l_output_format
5199: FROM Fnd_Concurrent_Programs fcp
5200: WHERE concurrent_program_name = 'APINVSEL';
5201: /* Added for bug#12917747 End */
5202:
5203: l_xml_output:= fnd_request.add_layout(

Line 5336: l_template_code Fnd_Concurrent_Programs.template_code%TYPE; --Bug 6969710

5332: l_payment_document_id number(15); --4939405
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);

Line 6024: FROM Fnd_Concurrent_Programs

6020: --Bug 6969710
6021: /* Commented for bug#12917747 Start
6022: SELECT nvl(template_code, 'APINVSEL' )
6023: INTO l_template_code
6024: FROM Fnd_Concurrent_Programs
6025: WHERE concurrent_program_name = 'APINVSEL'; --Bug 6969710
6026: Commented for bug#12917747 End */
6027:
6028: /* Added for bug#12917747 Start */

Line 6038: FROM Fnd_Concurrent_Programs fcp

6034: AND rownum = 1
6035: )
6036: INTO l_template_code
6037: , l_output_format
6038: FROM Fnd_Concurrent_Programs fcp
6039: WHERE concurrent_program_name = 'APINVSEL';
6040: /* Added for bug#12917747 End */
6041:
6042: l_xml_output:= fnd_request.add_layout(