DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_CURSORS dependencies on FND_PROFILE

Line 25: G_SYNC_DAYS_BEFORE CONSTANT NUMBER := TO_NUMBER (nvl(fnd_profile.VALUE ('CAC_SYNC_DAYS_BEFORE'),0));

21: *=======================================================================*/
22:
23: -- G_SYNC_DAYS_BEFORE CONSTANT NUMBER := 7;
24:
25: G_SYNC_DAYS_BEFORE CONSTANT NUMBER := TO_NUMBER (nvl(fnd_profile.VALUE ('CAC_SYNC_DAYS_BEFORE'),0));
26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');
27: G_CAC_SYNC_TASK_NO_DATE VARCHAR2(50) := 'FALSE';
28:
29: CURSOR c_new_repeating_task (

Line 26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');

22:
23: -- G_SYNC_DAYS_BEFORE CONSTANT NUMBER := 7;
24:
25: G_SYNC_DAYS_BEFORE CONSTANT NUMBER := TO_NUMBER (nvl(fnd_profile.VALUE ('CAC_SYNC_DAYS_BEFORE'),0));
26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');
27: G_CAC_SYNC_TASK_NO_DATE VARCHAR2(50) := 'FALSE';
28:
29: CURSOR c_new_repeating_task (
30: b_syncanchor DATE,