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.83.12020000.21 2013/03/01 05:37:11 vnagasow 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: g_mrp_debug CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('MRP_DEBUG'),'N');

Line 9: g_mrp_debug CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('MRP_DEBUG'),'N');

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: g_mrp_debug CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('MRP_DEBUG'),'N');
10:
11: -- factional number representing 23 hours, 59 minutes and 59 seconds
12: EndDateNum CONSTANT NUMBER := 1-1/86400;
13:

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

1350: -- called 'ORDER ENTRY' and will most likely never change.
1351: l_stmt_num := 80;
1352: debug(l_stmt_num);
1353:
1354: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
1355: debug(' l_source_code : '||l_source_code);
1356:
1357: l_stmt_num := 90;
1358: debug(l_stmt_num);

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

2348: -- called 'ORDER ENTRY' and will most likely never change.
2349: l_stmt_num := 145;
2350: debug(l_stmt_num);
2351:
2352: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
2353: debug(' l_source_code : '||l_source_code);
2354:
2355: l_stmt_num := 150;
2356: debug(l_stmt_num);

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

3251: -- It can be overridden by the user but most likely uses the default
3252: -- called 'ORDER ENTRY' and will most likely never change.
3253: l_stmt_num := 80;
3254: debug(l_stmt_num);
3255: l_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); -- borrowed from OEXVSCHB.pls
3256:
3257: debug(' l_source_code : '||l_source_code);
3258: -- Insert MMT event here (from one global temp table to another)
3259: l_stmt_num := 90;

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

5435:
5436: dbms_lob.createtemporary(l_xml_doc, TRUE);
5437:
5438: /*Bug 7305146*/
5439: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
5440: l_xml_header := '';
5441: DBMS_LOB.writeappend (l_xml_doc, length(l_xml_header), l_xml_header);
5442:
5443: dbms_lob.writeappend (l_xml_doc, 8, '');

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

5752: l_offset := 21;
5753:
5754: -- Get the proile value to determine the aging basis
5755:
5756: fnd_profile.get('CST_ACCRUAL_AGE_IN_DAYS', l_age_option);
5757:
5758: l_stmt_num := 10;
5759:
5760: -- Open Ref Cursor to collect the report parameters