APPS.JTF_MSITE_RESP_PKG dependencies on FND_GLOBAL

Line 75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 76: NULL, FND_GLOBAL.user_id, p_created_by),

72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );

Line 80: NULL, FND_GLOBAL.user_id, p_last_updated_by),

76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );
84:

Line 81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );
84:
85: OPEN c;

Line 82: NULL, FND_GLOBAL.login_id, p_last_update_login)

78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );
84:
85: OPEN c;
86: FETCH c INTO x_rowid;

Line 112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

108: )
109: SELECT
110: x_msite_resp_id,
111: p_object_version_number,
112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 113: NULL, FND_GLOBAL.user_id, p_created_by),

109: SELECT
110: x_msite_resp_id,
111: p_object_version_number,
112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),

Line 116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 117: NULL, FND_GLOBAL.user_id, p_last_updated_by),

113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),

Line 120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),
122: p_display_name,
123: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL,
124: p_security_group_id),

Line 121: NULL, FND_GLOBAL.login_id, p_last_update_login),

117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),
122: p_display_name,
123: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL,
124: p_security_group_id),
125: L.language_code,

Line 175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

171: security_group_id, p_security_group_id),
172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
173: NULL, sysdate, p_last_update_date),
174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)

Line 178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE msite_resp_id = p_msite_resp_id
181: AND object_version_number = decode(p_object_version_number,
182: FND_API.G_MISS_NUM,

Line 197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

193: display_name, p_display_name),
194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
195: NULL, sysdate, p_last_update_date),
196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
198: p_last_updated_by),
199: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
200: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
201: p_last_update_login),

Line 200: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
198: p_last_updated_by),
199: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
200: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
201: p_last_update_login),
202: source_lang = USERENV('LANG')
203: WHERE msite_resp_id = p_msite_resp_id
204: --AND object_version_number = decode(p_object_version_number,