APPS.OE_CREDIT_EXPOSURE_PVT dependencies on FND_PROFILE

Line 5415: oe_debug_pub.add( 'Value of the profile OM: Preserve External Credit Balances is :' || NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y'),2);

5411: --before populating the credit exposure.
5412:
5413: IF G_debug_flag = 'Y'
5414: THEN
5415: oe_debug_pub.add( 'Value of the profile OM: Preserve External Credit Balances is :' || NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y'),2);
5416: END IF;
5417:
5418: --8567481 start
5419: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema);

Line 5424: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN

5420: l_sql_stmnt_hwm := 'ANALYZE TABLE '|| l_ont_schema||'.oe_credit_summaries ESTIMATE STATISTICS';
5421: EXECUTE IMMEDIATE l_sql_stmnt_hwm;
5422: --8567481 end
5423:
5424: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN
5425: /*14689044 start
5426: DELETE FROM oe_credit_summaries
5427: WHERE balance_type <> 18;
5428: 14689044 end*/

Line 10082: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'N' THEN

10078: bucket_duration = l_bucket_length
10079: WHERE balance_type NOT IN (18,23,24,25,26,27,28,29,30,31,32,33,34,35,36); ---change for Returns
10080:
10081: */
10082: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'N' THEN
10083: UPDATE
10084: oe_credit_summaries
10085: SET
10086: bucket_duration = l_bucket_length