DBA Data[Home] [Help]

APPS.INV_PURGE_PUB dependencies on FND_PROFILE

Line 38: l_login_id NUMBER := fnd_profile.VALUE('LOGIN_ID');

34: , p_orgid IN NUMBER
35: , p_purge_name IN VARCHAR2
36: ) IS
37: l_tempvar NUMBER;
38: l_login_id NUMBER := fnd_profile.VALUE('LOGIN_ID');
39: l_user_id NUMBER := fnd_profile.VALUE('USER_ID');
40: l_batch_size NUMBER := 1000;
41: l_more BOOLEAN := TRUE;
42: l_count NUMBER;

Line 39: l_user_id NUMBER := fnd_profile.VALUE('USER_ID');

35: , p_purge_name IN VARCHAR2
36: ) IS
37: l_tempvar NUMBER;
38: l_login_id NUMBER := fnd_profile.VALUE('LOGIN_ID');
39: l_user_id NUMBER := fnd_profile.VALUE('USER_ID');
40: l_batch_size NUMBER := 1000;
41: l_more BOOLEAN := TRUE;
42: l_count NUMBER;
43: l_total_count NUMBER;

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

41: l_more BOOLEAN := TRUE;
42: l_count NUMBER;
43: l_total_count NUMBER;
44: l_ret BOOLEAN;
45: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
46: --l_errbuf VARCHAR2(20); Commented out as part of Bug# 3542452
47: --l_retcode NUMBER; Commented out as part of Bug# 3542452
48: l_purge_date DATE;
49: l_proc CONSTANT VARCHAR2(30) := 'PURGE_TRANSACTIONS';