eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_USER_EVENT_PKG dependencies on CSM_PROFILE_PKG

Line 212: ( jt.creation_date BETWEEN SYSDATE AND (SYSDATE - csm_profile_pkg.get_task_history_days(b_user_id))

208: jtf_task_statuses_b jts
209: WHERE jt.created_by = b_user_id
210: AND jts.task_status_id = jt.task_status_id
211: AND ( --task which are closed and within history days
212: ( jt.creation_date BETWEEN SYSDATE AND (SYSDATE - csm_profile_pkg.get_task_history_days(b_user_id))
213: AND ( NVL(jts.cancelled_flag,'N') = 'Y' OR NVL(jts.closed_flag,'N') = 'Y'
214: OR NVL(jts.rejected_flag,'N') = 'Y' OR NVL(jts.completed_flag, 'N') = 'Y'
215: )
216: )

Line 408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);

404: BEGIN
405: CSM_UTIL_PKG.LOG('Entering items_acc_processor for user_id: ' || p_user_id,
406: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);
407:
408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);
410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);
411:
412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;

Line 409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);

405: CSM_UTIL_PKG.LOG('Entering items_acc_processor for user_id: ' || p_user_id,
406: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);
407:
408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);
410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);
411:
412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;
413:

Line 410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);

406: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);
407:
408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);
410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);
411:
412: DELETE FROM csm_user_inventory_org WHERE user_id = p_user_id;
413:
414: INSERT INTO csm_user_inventory_org (

Line 1012: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);

1008: BEGIN
1009: CSM_UTIL_PKG.LOG('Entering spawn_mtl_serial_numbers for User_id ' || p_user_id,
1010: 'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_PROCEDURE);
1011:
1012: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
1013:
1014: --get all the serial numbers for the User
1015: CSM_SERIAL_NUMBERS_EVENT_PKG.insert_mtl_serial_numbers(l_organization_id,TO_DATE('1','J'),p_resource_id,p_user_id);
1016: