DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_PROFILE

Line 5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY CST_RevenueCogsMatch_PVT AS
2: /* $Header: CSTRCMVB.pls 120.45.12010000.4 2008/12/16 22:32:12 hyu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_RevenueCogsMatch_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
7: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_module_name VARCHAR2(255) := G_LOG_HEAD;
9:

Line 1175: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls

1171: -- called 'ORDER ENTRY' and will most likely never change.
1172: l_stmt_num := 80;
1173: debug(l_stmt_num);
1174:
1175: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
1176: debug(' l_source_code : '||l_source_code);
1177:
1178: l_stmt_num := 90;
1179: debug(l_stmt_num);

Line 2304: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls

2300: -- called 'ORDER ENTRY' and will most likely never change.
2301: l_stmt_num := 145;
2302: debug(l_stmt_num);
2303:
2304: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
2305: debug(' l_source_code : '||l_source_code);
2306:
2307: l_stmt_num := 150;
2308: debug(l_stmt_num);

Line 3231: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls

3227: -- It can be overridden by the user but most likely uses the default
3228: -- called 'ORDER ENTRY' and will most likely never change.
3229: l_stmt_num := 80;
3230: debug(l_stmt_num);
3231: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
3232:
3233: debug(' l_source_code : '||l_source_code);
3234: -- Insert MMT event here (from one global temp table to another)
3235: l_stmt_num := 90;

Line 5320: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

5316:
5317: dbms_lob.createtemporary(l_xml_doc, TRUE);
5318:
5319: /*Bug 7305146*/
5320: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5321: l_xml_header := '';
5322: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5323:
5324: dbms_lob.writeappend (l_xml_doc, 8, '');

Line 5641: fnd_profile.get('CST_ACCRUAL_AGE_IN_DAYS', l_age_option);

5637: l_offset := 21;
5638:
5639: -- Get the proile value to determine the aging basis
5640:
5641: fnd_profile.get('CST_ACCRUAL_AGE_IN_DAYS', l_age_option);
5642:
5643: l_stmt_num := 10;
5644:
5645: -- Open Ref Cursor to collect the report parameters