DBA Data[Home] [Help]

APPS.INVIDIT2 dependencies on MTL_ITEM_CATEGORIES

Line 7: -- insert into mtl_item_categories

3:
4: -- After inserting an item:
5: -- insert into mtl_pending_item_status
6: -- insert into mtl_item_revisions
7: -- insert into mtl_item_categories
8: -- call CSTPIICI to insert into cst_item_costs
9: -- insert into mtl_uom_conversions
10: -- Call other procedures passing event='INSERT'
11:

Line 14: -- insert into mtl_item_categories

10: -- Call other procedures passing event='INSERT'
11:
12: -- After updating an item:
13: -- insert into mtl_pending_item_status
14: -- insert into mtl_item_categories
15: -- insert into mtl_uom_conversions
16: -- Call other procedures passing event = 'UPDATE'
17:
18: -- After assigning the item to a child org:

Line 19: -- delete from mtl_item_categories

15: -- insert into mtl_uom_conversions
16: -- Call other procedures passing event = 'UPDATE'
17:
18: -- After assigning the item to a child org:
19: -- delete from mtl_item_categories
20: -- insert into mtl_item_categories
21: -- insert into mtl_pending_item_status
22: -- insert into mtl_item_revisions
23: -- call CSTPIICI to insert into cst_item_costs

Line 20: -- insert into mtl_item_categories

16: -- Call other procedures passing event = 'UPDATE'
17:
18: -- After assigning the item to a child org:
19: -- delete from mtl_item_categories
20: -- insert into mtl_item_categories
21: -- insert into mtl_pending_item_status
22: -- insert into mtl_item_revisions
23: -- call CSTPIICI to insert into cst_item_costs
24: -- Call other procedures passing event = 'ORG_ASSIGN'

Line 28: -- insert into mtl_item_categories

24: -- Call other procedures passing event = 'ORG_ASSIGN'
25:
26: -- After updating item/org attributes:
27: -- insert into mtl_pending_item_status
28: -- insert into mtl_item_categories
29: -- insert into mtl_uom_conversions
30: -- Call other procedures passing event = 'ITEM_ORG'
31:
32: l_cat_ins_upd BOOLEAN := FALSE; --* Added for Bug 4491340

Line 614: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;

610: , p_Folder_Item_Category_id IN NUMBER
611: , X_last_updated_by NUMBER
612: )
613: IS
614: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;
615: TYPE CATSET_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_SET_ID%TYPE;
616: TYPE CAT_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
617:
618: l_organizations_rec ORG_LISTS;

Line 615: TYPE CATSET_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_SET_ID%TYPE;

611: , X_last_updated_by NUMBER
612: )
613: IS
614: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;
615: TYPE CATSET_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_SET_ID%TYPE;
616: TYPE CAT_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
617:
618: l_organizations_rec ORG_LISTS;
619: l_category_sets_rec CATSET_LISTS;

Line 616: TYPE CAT_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;

612: )
613: IS
614: TYPE ORG_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.ORGANIZATION_ID%TYPE;
615: TYPE CATSET_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_SET_ID%TYPE;
616: TYPE CAT_LISTS IS TABLE OF MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
617:
618: l_organizations_rec ORG_LISTS;
619: l_category_sets_rec CATSET_LISTS;
620: l_categories_rec CAT_LISTS;

Line 647: FROM mtl_item_categories

643: , p_category_set_id NUMBER
644: , p_category_id NUMBER
645: ) IS
646: SELECT COUNT( category_id ), COUNT( DECODE(category_id, p_category_id, 1, NULL) )
647: FROM mtl_item_categories
648: WHERE
649: inventory_item_id = p_inventory_item_id
650: AND organization_id = p_organization_id
651: AND category_set_id = p_category_set_id;

Line 658: FROM mtl_item_categories

654: ,cp_item_id NUMBER)
655: IS
656: SELECT category_set_id
657: ,category_id
658: FROM mtl_item_categories
659: WHERE organization_id = cp_org_id
660: AND inventory_item_id = cp_item_id;
661:
662: l_return_status VARCHAR2(1);

Line 754: INSERT INTO mtl_item_categories

750: -- on the item current assignments.
751:
752: IF ( l_the_item_assign_count = 0 ) THEN
753:
754: INSERT INTO mtl_item_categories
755: (
756: inventory_item_id
757: , organization_id
758: , category_set_id

Line 804: FROM mtl_item_categories mic

800: WHERE
801: -- Check if the item already has a category assignment in this category set
802: NOT EXISTS
803: ( SELECT 'x'
804: FROM mtl_item_categories mic
805: WHERE
806: mic.inventory_item_id = X_item_id
807: AND mic.organization_id = X_org_id
808: AND mic.category_set_id = p_Folder_Category_Set_id

Line 817: UPDATE mtl_item_categories

813:
814: ELSIF ( l_the_item_assign_count = 1
815: AND l_the_cat_assign_count = 0 ) THEN
816:
817: UPDATE mtl_item_categories
818: SET
819: category_id = p_Folder_Item_Category_id
820: , last_update_date = SYSDATE
821: , last_updated_by = X_last_updated_by

Line 829: FROM mtl_item_categories mic

825: AND organization_id = X_org_id
826: AND category_set_id = p_Folder_Category_Set_id
827: AND category_id =
828: ( SELECT mic.category_id
829: FROM mtl_item_categories mic
830: WHERE
831: mic.inventory_item_id = X_item_id
832: AND mic.organization_id = X_org_id
833: AND mic.category_set_id = p_Folder_Category_Set_id

Line 892: FROM mtl_item_categories mic

888: )
889: -- Check if the item already has any category assignment
890: AND NOT EXISTS
891: ( SELECT 'x'
892: FROM mtl_item_categories mic
893: WHERE
894: mic.inventory_item_id = X_item_id
895: AND mic.organization_id = p.organization_id
896: AND mic.category_set_id = s.category_set_id);

Line 899: INSERT INTO mtl_item_categories(

895: AND mic.organization_id = p.organization_id
896: AND mic.category_set_id = s.category_set_id);
897:
898: FORALL I in l_organizations_rec.FIRST .. l_organizations_rec.LAST
899: INSERT INTO mtl_item_categories(
900: inventory_item_id
901: ,organization_id
902: ,category_set_id
903: ,category_id

Line 988: FROM mtl_item_categories mic

984: AND s.default_category_id IS NOT NULL --Bug: 2801594
985: -- Check if the item already has any category assignment
986: AND NOT EXISTS
987: ( SELECT 'x'
988: FROM mtl_item_categories mic
989: WHERE
990: mic.inventory_item_id = X_item_id
991: AND mic.organization_id = X_org_id
992: AND mic.category_set_id = s.category_set_id

Line 997: INSERT INTO mtl_item_categories(

993: );
994:
995:
996: FORALL I IN l_categories_rec.FIRST .. l_categories_rec.LAST
997: INSERT INTO mtl_item_categories(
998: inventory_item_id
999: ,organization_id
1000: ,category_set_id,
1001: category_id,

Line 1079: FROM mtl_item_categories mic

1075: )
1076: -- Check if org item already has a category assignment in this category set
1077: AND NOT EXISTS
1078: ( SELECT 'x'
1079: FROM mtl_item_categories mic
1080: WHERE
1081: mic.inventory_item_id = X_item_id
1082: AND mic.organization_id = p.organization_id
1083: AND mic.category_set_id = p_Folder_Category_Set_id

Line 1087: INSERT INTO mtl_item_categories(

1083: AND mic.category_set_id = p_Folder_Category_Set_id
1084: );
1085:
1086: FORALL I in l_organizations_rec.FIRST .. l_organizations_rec.LAST
1087: INSERT INTO mtl_item_categories(
1088: inventory_item_id
1089: ,organization_id
1090: ,category_set_id
1091: ,category_id

Line 1135: UPDATE mtl_item_categories

1131:
1132: ELSIF ( l_the_item_assign_count = 1
1133: AND l_the_cat_assign_count = 0 ) THEN
1134:
1135: UPDATE mtl_item_categories
1136: SET
1137: category_id = p_Folder_Item_Category_id
1138: , last_update_date = SYSDATE
1139: , last_updated_by = X_last_updated_by

Line 1228: FROM mtl_item_categories mic

1224: )
1225: -- Check if the item already has any category assignment
1226: AND NOT EXISTS
1227: ( SELECT 'x'
1228: FROM mtl_item_categories mic
1229: WHERE
1230: mic.inventory_item_id = X_item_id
1231: AND mic.organization_id = p.organization_id
1232: AND mic.category_set_id = s.category_set_id

Line 1245: INSERT INTO mtl_item_categories

1241: AND org_information2 = 'Y'
1242: AND org_information_context || '' = 'CLASS');
1243:
1244: FORALL I IN l_categories_rec.FIRST .. l_categories_rec.LAST
1245: INSERT INTO mtl_item_categories
1246: (
1247: inventory_item_id
1248: ,organization_id
1249: ,category_set_id,

Line 1306: INSERT INTO mtl_item_categories(

1302: AND p_Folder_Item_Category_id IS NOT NULL ) THEN
1303:
1304: -- INSERT or UPDATE folder item category assignment, depending
1305:
1306: INSERT INTO mtl_item_categories(
1307: inventory_item_id
1308: ,organization_id
1309: ,category_set_id
1310: ,category_id

Line 1336: , mtl_item_categories c

1332: sysdate,
1333: -1
1334: FROM
1335: mtl_category_sets_b s
1336: , mtl_item_categories c
1337: WHERE
1338: c.inventory_item_id = X_item_id
1339: AND c.organization_id = X_master_org_id
1340: AND c.category_set_id = p_Folder_Category_Set_id

Line 1347: FROM mtl_item_categories mic

1343: AND s.control_level = 1
1344: -- Check if the item already has a category assignment in this category set
1345: AND NOT EXISTS
1346: ( SELECT 'x'
1347: FROM mtl_item_categories mic
1348: WHERE
1349: mic.inventory_item_id = X_item_id
1350: AND mic.organization_id = X_org_id
1351: AND mic.category_set_id = p_Folder_Category_Set_id

Line 1380: , mtl_item_categories c

1376: l_category_sets_rec
1377: ,l_categories_rec
1378: FROM
1379: mtl_category_sets_b s
1380: , mtl_item_categories c
1381: WHERE
1382: c.inventory_item_id = X_item_id
1383: AND c.organization_id = X_master_org_id
1384: AND s.category_set_id = c.category_set_id

Line 1420: FROM mtl_item_categories mic

1416: -- Check if the item already has any category assignment
1417: -- Bug #1814719.
1418: AND NOT EXISTS
1419: ( SELECT 'x'
1420: FROM mtl_item_categories mic
1421: WHERE
1422: mic.inventory_item_id = X_item_id
1423: AND mic.organization_id = X_org_id
1424: AND mic.category_set_id = s.category_set_id

Line 1428: INSERT INTO mtl_item_categories

1424: AND mic.category_set_id = s.category_set_id
1425: );
1426:
1427: FORALL I IN l_categories_rec.FIRST .. l_categories_rec.LAST
1428: INSERT INTO mtl_item_categories
1429: (
1430: inventory_item_id
1431: ,organization_id
1432: ,category_set_id,

Line 1521: insert into mtl_item_categories

1517: )
1518: IS
1519: l_user_id NUMBER := NVL(FND_GLOBAL.User_Id, 0);
1520: BEGIN
1521: insert into mtl_item_categories
1522: (inventory_item_id,
1523: category_set_id,
1524: category_id,
1525: last_update_date,

Line 1556: from mtl_item_categories c

1552: from mtl_default_category_sets d
1553: where d.functional_area_id = 5)
1554: and not exists
1555: ( select 'x'
1556: from mtl_item_categories c
1557: where c.inventory_item_id = X_item_id
1558: and c.organization_id = X_org_id
1559: and c.category_set_id = s.category_set_id
1560: );

Line 1744: FROM mtl_item_categories

1740: ,cp_cat_set NUMBER)
1741: IS
1742: SELECT category_set_id
1743: ,category_id
1744: FROM mtl_item_categories
1745: WHERE organization_id = cp_org_id
1746: AND inventory_item_id = cp_item_id
1747: AND category_set_id <> cp_cat_set;
1748:

Line 1784: delete from mtl_item_categories

1780: END IF;
1781: END LOOP;
1782: -- End Bug: 3185516
1783:
1784: delete from mtl_item_categories
1785: where inventory_item_id = X_item_id
1786: and organization_id = X_org_id
1787: and CATEGORY_SET_ID <> G_PF_Category_Set_ID;
1788: