DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on OZF_SD_BATCH_PVT

Line 1: PACKAGE BODY OZF_SD_BATCH_PVT AS

1: PACKAGE BODY OZF_SD_BATCH_PVT AS
2: /* $Header: ozfvsdbb.pls 120.48.12010000.15 2009/02/11 12:34:15 annsrini ship $ */
3:
4: -- Start of Comments
5: -- Package name : OZF_SD_BATCH_PVT

Line 5: -- Package name : OZF_SD_BATCH_PVT

1: PACKAGE BODY OZF_SD_BATCH_PVT AS
2: /* $Header: ozfvsdbb.pls 120.48.12010000.15 2009/02/11 12:34:15 annsrini ship $ */
3:
4: -- Start of Comments
5: -- Package name : OZF_SD_BATCH_PVT
6: -- Purpose : This package contains procedures and functions for batch creation concurrent program
7: -- Also contains executable procedure for auto claim concurrent program
8: -- Author : MBHATT
9: -- Created : 11/16/2007 2:39:16 PM

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';

24: --
25: -- NOTE :
26: -- End of Comments
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_BATCH_PVT';
29: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdbb.pls';
30: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
31: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
32: OZF_ERROR_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error);

Line 1450: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_DISC_TO_OFFER_CURR_AMOUNT(OFRS.TRANSACTION_CURRENCY_CODE,RL. APPROVED_DISCOUNT_CURRENCY, RL.APPROVED_DISCOUNT_VALUE, ' || p_batch_id || ' )';

1446: -- From Currency RL. APPROVED_DISCOUNT_CURRENCY
1447: -- From Amount RL.APPROVED_DISCOUNT_VALUE
1448: -- Batch ID p_batch_id
1449:
1450: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_DISC_TO_OFFER_CURR_AMOUNT(OFRS.TRANSACTION_CURRENCY_CODE,RL. APPROVED_DISCOUNT_CURRENCY, RL.APPROVED_DISCOUNT_VALUE, ' || p_batch_id || ' )';
1451:
1452: FND_DSQL.add_text('decode (rl.APPROVED_DISCOUNT_TYPE,
1453: ''%'', (OEL.UNIT_LIST_PRICE * (1 - RL.APPROVED_DISCOUNT_VALUE/100)),
1454: ''AMT'', (OEL.UNIT_LIST_PRICE - ' || l_func_call_string || '),

Line 1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );

1455: ''NEWPRICE'', '|| l_func_call_string || ', ' ||
1456: l_func_call_string || ') APPROVED_DISCOUNT_VALUE, ');
1457:
1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');

Line 2235: END OZF_SD_BATCH_PVT;

2231:
2232: END INVOKE_BATCH_AUTO_CLAIM;
2233:
2234:
2235: END OZF_SD_BATCH_PVT;