APPS.IBE_MSITE_PRTY_ACCSS_PKG dependencies on FND_GLOBAL

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

65: p_start_date_active,
66: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
67: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
68: p_creation_date),
69: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
70: NULL, FND_GLOBAL.user_id, p_created_by),
71: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

66: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
67: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
68: p_creation_date),
69: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
70: NULL, FND_GLOBAL.user_id, p_created_by),
71: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
74: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

69: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
70: NULL, FND_GLOBAL.user_id, p_created_by),
71: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
74: NULL, FND_GLOBAL.user_id, p_last_updated_by),
75: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
76: NULL, FND_GLOBAL.login_id, p_last_update_login)
77: );

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

70: NULL, FND_GLOBAL.user_id, p_created_by),
71: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
74: NULL, FND_GLOBAL.user_id, p_last_updated_by),
75: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
76: NULL, FND_GLOBAL.login_id, p_last_update_login)
77: );
78:

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

71: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
74: NULL, FND_GLOBAL.user_id, p_last_updated_by),
75: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
76: NULL, FND_GLOBAL.login_id, p_last_update_login)
77: );
78:
79: OPEN c;

Line 76: NULL, FND_GLOBAL.login_id, p_last_update_login)

72: p_last_update_date),
73: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
74: NULL, FND_GLOBAL.user_id, p_last_updated_by),
75: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
76: NULL, FND_GLOBAL.login_id, p_last_update_login)
77: );
78:
79: OPEN c;
80: FETCH c INTO x_rowid;

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

109: end_date_active, p_end_date_active),
110: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
111: NULL, sysdate, p_last_update_date),
112: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
113: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
114: p_last_updated_by),
115: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
116: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
117: p_last_update_login)

Line 116: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

112: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
113: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
114: p_last_updated_by),
115: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
116: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
117: p_last_update_login)
118: WHERE msite_prty_accss_id = p_msite_prty_accss_id
119: AND object_version_number = decode(p_object_version_number,
120: FND_API.G_MISS_NUM,