DBA Data[Home] [Help]

APPS.INV_TXN_PURGE_MAIN dependencies on FND_PROFILE

Line 4: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1: PACKAGE BODY inv_txn_purge_main AS
2: /* $Header: INVTPGMB.pls 120.0.12000000.2 2007/02/21 23:06:18 yssingh ship $ */
3: PROCEDURE txn_purge_main(x_errbuf OUT NOCOPY VARCHAR2, x_retcode OUT NOCOPY NUMBER, p_orgid IN NUMBER, p_purge_date IN DATE) IS
4: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5: l_max_workers NUMBER := NVL(fnd_profile.VALUE('INV_MAX_TXN_PG_PROCESSES'), 20);
6: l_num_of_periods NUMBER;
7: l_min_mmt_date DATE;
8: l_min_period_id NUMBER;

Line 5: l_max_workers NUMBER := NVL(fnd_profile.VALUE('INV_MAX_TXN_PG_PROCESSES'), 20);

1: PACKAGE BODY inv_txn_purge_main AS
2: /* $Header: INVTPGMB.pls 120.0.12000000.2 2007/02/21 23:06:18 yssingh ship $ */
3: PROCEDURE txn_purge_main(x_errbuf OUT NOCOPY VARCHAR2, x_retcode OUT NOCOPY NUMBER, p_orgid IN NUMBER, p_purge_date IN DATE) IS
4: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5: l_max_workers NUMBER := NVL(fnd_profile.VALUE('INV_MAX_TXN_PG_PROCESSES'), 20);
6: l_num_of_periods NUMBER;
7: l_min_mmt_date DATE;
8: l_min_period_id NUMBER;
9: l_min_date DATE;