APPS.AS_TAP_PURGE_PUB dependencies on FND_PROFILE

Line 68: nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')),

64:
65: -- Get the cursor limit
66: begin
67: l_cursor_limit :=
68: nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')),
69: G_CURSOR_LIMIT) ;
70: if l_cursor_limit < 1 then
71: l_cursor_limit := G_CURSOR_LIMIT;
72: end if;

Line 146: nvl(TO_NUMBER(fnd_profile.value('AS_TERR_MIN_NUM_PARALLEL_PROC')),100);

142: from AS_ACCESSES_ALL_ALL ABC
143: where delete_flag='Y';
144:
145: l_MinNumParallelProc :=
146: nvl(TO_NUMBER(fnd_profile.value('AS_TERR_MIN_NUM_PARALLEL_PROC')),100);
147: l_NumChildWorker :=
148: nvl(TO_NUMBER(fnd_profile.value('AS_TAP_PURGE_NUM_CHILD_WORKERS')),1);
149: IF l_NumChildWorker < 1 THEN
150: l_NumChildWorker := 1;

Line 148: nvl(TO_NUMBER(fnd_profile.value('AS_TAP_PURGE_NUM_CHILD_WORKERS')),1);

144:
145: l_MinNumParallelProc :=
146: nvl(TO_NUMBER(fnd_profile.value('AS_TERR_MIN_NUM_PARALLEL_PROC')),100);
147: l_NumChildWorker :=
148: nvl(TO_NUMBER(fnd_profile.value('AS_TAP_PURGE_NUM_CHILD_WORKERS')),1);
149: IF l_NumChildWorker < 1 THEN
150: l_NumChildWorker := 1;
151: END IF;
152: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_prg_name || 'Min records for Parallel Processing: '||l_MinNumParallelProc);

Line 256: EXECUTE IMMEDIATE stmt using NVL(to_number(fnd_profile.value('USER_ID')),0),NVL(to_number(fnd_profile.value('USER_ID')),0),

252: :2,
253: :3
254: FROM AS_ACCESSES_ALL_ALL where delete_flag = ''Y''';
255:
256: EXECUTE IMMEDIATE stmt using NVL(to_number(fnd_profile.value('USER_ID')),0),NVL(to_number(fnd_profile.value('USER_ID')),0),
257: NVL(to_number(fnd_profile.value('CONC_LOGIN_ID')),0);
258: X_ActualWorkersUsed := l_ActualWorker;
259: commit;
260: EXECUTE IMMEDIATE 'alter session disable parallel dml';

Line 257: NVL(to_number(fnd_profile.value('CONC_LOGIN_ID')),0);

253: :3
254: FROM AS_ACCESSES_ALL_ALL where delete_flag = ''Y''';
255:
256: EXECUTE IMMEDIATE stmt using NVL(to_number(fnd_profile.value('USER_ID')),0),NVL(to_number(fnd_profile.value('USER_ID')),0),
257: NVL(to_number(fnd_profile.value('CONC_LOGIN_ID')),0);
258: X_ActualWorkersUsed := l_ActualWorker;
259: commit;
260: EXECUTE IMMEDIATE 'alter session disable parallel dml';
261:

Line 306: nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')),

302: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name|| AS_GAR.G_START);
303: -- Get the cursor limit
304: begin
305: l_cursor_limit :=
306: nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')),
307: G_CURSOR_LIMIT) ;
308: if l_cursor_limit < 1 then
309: l_cursor_limit := G_CURSOR_LIMIT;
310: end if;