DBA Data[Home] [Help]

APPS.IBE_PHYSICALMAP_GRP dependencies on FND_GLOBAL

Line 179: FND_GLOBAL.user_id,

175: ) VALUES (
176: l_lgl_phys_map_id,
177: 1,
178: SYSDATE,
179: FND_GLOBAL.user_id,
180: SYSDATE,
181: FND_GLOBAL.user_id,
182: FND_GLOBAL.login_id,
183: l_msite_id,

Line 181: FND_GLOBAL.user_id,

177: 1,
178: SYSDATE,
179: FND_GLOBAL.user_id,
180: SYSDATE,
181: FND_GLOBAL.user_id,
182: FND_GLOBAL.login_id,
183: l_msite_id,
184: l_language_code,
185: p_attachment_id,

Line 182: FND_GLOBAL.login_id,

178: SYSDATE,
179: FND_GLOBAL.user_id,
180: SYSDATE,
181: FND_GLOBAL.user_id,
182: FND_GLOBAL.login_id,
183: l_msite_id,
184: l_language_code,
185: p_attachment_id,
186: l_deliverable_id,

Line 227: FND_GLOBAL.user_id,

223: ) VALUES (
224: l_lgl_phys_map_id,
225: 1,
226: SYSDATE,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: FND_GLOBAL.login_id,
231: l_msite_id,

Line 229: FND_GLOBAL.user_id,

225: 1,
226: SYSDATE,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: FND_GLOBAL.login_id,
231: l_msite_id,
232: p_language_code_tbl(l_index),
233: p_attachment_id,

Line 230: FND_GLOBAL.login_id,

226: SYSDATE,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: FND_GLOBAL.login_id,
231: l_msite_id,
232: p_language_code_tbl(l_index),
233: p_attachment_id,
234: l_deliverable_id,

Line 1328: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,

1324: last_update_login, msite_id, language_code,
1325: attachment_id, item_id, default_site,
1326: default_language, content_item_key)
1327: VALUES(l_lgl_phys_map_id, 1, SYSDATE,
1328: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1329: FND_GLOBAL.login_id, l_msite_id, l_language_code,
1330: l_attachment_id, l_deliverable_id, l_default_msite,
1331: l_default_lang, l_content_item_key);
1332: ELSE -- update the seeded mapping

Line 1329: FND_GLOBAL.login_id, l_msite_id, l_language_code,

1325: attachment_id, item_id, default_site,
1326: default_language, content_item_key)
1327: VALUES(l_lgl_phys_map_id, 1, SYSDATE,
1328: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1329: FND_GLOBAL.login_id, l_msite_id, l_language_code,
1330: l_attachment_id, l_deliverable_id, l_default_msite,
1331: l_default_lang, l_content_item_key);
1332: ELSE -- update the seeded mapping
1333: IF((l_ocm_integration IS NOT NULL)

Line 1342: last_updated_by = FND_GLOBAL.user_id,

1338: SET attachment_id = l_attachment_id,
1339: content_item_key = l_content_item_key,
1340: object_version_number = l_object_version_number+1,
1341: last_update_date = SYSDATE,
1342: last_updated_by = FND_GLOBAL.user_id,
1343: last_update_login = FND_GLOBAL.login_id
1344: WHERE lgl_phys_map_id = l_seed_lgl_phys_map_id;
1345: END IF;
1346: END IF;

Line 1343: last_update_login = FND_GLOBAL.login_id

1339: content_item_key = l_content_item_key,
1340: object_version_number = l_object_version_number+1,
1341: last_update_date = SYSDATE,
1342: last_updated_by = FND_GLOBAL.user_id,
1343: last_update_login = FND_GLOBAL.login_id
1344: WHERE lgl_phys_map_id = l_seed_lgl_phys_map_id;
1345: END IF;
1346: END IF;
1347: ELSE

Line 1374: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,

1370: last_update_login, msite_id, language_code,
1371: attachment_id, item_id, default_site,
1372: default_language, content_item_key)
1373: VALUES(l_lgl_phys_map_id, 1, SYSDATE,
1374: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1375: FND_GLOBAL.login_id, l_msite_id, l_language_code,
1376: l_attachment_id, l_deliverable_id, l_default_msite,
1377: l_default_lang, l_content_item_key);
1378: EXCEPTION

Line 1375: FND_GLOBAL.login_id, l_msite_id, l_language_code,

1371: attachment_id, item_id, default_site,
1372: default_language, content_item_key)
1373: VALUES(l_lgl_phys_map_id, 1, SYSDATE,
1374: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1375: FND_GLOBAL.login_id, l_msite_id, l_language_code,
1376: l_attachment_id, l_deliverable_id, l_default_msite,
1377: l_default_lang, l_content_item_key);
1378: EXCEPTION
1379: WHEN FND_API.g_exc_error THEN

Line 1564: last_updated_by = FND_GLOBAL.user_id,

1560: l_attachment_id := TO_NUMBER(p_new_content_key);
1561: UPDATE IBE_DSP_LGL_PHYS_MAP
1562: set attachment_id = l_attachment_id,
1563: last_update_date = SYSDATE,
1564: last_updated_by = FND_GLOBAL.user_id,
1565: last_update_login = FND_GLOBAL.login_id
1566: WHERE ((attachment_id = l_old_attachment_id)
1567: AND (item_id = p_deliverable_id)
1568: AND (content_item_key is null));

Line 1565: last_update_login = FND_GLOBAL.login_id

1561: UPDATE IBE_DSP_LGL_PHYS_MAP
1562: set attachment_id = l_attachment_id,
1563: last_update_date = SYSDATE,
1564: last_updated_by = FND_GLOBAL.user_id,
1565: last_update_login = FND_GLOBAL.login_id
1566: WHERE ((attachment_id = l_old_attachment_id)
1567: AND (item_id = p_deliverable_id)
1568: AND (content_item_key is null));
1569: END IF;