DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on FND_PROFILE

Line 28: G_SERVER_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('SERVER_TIMEZONE_ID'));

24: G_NEW CONSTANT VARCHAR2(10) := 'New';
25: G_MODIFY CONSTANT VARCHAR2(10) := 'Modify';
26: G_DELETE CONSTANT VARCHAR2(10) := 'Delete';
27: G_GMT_TIMEZONE_ID CONSTANT NUMBER := 0;
28: G_SERVER_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('SERVER_TIMEZONE_ID'));
29: G_SYNC_SUCCESS CONSTANT NUMBER := 0;
30: G_CLIENT_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('CLIENT_TIMEZONE_ID'));
31:
32: -- Define update_type

Line 30: G_CLIENT_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('CLIENT_TIMEZONE_ID'));

26: G_DELETE CONSTANT VARCHAR2(10) := 'Delete';
27: G_GMT_TIMEZONE_ID CONSTANT NUMBER := 0;
28: G_SERVER_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('SERVER_TIMEZONE_ID'));
29: G_SYNC_SUCCESS CONSTANT NUMBER := 0;
30: G_CLIENT_TIMEZONE_ID CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('CLIENT_TIMEZONE_ID'));
31:
32: -- Define update_type
33: G_UPDATE_ALL CONSTANT VARCHAR2(10) := 'UPDATE_ALL';
34: G_UPDATE_STATUS CONSTANT VARCHAR2(13) := 'UPDATE_STATUS';

Line 48: G_USER_DEFAULT_REPEAT_COUNT CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('JTF_TASK_DEFAULT_REPEAT_COUNT'));

44: G_LOGIN_RESOURCE_ID NUMBER;
45: G_CARRIAGE_RETURN_XML VARCHAR2(6) := ' ';
46: G_CARRIAGE_RETURN_ORACLE VARCHAR2(10) := '
47: ';
48: G_USER_DEFAULT_REPEAT_COUNT CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('JTF_TASK_DEFAULT_REPEAT_COUNT'));
49: --CAC Sync: Include Tasks Without Date -added the profile to check if this profile is yes then bring endless task
50: G_CAC_SYNC_TASK_NO_DATE CONSTANT VARCHAR2(255):= nvl(fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE'),'N');
51: -- The record type to store a group id and resource_type "RS_GROUP"
52: TYPE resource_list_rec IS RECORD (

Line 50: G_CAC_SYNC_TASK_NO_DATE CONSTANT VARCHAR2(255):= nvl(fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE'),'N');

46: G_CARRIAGE_RETURN_ORACLE VARCHAR2(10) := '
47: ';
48: G_USER_DEFAULT_REPEAT_COUNT CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('JTF_TASK_DEFAULT_REPEAT_COUNT'));
49: --CAC Sync: Include Tasks Without Date -added the profile to check if this profile is yes then bring endless task
50: G_CAC_SYNC_TASK_NO_DATE CONSTANT VARCHAR2(255):= nvl(fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE'),'N');
51: -- The record type to store a group id and resource_type "RS_GROUP"
52: TYPE resource_list_rec IS RECORD (
53: resource_id NUMBER,
54: resource_type VARCHAR2(100),