1: PACKAGE BODY GMP_PLNG_DTL_REPORT_PKG AS
2: /* $Header: GMPPLDRB.pls 120.35.12020000.2 2012/07/24 15:13:40 vkinduri ship $ */
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 9366921
6:
7: split_report VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_SPLIT_PDR_BY_ORGANIZATION'),'N'); -- Bug: 9458217 Vpedarla
8:
9: scale_report VARCHAR2(1) ; -- Bug: 9265463 vpedarla
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 9366921
6:
7: split_report VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_SPLIT_PDR_BY_ORGANIZATION'),'N'); -- Bug: 9458217 Vpedarla
8:
9: scale_report VARCHAR2(1) ; -- Bug: 9265463 vpedarla
10:
11: G_inst_id NUMBER;
152: BEGIN
153:
154: gmp_debug_message(' Into GMP_PLNG_DTL_REPORT_PKG.create_pdr ');
155:
156: split_report := NVL(FND_PROFILE.VALUE('GMP_SPLIT_PDR_BY_ORGANIZATION'),'N'); -- Bug: 9458217 Vpedarla
157:
158: scale_report := NVL(FND_PROFILE.VALUE('GMP_SCALE_PDR'),'N'); -- Bug: 9265463 Vpedarla
159:
160: Horiz_details_count := 0; -- Bug: 9265463
154: gmp_debug_message(' Into GMP_PLNG_DTL_REPORT_PKG.create_pdr ');
155:
156: split_report := NVL(FND_PROFILE.VALUE('GMP_SPLIT_PDR_BY_ORGANIZATION'),'N'); -- Bug: 9458217 Vpedarla
157:
158: scale_report := NVL(FND_PROFILE.VALUE('GMP_SCALE_PDR'),'N'); -- Bug: 9265463 Vpedarla
159:
160: Horiz_details_count := 0; -- Bug: 9265463
161:
162: retcode := 0;
1206:
1207: -- B7481907 Rajesh Patangya starts
1208: -- The following line of code ensures that XML data
1209: -- generated here uses the right encoding
1210: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1211: l_xml_header := '';
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_xml_header - '||l_xml_header);
1213: -- B7481907 Rajesh Patangya starts
1214: