[Home] [Help]
819:
820: xErrLoc := 400;
821:
822: FORALL i IN 1..v_count
823: INSERT INTO icx_cat_items_ctx_tlp
824: (rt_item_id, language, sequence, ctx_desc, org_id)
825: VALUES
826: (v_item_ids(i), gJobLanguage, v_sequence,
827: to_char(v_buyer_ids(i)), v_buyer_ids(i));
1036: -- If gSystemActions(i) is DELETE, then it will not be in gDistinctItemIds
1037: xErrLoc := 150;
1038:
1039: FORALL i IN 1..gDistinctItemIds.COUNT
1040: INSERT INTO icx_cat_items_ctx_tlp
1041: (rt_item_id, language, sequence, ctx_desc, org_id)
1042: SELECT gDistinctItemIds(i), tl.language, v_sequence,
1043: to_char(gDistinctBuyerIds(i)), gDistinctBuyerIds(i)
1044: FROM icx_cat_items_tlp tl
1043: to_char(gDistinctBuyerIds(i)), gDistinctBuyerIds(i)
1044: FROM icx_cat_items_tlp tl
1045: WHERE tl.rt_item_id = gDistinctItemIds(i)
1046: AND NOT EXISTS
1047: (SELECT 1 FROM icx_cat_items_ctx_tlp
1048: WHERE rt_item_id = gDistinctItemIds(i)
1049: AND org_id = gDistinctBuyerIds(i));
1050:
1051: xErrLoc := 160;
1753: xErrLoc := 300;
1754:
1755: -- Delete the ctx entries for the items that we update now.
1756: FORALL i in 1..gItemIds.COUNT
1757: DELETE FROM icx_cat_items_ctx_tlp
1758: WHERE rt_item_id = gItemIds(i)
1759: AND gSystemActions(i) = 'UPDATE';
1760:
1761: -- When there is a category Change, update all the descriptor values
1873: -- This should work for both UPDATE and TRANSLATE
1874: xErrLoc := 1200;
1875:
1876: FORALL i IN 1..gRowids.COUNT
1877: INSERT INTO icx_cat_items_ctx_tlp
1878: (rt_item_id, language, sequence, ctx_desc, org_id,
1879: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
1880: CREATED_BY, CREATION_DATE)
1881: SELECT gItemIds(i), tl.language, v_sequence,
1924: WHERE rt_item_id = gItemIds(i)
1925: AND v_action = gSystemActions(i);
1926:
1927: xErrLoc := 250;
1928: -- ICX_CAT_ITEMS_CTX_TLP
1929: FORALL i in 1..gRowIds.COUNT
1930: DELETE from icx_cat_items_ctx_tlp
1931: WHERE rt_item_id = gItemIds(i)
1932: AND v_action = gSystemActions(i);
1926:
1927: xErrLoc := 250;
1928: -- ICX_CAT_ITEMS_CTX_TLP
1929: FORALL i in 1..gRowIds.COUNT
1930: DELETE from icx_cat_items_ctx_tlp
1931: WHERE rt_item_id = gItemIds(i)
1932: AND v_action = gSystemActions(i);
1933:
1934: xErrLoc := 300;
2006: v_count := DBMS_SQL.execute(v_cursor_id);
2007: DBMS_SQL.close_cursor(v_cursor_id);
2008:
2009: -- Delete the ctx entries for the items that we translate now.
2010: v_delete_ctx_sql := 'delete from icx_cat_items_ctx_tlp where rt_item_id = :rt_item_id and :p_action=:update_action';
2011: v_cursor_id := DBMS_SQL.open_cursor;
2012: DBMS_SQL.parse(v_cursor_id, v_delete_ctx_sql, dbms_sql.native);
2013: DBMS_SQL.bind_array(v_cursor_id, ':rt_item_id', gItemIds);
2014: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2118: -- This should work for both UPDATE and TRANSLATE
2119: xErrLoc := 900;
2120:
2121: FORALL i IN 1..gRowids.COUNT
2122: INSERT INTO icx_cat_items_ctx_tlp
2123: (rt_item_id, language, sequence, ctx_desc, org_id)
2124: SELECT gItemIds(i), tl.language, v_sequence,
2125: to_char(pll.org_id), pll.org_id
2126: FROM icx_cat_items_tlp tl,
3682: -- These pl/sql tables may not be distinct, since we don't
3683: -- retrieve rows ordered by item and buyer anymore
3684: -- However, the logic in process_batch_addupdate_prices can handle
3685: -- dupliate item/buyer pairs and will not insert duplicate into
3686: -- icx_cat_items_ctx_tlp
3687: IF (vPrevItemId <> vCurrentItemIds(i) OR
3688: vPrevOrgId <> vOrgIds(i)) THEN
3689: vDistinctBuyerCount := vDistinctBuyerCount + 1;
3690: gDistinctItemIds(vDistinctBuyerCount) := vCurrentItemIds(i);