DBA Data[Home] [Help]

APPS.JTF_DSP_MSITE_SCT_SECT_PVT dependencies on FND_GLOBAL

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

109: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
110: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
111: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_creation_date),
113: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

110: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
111: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
112: p_creation_date),
113: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
114: NULL, FND_GLOBAL.user_id, p_created_by),
115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

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

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

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

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

115: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
122:
123: OPEN c;

Line 120: NULL, FND_GLOBAL.login_id, p_last_update_login)

116: p_last_update_date),
117: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
118: NULL, FND_GLOBAL.user_id, p_last_updated_by),
119: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
120: NULL, FND_GLOBAL.login_id, p_last_update_login)
121: );
122:
123: OPEN c;
124: FETCH c INTO x_rowid;

Line 170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

166: end_date_active, p_end_date_active),
167: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
168: sysdate, NULL, sysdate, p_last_update_date),
169: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)

Line 173: FND_GLOBAL.login_id, NULL,

169: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)
175: WHERE mini_site_section_section_id = p_mini_site_section_section_id
176: AND object_version_number = decode(p_object_version_number,
177: FND_API.G_MISS_NUM,

Line 174: FND_GLOBAL.login_id, p_last_update_login)

170: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
171: p_last_updated_by),
172: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
173: FND_GLOBAL.login_id, NULL,
174: FND_GLOBAL.login_id, p_last_update_login)
175: WHERE mini_site_section_section_id = p_mini_site_section_section_id
176: AND object_version_number = decode(p_object_version_number,
177: FND_API.G_MISS_NUM,
178: object_version_number,

Line 830: FND_GLOBAL.user_id,

826: p_level_number,
827: p_sort_order,
828: p_concat_ids,
829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,

Line 832: FND_GLOBAL.user_id,

828: p_concat_ids,
829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,
835: x_mini_site_section_section_id
836: );

Line 833: FND_GLOBAL.login_id,

829: SYSDATE,
830: FND_GLOBAL.user_id,
831: SYSDATE,
832: FND_GLOBAL.user_id,
833: FND_GLOBAL.login_id,
834: l_rowid,
835: x_mini_site_section_section_id
836: );
837: EXCEPTION

Line 1055: FND_GLOBAL.user_id,

1051: p_level_number,
1052: p_sort_order,
1053: p_concat_ids,
1054: SYSDATE,
1055: FND_GLOBAL.user_id,
1056: FND_GLOBAL.login_id
1057: );
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN

Line 1056: FND_GLOBAL.login_id

1052: p_sort_order,
1053: p_concat_ids,
1054: SYSDATE,
1055: FND_GLOBAL.user_id,
1056: FND_GLOBAL.login_id
1057: );
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');