DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on FND_PROFILE

Line 5055: 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);

5051: --before populating the credit exposure.
5052:
5053: IF G_debug_flag = 'Y'
5054: THEN
5055: 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);
5056: END IF;
5057:
5058: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN
5059: DELETE FROM oe_credit_summaries

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

5054: THEN
5055: 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);
5056: END IF;
5057:
5058: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'Y' THEN
5059: DELETE FROM oe_credit_summaries
5060: WHERE balance_type <> 18;
5061: ELSE
5062: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema); --This API is used to get schema name

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

8150: bucket_duration = l_bucket_length
8151: WHERE balance_type NOT IN (18,23,24,25,26,27,28,29,30,31,32,33,34,35,36); ---change for Returns
8152:
8153: */
8154: IF NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y') = 'N' THEN
8155: UPDATE
8156: oe_credit_summaries
8157: SET
8158: bucket_duration = l_bucket_length