APPS.JTF_MSITE_PRTY_ACCSS_PKG dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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

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

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

Line 75: NULL, FND_GLOBAL.login_id, p_last_update_login)

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

Line 115: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

111: security_group_id, p_security_group_id),
112: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
113: NULL, sysdate, p_last_update_date),
114: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
115: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
116: p_last_updated_by),
117: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
118: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
119: p_last_update_login)

Line 118: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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