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_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 618: FROM csm_user_inventory_org

614:
615: CURSOR c_org(b_user_id NUMBER)
616: IS
617: SELECT organization_id, category_set_id, category_id
618: FROM csm_user_inventory_org
619: WHERE user_id = b_user_id
620: FOR UPDATE;
621:
622: r_org c_org%ROWTYPE;

Line 632: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)

628: /* Get old profile settings */
629: OPEN c_org( p_user_id );
630: FETCH c_org INTO r_org;
631: IF c_org%NOTFOUND THEN -- should not occur
632: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)
633: || ' - Inserting all mtl_system_items',
634: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
635: get_new_user_mtl_system_items(p_user_id=>p_user_id, p_organization_id=>p_organization_id,
636: p_category_set_id=>p_category_set_id, p_category_id=>p_category_id);

Line 638: INSERT INTO csm_user_inventory_org (

634: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
635: get_new_user_mtl_system_items(p_user_id=>p_user_id, p_organization_id=>p_organization_id,
636: p_category_set_id=>p_category_set_id, p_category_id=>p_category_id);
637:
638: INSERT INTO csm_user_inventory_org (
639: user_id, organization_id, last_update_date, last_updated_by,
640: creation_date, created_by, category_set_id, category_id )
641: VALUES (
642: p_user_id, p_organization_id, SYSDATE, 1, SYSDATE, 1,

Line 704: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),

700: p_category_id=>p_category_id,
701: p_last_run_date=>NULL,
702: p_changed=>'Y');
703:
704: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
705: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
706:
707: UPDATE csm_user_inventory_org
708: SET organization_id = p_organization_id

Line 707: UPDATE csm_user_inventory_org

703:
704: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
705: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
706:
707: UPDATE csm_user_inventory_org
708: SET organization_id = p_organization_id
709: , category_set_id = p_category_set_id
710: , category_id = p_category_id
711: , last_update_date = SYSDATE