DBA Data[Home] [Help]

APPS.AMS_CATEGORY_PVT dependencies on FND_GLOBAL

Line 240: FND_GLOBAL.user_id,

236: ,LEDGER_ID
237: ) VALUES (
238: L_CATEGORY_REC.CATEGORY_ID,
239: SYSDATE,
240: FND_GLOBAL.user_id,
241: SYSDATE,
242: FND_GLOBAL.user_id,
243: FND_GLOBAL.conc_login_id,
244: 1, -- object_version_number

Line 242: FND_GLOBAL.user_id,

238: L_CATEGORY_REC.CATEGORY_ID,
239: SYSDATE,
240: FND_GLOBAL.user_id,
241: SYSDATE,
242: FND_GLOBAL.user_id,
243: FND_GLOBAL.conc_login_id,
244: 1, -- object_version_number
245: L_CATEGORY_REC.ARC_CATEGORY_CREATED_FOR,
246: nvl(L_CATEGORY_REC.ENABLED_FLAG,'Y'),

Line 243: FND_GLOBAL.conc_login_id,

239: SYSDATE,
240: FND_GLOBAL.user_id,
241: SYSDATE,
242: FND_GLOBAL.user_id,
243: FND_GLOBAL.conc_login_id,
244: 1, -- object_version_number
245: L_CATEGORY_REC.ARC_CATEGORY_CREATED_FOR,
246: nvl(L_CATEGORY_REC.ENABLED_FLAG,'Y'),
247: L_CATEGORY_REC.PARENT_CATEGORY_ID,

Line 285: FND_GLOBAL.User_Id,

281: ) SELECT
282: l_category_rec.CATEGORY_NAME,
283: l_category_rec.DESCRIPTION,
284: sysdate,
285: FND_GLOBAL.User_Id,
286: sysdate,
287: FND_GLOBAL.User_Id,
288: FND_GLOBAL.Conc_Login_Id,
289: l_category_rec.category_id,

Line 287: FND_GLOBAL.User_Id,

283: l_category_rec.DESCRIPTION,
284: sysdate,
285: FND_GLOBAL.User_Id,
286: sysdate,
287: FND_GLOBAL.User_Id,
288: FND_GLOBAL.Conc_Login_Id,
289: l_category_rec.category_id,
290: L.LANGUAGE_CODE,
291: userenv('LANG')

Line 288: FND_GLOBAL.Conc_Login_Id,

284: sysdate,
285: FND_GLOBAL.User_Id,
286: sysdate,
287: FND_GLOBAL.User_Id,
288: FND_GLOBAL.Conc_Login_Id,
289: l_category_rec.category_id,
290: L.LANGUAGE_CODE,
291: userenv('LANG')
292: FROM FND_LANGUAGES L

Line 494: LAST_UPDATED_BY = FND_GLOBAL.user_id,

490: IF (l_category_rec.created_by IN (0,1) AND l_category_rec.category_id < 10000) THEN
491: UPDATE AMS_CATEGORIES_B
492: SET
493: LAST_UPDATE_DATE = SYSDATE,
494: LAST_UPDATED_BY = FND_GLOBAL.user_id,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
496: OBJECT_VERSION_NUMBER = L_CATEGORY_REC.OBJECT_VERSION_NUMBER + 1,
497: ENABLED_FLAG = L_CATEGORY_REC.ENABLED_FLAG
498: WHERE

Line 495: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

491: UPDATE AMS_CATEGORIES_B
492: SET
493: LAST_UPDATE_DATE = SYSDATE,
494: LAST_UPDATED_BY = FND_GLOBAL.user_id,
495: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
496: OBJECT_VERSION_NUMBER = L_CATEGORY_REC.OBJECT_VERSION_NUMBER + 1,
497: ENABLED_FLAG = L_CATEGORY_REC.ENABLED_FLAG
498: WHERE
499: CATEGORY_ID = l_category_rec.category_id;

Line 512: LAST_UPDATED_BY = FND_GLOBAL.User_Id,

508:
509: UPDATE AMS_CATEGORIES_TL
510: SET
511: LAST_UPDATE_DATE = sysdate,
512: LAST_UPDATED_BY = FND_GLOBAL.User_Id,
513: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,
514: SOURCE_LANG = userenv('LANG')
515: WHERE
516: CATEGORY_ID = p_category_rec.category_id

Line 513: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,

509: UPDATE AMS_CATEGORIES_TL
510: SET
511: LAST_UPDATE_DATE = sysdate,
512: LAST_UPDATED_BY = FND_GLOBAL.User_Id,
513: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,
514: SOURCE_LANG = userenv('LANG')
515: WHERE
516: CATEGORY_ID = p_category_rec.category_id
517: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 532: LAST_UPDATED_BY = FND_GLOBAL.user_id,

528:
529: UPDATE AMS_CATEGORIES_B
530: SET
531: LAST_UPDATE_DATE = SYSDATE,
532: LAST_UPDATED_BY = FND_GLOBAL.user_id,
533: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
534: OBJECT_VERSION_NUMBER = L_CATEGORY_REC.OBJECT_VERSION_NUMBER + 1,
535: ARC_CATEGORY_CREATED_FOR = L_CATEGORY_REC.ARC_CATEGORY_CREATED_FOR,
536: ENABLED_FLAG = L_CATEGORY_REC.ENABLED_FLAG,

Line 533: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,

529: UPDATE AMS_CATEGORIES_B
530: SET
531: LAST_UPDATE_DATE = SYSDATE,
532: LAST_UPDATED_BY = FND_GLOBAL.user_id,
533: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
534: OBJECT_VERSION_NUMBER = L_CATEGORY_REC.OBJECT_VERSION_NUMBER + 1,
535: ARC_CATEGORY_CREATED_FOR = L_CATEGORY_REC.ARC_CATEGORY_CREATED_FOR,
536: ENABLED_FLAG = L_CATEGORY_REC.ENABLED_FLAG,
537: PARENT_CATEGORY_ID = L_CATEGORY_REC.PARENT_CATEGORY_ID,

Line 574: LAST_UPDATED_BY = FND_GLOBAL.User_Id,

570: SET
571: CATEGORY_NAME = l_category_rec.CATEGORY_NAME,
572: DESCRIPTION = l_category_rec.DESCRIPTION,
573: LAST_UPDATE_DATE = sysdate,
574: LAST_UPDATED_BY = FND_GLOBAL.User_Id,
575: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,
576: SOURCE_LANG = userenv('LANG')
577: WHERE
578: CATEGORY_ID = p_category_rec.category_id

Line 575: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,

571: CATEGORY_NAME = l_category_rec.CATEGORY_NAME,
572: DESCRIPTION = l_category_rec.DESCRIPTION,
573: LAST_UPDATE_DATE = sysdate,
574: LAST_UPDATED_BY = FND_GLOBAL.User_Id,
575: LAST_UPDATE_LOGIN = FND_GLOBAL.Conc_Login_Id,
576: SOURCE_LANG = userenv('LANG')
577: WHERE
578: CATEGORY_ID = p_category_rec.category_id
579: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);