APPS.JTF_TTY_GEOSOURCE_PUB dependencies on FND_GLOBAL

Line 49: p_user_id := fnd_global.user_id;

45: p_geo_type_exists_flag VARCHAR2(1) DEFAULT 'Y';
46: p_user_id NUMBER;
47: p_date DATE;
48: BEGIN
49: p_user_id := fnd_global.user_id;
50: p_date := sysdate;
51: BEGIN
52: SELECT 'Y'
53: into p_geo_type_exists_flag

Line 328: p_user_id := fnd_global.user_id;

324: p_exists_flag VARCHAR2(1) DEFAULT 'Y';
325: p_user_id NUMBER;
326: p_date DATE;
327: BEGIN
328: p_user_id := fnd_global.user_id;
329: p_date := sysdate;
330:
331: -- do validations
332: x_return_status := fnd_api.g_ret_sts_success;

Line 408: p_user_id := fnd_global.user_id;

404: p_exists_flag VARCHAR2(1) DEFAULT 'Y';
405: p_user_id NUMBER;
406: p_date DATE;
407: BEGIN
408: p_user_id := fnd_global.user_id;
409: p_date := sysdate;
410: BEGIN
411: SELECT 'Y'
412: INTO p_exists_flag