DBA Data[Home] [Help]

APPS.IBE_M_MIGRATION_PVT dependencies on FND_GLOBAL

Line 77: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,

73: WHERE MIGRATION_CODE = p_code;
74: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
75: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
76: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
77: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
78: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);
79: x_status := FND_API.G_RET_STS_SUCCESS;
80: EXCEPTION
81: WHEN OTHERS THEN

Line 78: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);

74: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
75: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
76: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
77: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
78: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);
79: x_status := FND_API.G_RET_STS_SUCCESS;
80: EXCEPTION
81: WHEN OTHERS THEN
82: x_status := FND_API.G_RET_STS_ERROR;

Line 161: VALUES(l_migcode, 0, FND_GLOBAL.user_id, SYSDATE,

157: CLOSE c_get_code;
158: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
159: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
160: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
161: VALUES(l_migcode, 0, FND_GLOBAL.user_id, SYSDATE,
162: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, 'START');
163: ELSE
164: CLOSE c_get_code;
165: END IF;

Line 162: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, 'START');

158: INSERT INTO IBE_MIGRATION_HISTORY(MIGRATION_CODE,
159: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
160: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
161: VALUES(l_migcode, 0, FND_GLOBAL.user_id, SYSDATE,
162: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, 'START');
163: ELSE
164: CLOSE c_get_code;
165: END IF;
166: END IF;

Line 1375: (l_lgl_phys_map_id, 1, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,

1371: LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,MSITE_ID,
1372: LANGUAGE_CODE, ATTACHMENT_ID, ITEM_ID, DEFAULT_LANGUAGE,
1373: DEFAULT_SITE, CONTENT_ITEM_KEY)
1374: VALUES
1375: (l_lgl_phys_map_id, 1, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1376: SYSDATE, FND_GLOBAL.user_id, px_attachment_rec.msite_id,
1377: 'OCM', -1, px_attachment_rec.item_id,
1378: 'Y', px_attachment_rec.default_site, TO_CHAR(l_content_item_id));
1379: END IF;

Line 1376: SYSDATE, FND_GLOBAL.user_id, px_attachment_rec.msite_id,

1372: LANGUAGE_CODE, ATTACHMENT_ID, ITEM_ID, DEFAULT_LANGUAGE,
1373: DEFAULT_SITE, CONTENT_ITEM_KEY)
1374: VALUES
1375: (l_lgl_phys_map_id, 1, FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id,
1376: SYSDATE, FND_GLOBAL.user_id, px_attachment_rec.msite_id,
1377: 'OCM', -1, px_attachment_rec.item_id,
1378: 'Y', px_attachment_rec.default_site, TO_CHAR(l_content_item_id));
1379: END IF;
1380: END IF;