APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 119: SELECT 'Y' FROM CSM_USER_INVENTORY_ORG

115: );
116:
117: CURSOR c_check_org(b_org_id NUMBER, b_user_id NUMBER)
118: Is
119: SELECT 'Y' FROM CSM_USER_INVENTORY_ORG
120: WHERE ORGANIZATION_ID = b_org_id
121: AND CATEGORY_SET_ID IS NULL
122: AND CATEGORY_ID IS NULL
123: AND TYPE = 'C'

Line 217: UPDATE CSM_USER_INVENTORY_ORG

213: END LOOP;
214: CLOSE c_get_all_items_acc;
215: END IF;--if items for org exist check
216:
217: UPDATE CSM_USER_INVENTORY_ORG
218: SET TYPE = 'C'
219: WHERE CATEGORY_SET_ID IS NULL
220: AND CATEGORY_ID IS NULL
221: AND USER_ID = p_user_id;

Line 512: UPDATE CSM_USER_INVENTORY_ORG

508: END LOOP;
509: CLOSE c_items_Cat_Set_Cat;
510:
511: END IF;
512: UPDATE CSM_USER_INVENTORY_ORG
513: SET TYPE = 'I'
514: WHERE USER_ID = p_user_id;
515: COMMIT;
516:

Line 560: csm_user_inventory_org uorg

556: CURSOR c_changed_org_based( b_last_date DATE)
557: IS
558: SELECT acc.access_id, uorg.user_id
559: FROM csm_mtl_system_items_acc acc,
560: csm_user_inventory_org uorg
561: WHERE acc.organization_id = uorg.organization_id
562: AND uorg.category_set_id IS NULL
563: AND uorg.category_id IS NULL
564: AND acc.USER_ID = -1

Line 572: csm_user_inventory_org uorg

568: AND (msi.last_update_date >= b_last_date))
569: UNION
570: SELECT acc.access_id, uorg.user_id
571: FROM csm_mtl_system_items_acc acc,
572: csm_user_inventory_org uorg
573: WHERE acc.organization_id = uorg.organization_id
574: AND uorg.category_set_id IS NULL
575: AND uorg.category_id IS NULL
576: AND acc.USER_ID = -1

Line 588: csm_user_inventory_org uorg

584: CURSOR c_New_items_for_org
585: IS
586: SELECT acc.access_id, uorg.user_id
587: FROM csm_mtl_system_items_acc acc,
588: csm_user_inventory_org uorg
589: WHERE acc.organization_id = uorg.organization_id
590: AND uorg.category_set_id IS NULL
591: AND uorg.category_id IS NULL
592: AND acc.USER_ID = -2;

Line 600: csm_user_inventory_org uorg

596: CURSOR c_del_org_based( b_last_date DATE)
597: IS
598: SELECT acc.access_id, uorg.user_id
599: FROM csm_mtl_system_items_acc acc,
600: csm_user_inventory_org uorg
601: WHERE acc.organization_id = uorg.organization_id
602: AND uorg.category_set_id IS NULL
603: AND uorg.category_id IS NULL
604: AND acc.USER_ID = -1

Line 699: --Insert newly created Items for allthe user in csm_user_inventory_org

695: END IF;
696: COMMIT;
697: END LOOP;
698: CLOSE c_changed_org_based;
699: --Insert newly created Items for allthe user in csm_user_inventory_org
700:
701: --Do a direct into into the ACC table for user -2
702: INSERT INTO csm_mtl_system_items_acc(access_id, user_id, inventory_item_id, organization_id, counter,
703: created_by, creation_date, last_updated_by, last_update_date, last_update_login)

Line 711: FROM CSM_USER_INVENTORY_ORG uorg

707: WHERE msi.enabled_flag = 'Y'
708: AND SYSDATE BETWEEN nvl(msi.start_date_active, SYSDATE) AND nvl(msi.end_date_active, SYSDATE)
709: AND msi.ORGANIZATION_ID
710: IN(SELECT DISTINCT uorg.ORGANIZATION_ID
711: FROM CSM_USER_INVENTORY_ORG uorg
712: WHERE uorg.category_set_id IS NULL
713: AND uorg.category_id IS NULL)
714: AND NOT EXISTS
715: ( SELECT 1

Line 822: FROM csm_user_inventory_org

818:
819: CURSOR c_get_org_count(b_org_id NUMBER, b_user_id NUMBER)
820: IS
821: SELECT count(*)
822: FROM csm_user_inventory_org
823: WHERE USER_ID <> b_user_id
824: AND ORGANIZATION_ID = b_org_id;
825:
826: l_profile_value VARCHAR2(100);

Line 955: FROM csm_user_inventory_org

951:
952: CURSOR c_org(b_user_id NUMBER)
953: IS
954: SELECT organization_id, category_set_id, category_id
955: FROM csm_user_inventory_org
956: WHERE user_id = b_user_id
957: FOR UPDATE;
958:
959: r_org c_org%ROWTYPE;

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

969:
970: OPEN c_org( p_user_id );
971: FETCH c_org INTO r_org;
972: IF c_org%NOTFOUND THEN -- should not occur
973: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)
974: || ' - Inserting all mtl_system_items',
975: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
976: INSERT INTO csm_user_inventory_org (
977: user_id, organization_id, last_update_date, last_updated_by,

Line 976: INSERT INTO csm_user_inventory_org (

972: IF c_org%NOTFOUND THEN -- should not occur
973: CSM_UTIL_PKG.LOG('Profile record not found in csm_user_inventory_org for user_id: ' || TO_CHAR(p_user_id)
974: || ' - Inserting all mtl_system_items',
975: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
976: INSERT INTO csm_user_inventory_org (
977: user_id, organization_id, last_update_date, last_updated_by,
978: creation_date, created_by, category_set_id, category_id )
979: VALUES (
980: p_user_id, p_organization_id, SYSDATE, 1, SYSDATE, 1,

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

1042: p_category_id=>p_category_id,
1043: p_last_run_date=>NULL,
1044: p_changed=>'Y');
1045:
1046: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
1047: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1048:
1049: UPDATE csm_user_inventory_org
1050: SET organization_id = p_organization_id

Line 1049: UPDATE csm_user_inventory_org

1045:
1046: CSM_UTIL_PKG.LOG('Update csm_user_inventory_org with new profile settings for user_id: ' || TO_CHAR(p_user_id),
1047: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.CONCURRENT_PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
1048:
1049: UPDATE csm_user_inventory_org
1050: SET organization_id = p_organization_id
1051: , category_set_id = p_category_set_id
1052: , category_id = p_category_id
1053: , last_update_date = SYSDATE