APPS.JTF_TTY_GEN_TERR_PVT dependencies on FND_GLOBAL

Line 32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;

28: --------------------------------------------------
29:
30: /* Global System Variables */
31: G_Debug BOOLEAN := FALSE;
32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;

Line 33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;

29:
30: /* Global System Variables */
31: G_Debug BOOLEAN := FALSE;
32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;

Line 34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;

30: /* Global System Variables */
31: G_Debug BOOLEAN := FALSE;
32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;
38: G_SYSDATE DATE := SYSDATE;

Line 35: G_USER_ID NUMBER := FND_GLOBAL.user_id;

31: G_Debug BOOLEAN := FALSE;
32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;
38: G_SYSDATE DATE := SYSDATE;
39: G_JTF_SCHEMA VARCHAR2(20) := 'JTF';

Line 36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;

32: G_APPL_ID NUMBER := FND_GLOBAL.prog_appl_id;
33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;
38: G_SYSDATE DATE := SYSDATE;
39: G_JTF_SCHEMA VARCHAR2(20) := 'JTF';
40: G_CUTOFF_TIME DATE;

Line 37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;

33: G_LOGIN_ID NUMBER := FND_GLOBAL.conc_login_id;
34: G_PROGRAM_ID NUMBER := FND_GLOBAL.conc_program_id;
35: G_USER_ID NUMBER := FND_GLOBAL.user_id;
36: G_REQUEST_ID NUMBER := FND_GLOBAL.conc_request_id;
37: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.application_short_name;
38: G_SYSDATE DATE := SYSDATE;
39: G_JTF_SCHEMA VARCHAR2(20) := 'JTF';
40: G_CUTOFF_TIME DATE;
41: G_COMMIT_CHUNK_SIZE NUMBER := 50000;

Line 12946: l_user_id := fnd_global.user_id;

12942:
12943: l_init_msg_list :=FND_API.G_TRUE;
12944: i := 0;
12945: a := 0;
12946: l_user_id := fnd_global.user_id;
12947: l_login_id := fnd_global.login_id;
12948:
12949: OPEN c_get_terr_dtls (p_terr_grp_acct_id);
12950: FETCH c_get_terr_dtls INTO l_terr_id, l_org_id, l_start_date, l_end_date;

Line 12947: l_login_id := fnd_global.login_id;

12943: l_init_msg_list :=FND_API.G_TRUE;
12944: i := 0;
12945: a := 0;
12946: l_user_id := fnd_global.user_id;
12947: l_login_id := fnd_global.login_id;
12948:
12949: OPEN c_get_terr_dtls (p_terr_grp_acct_id);
12950: FETCH c_get_terr_dtls INTO l_terr_id, l_org_id, l_start_date, l_end_date;
12951: CLOSE c_get_terr_dtls;