APPS.LNS_UTILITY_PUB dependencies on FND_GLOBAL

Line 27: RETURN NVL(FND_GLOBAL.user_id,-1);

23:
24: FUNCTION created_by RETURN NUMBER IS
25: BEGIN
26:
27: RETURN NVL(FND_GLOBAL.user_id,-1);
28:
29: END created_by;
30:
31: FUNCTION creation_date RETURN DATE IS

Line 41: RETURN NVL(FND_GLOBAL.user_id,-1);

37:
38: FUNCTION last_updated_by RETURN NUMBER IS
39: BEGIN
40:
41: RETURN NVL(FND_GLOBAL.user_id,-1);
42:
43: END last_updated_by;
44:
45: FUNCTION last_update_date RETURN DATE IS

Line 55: IF FND_GLOBAL.conc_login_id = -1 OR

51:
52: FUNCTION last_update_login RETURN NUMBER IS
53: BEGIN
54:
55: IF FND_GLOBAL.conc_login_id = -1 OR
56: FND_GLOBAL.conc_login_id IS NULL
57: THEN
58: RETURN FND_GLOBAL.login_id;
59: ELSE

Line 56: FND_GLOBAL.conc_login_id IS NULL

52: FUNCTION last_update_login RETURN NUMBER IS
53: BEGIN
54:
55: IF FND_GLOBAL.conc_login_id = -1 OR
56: FND_GLOBAL.conc_login_id IS NULL
57: THEN
58: RETURN FND_GLOBAL.login_id;
59: ELSE
60: RETURN FND_GLOBAL.conc_login_id;

Line 58: RETURN FND_GLOBAL.login_id;

54:
55: IF FND_GLOBAL.conc_login_id = -1 OR
56: FND_GLOBAL.conc_login_id IS NULL
57: THEN
58: RETURN FND_GLOBAL.login_id;
59: ELSE
60: RETURN FND_GLOBAL.conc_login_id;
61: END IF;
62:

Line 60: RETURN FND_GLOBAL.conc_login_id;

56: FND_GLOBAL.conc_login_id IS NULL
57: THEN
58: RETURN FND_GLOBAL.login_id;
59: ELSE
60: RETURN FND_GLOBAL.conc_login_id;
61: END IF;
62:
63: END last_update_login;
64:

Line 68: IF FND_GLOBAL.conc_request_id = -1 OR

64:
65: FUNCTION request_id RETURN NUMBER IS
66: BEGIN
67:
68: IF FND_GLOBAL.conc_request_id = -1 OR
69: FND_GLOBAL.conc_request_id IS NULL
70: THEN
71: RETURN NULL;
72: ELSE

Line 69: FND_GLOBAL.conc_request_id IS NULL

65: FUNCTION request_id RETURN NUMBER IS
66: BEGIN
67:
68: IF FND_GLOBAL.conc_request_id = -1 OR
69: FND_GLOBAL.conc_request_id IS NULL
70: THEN
71: RETURN NULL;
72: ELSE
73: RETURN FND_GLOBAL.conc_request_id;

Line 73: RETURN FND_GLOBAL.conc_request_id;

69: FND_GLOBAL.conc_request_id IS NULL
70: THEN
71: RETURN NULL;
72: ELSE
73: RETURN FND_GLOBAL.conc_request_id;
74: END IF;
75:
76: END request_id;
77:

Line 81: IF FND_GLOBAL.conc_program_id = -1 OR

77:
78: FUNCTION program_id RETURN NUMBER IS
79: BEGIN
80:
81: IF FND_GLOBAL.conc_program_id = -1 OR
82: FND_GLOBAL.conc_program_id IS NULL
83: THEN
84: RETURN NULL;
85: ELSE

Line 82: FND_GLOBAL.conc_program_id IS NULL

78: FUNCTION program_id RETURN NUMBER IS
79: BEGIN
80:
81: IF FND_GLOBAL.conc_program_id = -1 OR
82: FND_GLOBAL.conc_program_id IS NULL
83: THEN
84: RETURN NULL;
85: ELSE
86: RETURN FND_GLOBAL.conc_program_id;

Line 86: RETURN FND_GLOBAL.conc_program_id;

82: FND_GLOBAL.conc_program_id IS NULL
83: THEN
84: RETURN NULL;
85: ELSE
86: RETURN FND_GLOBAL.conc_program_id;
87: END IF;
88:
89: END program_id;
90:

Line 94: IF FND_GLOBAL.prog_appl_id = -1 OR

90:
91: FUNCTION program_application_id RETURN NUMBER IS
92: BEGIN
93:
94: IF FND_GLOBAL.prog_appl_id = -1 OR
95: FND_GLOBAL.prog_appl_id IS NULL
96: THEN
97: RETURN NULL;
98: ELSE

Line 95: FND_GLOBAL.prog_appl_id IS NULL

91: FUNCTION program_application_id RETURN NUMBER IS
92: BEGIN
93:
94: IF FND_GLOBAL.prog_appl_id = -1 OR
95: FND_GLOBAL.prog_appl_id IS NULL
96: THEN
97: RETURN NULL;
98: ELSE
99: RETURN FND_GLOBAL.prog_appl_id;

Line 99: RETURN FND_GLOBAL.prog_appl_id;

95: FND_GLOBAL.prog_appl_id IS NULL
96: THEN
97: RETURN NULL;
98: ELSE
99: RETURN FND_GLOBAL.prog_appl_id;
100: END IF;
101:
102: END program_application_id;
103:

Line 107: IF FND_GLOBAL.resp_appl_id = -1 OR

103:
104: FUNCTION application_id RETURN NUMBER IS
105: BEGIN
106:
107: IF FND_GLOBAL.resp_appl_id = -1 OR
108: FND_GLOBAL.resp_appl_id IS NULL
109: THEN
110: RETURN NULL;
111: ELSE

Line 108: FND_GLOBAL.resp_appl_id IS NULL

104: FUNCTION application_id RETURN NUMBER IS
105: BEGIN
106:
107: IF FND_GLOBAL.resp_appl_id = -1 OR
108: FND_GLOBAL.resp_appl_id IS NULL
109: THEN
110: RETURN NULL;
111: ELSE
112: RETURN FND_GLOBAL.resp_appl_id;

Line 112: RETURN FND_GLOBAL.resp_appl_id;

108: FND_GLOBAL.resp_appl_id IS NULL
109: THEN
110: RETURN NULL;
111: ELSE
112: RETURN FND_GLOBAL.resp_appl_id;
113: END IF;
114:
115: END application_id;
116:

Line 131: RETURN NVL(FND_GLOBAL.user_id,-1);

127:
128: FUNCTION user_id RETURN NUMBER IS
129: BEGIN
130:
131: RETURN NVL(FND_GLOBAL.user_id,-1);
132:
133: END user_id;
134:
135: PROCEDURE Validate_any_id(p_api_version IN NUMBER := 1.0,

Line 930: and res.user_id = fnd_global.user_id;

926: manager.role_resource_id(+) = res.resource_id
927: and category = 'EMPLOYEE'
928: and res.start_date_active <= sysdate
929: and (res.end_date_active is null or res.end_date_active >= sysdate)
930: and res.user_id = fnd_global.user_id;
931:
932: return l_loan_manager_flag ;
933:
934: