DBA Data[Home] [Help]

APPS.AHL_OSP_ACCOMP_PVT dependencies on FND_GLOBAL

Line 621: LAST_UPDATED_BY = FND_GLOBAL.user_id,

617: SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
618: STATUS_CODE = 'ACCOMPLISHED',
619: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
620: LAST_UPDATE_DATE = SYSDATE,
621: LAST_UPDATED_BY = FND_GLOBAL.user_id,
622: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
623: WHERE ACCOMPLISHMENT_ID = l_accomplishment_ids_tbl(i);
624:
625: CLOSE get_accomplishment_dtls_csr;

Line 622: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

618: STATUS_CODE = 'ACCOMPLISHED',
619: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
620: LAST_UPDATE_DATE = SYSDATE,
621: LAST_UPDATED_BY = FND_GLOBAL.user_id,
622: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
623: WHERE ACCOMPLISHMENT_ID = l_accomplishment_ids_tbl(i);
624:
625: CLOSE get_accomplishment_dtls_csr;
626:

Line 654: FND_GLOBAL.user_id,

650: ACCOMPLISHED_DATE)
651: VALUES (AHL_OSP_ACCOMPLISHMENTS_S.NEXTVAL,
652: 1,
653: SYSDATE,
654: FND_GLOBAL.user_id,
655: SYSDATE,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.login_id,
658: NVL(p_osp_order_line_id, l_osp_order_line_id),

Line 656: FND_GLOBAL.user_id,

652: 1,
653: SYSDATE,
654: FND_GLOBAL.user_id,
655: SYSDATE,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.login_id,
658: NVL(p_osp_order_line_id, l_osp_order_line_id),
659: l_instance_ids_tbl(j),
660: l_child_ue_ids_tbl(j),

Line 657: FND_GLOBAL.login_id,

653: SYSDATE,
654: FND_GLOBAL.user_id,
655: SYSDATE,
656: FND_GLOBAL.user_id,
657: FND_GLOBAL.login_id,
658: NVL(p_osp_order_line_id, l_osp_order_line_id),
659: l_instance_ids_tbl(j),
660: l_child_ue_ids_tbl(j),
661: l_mr_ids_tbl(j),