DBA Data[Home] [Help]

APPS.JTF_LOC_AREAS_PVT dependencies on FND_GLOBAL

Line 132: FND_GLOBAL.user_id,

128: VALUES
129: (
130: l_loc_area_rec.location_area_id,
131: SYSDATE,
132: FND_GLOBAL.user_id,
133: SYSDATE,
134: FND_GLOBAL.user_id,
135: 1,
136: FND_GLOBAL.conc_login_id,

Line 134: FND_GLOBAL.user_id,

130: l_loc_area_rec.location_area_id,
131: SYSDATE,
132: FND_GLOBAL.user_id,
133: SYSDATE,
134: FND_GLOBAL.user_id,
135: 1,
136: FND_GLOBAL.conc_login_id,
137: l_loc_area_rec.request_id,
138: l_loc_area_rec.program_application_id,

Line 136: FND_GLOBAL.conc_login_id,

132: FND_GLOBAL.user_id,
133: SYSDATE,
134: FND_GLOBAL.user_id,
135: 1,
136: FND_GLOBAL.conc_login_id,
137: l_loc_area_rec.request_id,
138: l_loc_area_rec.program_application_id,
139: l_loc_area_rec.program_id,
140: l_loc_area_rec.program_update_date,

Line 167: FND_GLOBAL.user_id,

163: SELECT
164: l_loc_area_rec.location_area_id,
165: l.language_code,
166: SYSDATE,
167: FND_GLOBAL.user_id,
168: SYSDATE,
169: FND_GLOBAL.user_id,
170: FND_GLOBAL.conc_login_id,
171: USERENV('LANG'),

Line 169: FND_GLOBAL.user_id,

165: l.language_code,
166: SYSDATE,
167: FND_GLOBAL.user_id,
168: SYSDATE,
169: FND_GLOBAL.user_id,
170: FND_GLOBAL.conc_login_id,
171: USERENV('LANG'),
172: l_loc_area_rec.location_area_name,
173: l_loc_area_rec.location_area_description

Line 170: FND_GLOBAL.conc_login_id,

166: SYSDATE,
167: FND_GLOBAL.user_id,
168: SYSDATE,
169: FND_GLOBAL.user_id,
170: FND_GLOBAL.conc_login_id,
171: USERENV('LANG'),
172: l_loc_area_rec.location_area_name,
173: l_loc_area_rec.location_area_description
174: FROM fnd_languages l

Line 344: last_updated_by = FND_GLOBAL.user_id,

340: END IF;
341:
342: UPDATE JTF_LOC_AREAS_B SET
343: last_update_date = SYSDATE,
344: last_updated_by = FND_GLOBAL.user_id,
345: object_version_number = l_loc_area_rec.object_version_number + 1,
346: last_update_login = FND_GLOBAL.conc_login_id,
347: request_id = l_loc_area_rec.request_id,
348: program_application_id = l_loc_area_rec.program_application_id,

Line 346: last_update_login = FND_GLOBAL.conc_login_id,

342: UPDATE JTF_LOC_AREAS_B SET
343: last_update_date = SYSDATE,
344: last_updated_by = FND_GLOBAL.user_id,
345: object_version_number = l_loc_area_rec.object_version_number + 1,
346: last_update_login = FND_GLOBAL.conc_login_id,
347: request_id = l_loc_area_rec.request_id,
348: program_application_id = l_loc_area_rec.program_application_id,
349: program_id = l_loc_area_rec.program_id,
350: program_update_date = l_loc_area_rec.program_update_date,

Line 371: last_updated_by = FND_GLOBAL.user_id,

367: END IF;
368:
369: UPDATE JTF_LOC_AREAS_TL SET
370: last_update_date = SYSDATE,
371: last_updated_by = FND_GLOBAL.user_id,
372: last_update_login = FND_GLOBAL.conc_login_id,
373: source_lang = USERENV('LANG'),
374: location_area_name = l_loc_area_rec.location_area_name,
375: location_area_description = l_loc_area_rec.location_area_description

Line 372: last_update_login = FND_GLOBAL.conc_login_id,

368:
369: UPDATE JTF_LOC_AREAS_TL SET
370: last_update_date = SYSDATE,
371: last_updated_by = FND_GLOBAL.user_id,
372: last_update_login = FND_GLOBAL.conc_login_id,
373: source_lang = USERENV('LANG'),
374: location_area_name = l_loc_area_rec.location_area_name,
375: location_area_description = l_loc_area_rec.location_area_description
376: WHERE location_area_id = l_loc_area_rec.location_area_id

Line 535: ,last_updated_by = FND_GLOBAL.user_id

531:
532: -- added by julou 24-APR-2001 for bug 1717907/1703508
533: UPDATE jtf_loc_areas_b
534: SET last_update_date = SYSDATE
535: ,last_updated_by = FND_GLOBAL.user_id
536: ,last_update_login = FND_GLOBAL.conc_login_id
537: ,end_date_active = SYSDATE
538: ,object_version_number = object_version_number + 1
539: WHERE location_area_id = p_loc_area_id

Line 536: ,last_update_login = FND_GLOBAL.conc_login_id

532: -- added by julou 24-APR-2001 for bug 1717907/1703508
533: UPDATE jtf_loc_areas_b
534: SET last_update_date = SYSDATE
535: ,last_updated_by = FND_GLOBAL.user_id
536: ,last_update_login = FND_GLOBAL.conc_login_id
537: ,end_date_active = SYSDATE
538: ,object_version_number = object_version_number + 1
539: WHERE location_area_id = p_loc_area_id
540: AND object_version_number = p_object_version;