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.ICX_POR_ITEM_UPLOAD dependencies on DBMS_SQL

Line 117: gRowids dbms_sql.urowid_table;

113:
114: /* Global tables to store information needed for bulk binding
115: Whenever a new global table is added, make sure it's also cleared in
116: the clear_tables procedure */
117: gRowids dbms_sql.urowid_table;
118: gSystemActions dbms_sql.varchar2_table;
119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;

Line 118: gSystemActions dbms_sql.varchar2_table;

114: /* Global tables to store information needed for bulk binding
115: Whenever a new global table is added, make sure it's also cleared in
116: the clear_tables procedure */
117: gRowids dbms_sql.urowid_table;
118: gSystemActions dbms_sql.varchar2_table;
119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;

Line 120: gItemIds dbms_sql.number_table;

116: the clear_tables procedure */
117: gRowids dbms_sql.urowid_table;
118: gSystemActions dbms_sql.varchar2_table;
119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;

Line 121: gCurrentItemIds dbms_sql.number_table;

117: gRowids dbms_sql.urowid_table;
118: gSystemActions dbms_sql.varchar2_table;
119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;

Line 122: gCategoryIds dbms_sql.number_table;

118: gSystemActions dbms_sql.varchar2_table;
119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;

Line 123: gCategoryNames dbms_sql.varchar2_table;

119: gRowTypes ShortVarchar2Tab;
120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;

Line 124: gOldCategoryIds dbms_sql.number_table;

120: gItemIds dbms_sql.number_table;
121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;

Line 125: gDistinctCategoryIds dbms_sql.number_table;

121: gCurrentItemIds dbms_sql.number_table;
122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;

Line 126: gOrgIds dbms_sql.number_table;

122: gCategoryIds dbms_sql.number_table;
123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;

Line 127: gPricelistIds dbms_sql.number_table;

123: gCategoryNames dbms_sql.varchar2_table;
124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices

Line 128: gSupplierSiteIds dbms_sql.number_table;

124: gOldCategoryIds dbms_sql.number_table;
125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;

Line 129: gExtractorUpdatedFlags dbms_sql.varchar2_table;

125: gDistinctCategoryIds dbms_sql.number_table;
126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;
133: gPriceTypes dbms_sql.varchar2_table;

Line 130: gActiveFlags dbms_sql.varchar2_table;

126: gOrgIds dbms_sql.number_table;
127: gPricelistIds dbms_sql.number_table;
128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;
133: gPriceTypes dbms_sql.varchar2_table;
134: gUoms dbms_sql.varchar2_table;

Line 132: gSupplierIds dbms_sql.number_table;

128: gSupplierSiteIds dbms_sql.number_table;
129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;
133: gPriceTypes dbms_sql.varchar2_table;
134: gUoms dbms_sql.varchar2_table;
135:
136: -- Category_Change

Line 133: gPriceTypes dbms_sql.varchar2_table;

129: gExtractorUpdatedFlags dbms_sql.varchar2_table;
130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;
133: gPriceTypes dbms_sql.varchar2_table;
134: gUoms dbms_sql.varchar2_table;
135:
136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;

Line 134: gUoms dbms_sql.varchar2_table;

130: gActiveFlags dbms_sql.varchar2_table;
131: -- added by bluk, to be used in move_prices_no_validation, process_batch_addupdate_prices
132: gSupplierIds dbms_sql.number_table;
133: gPriceTypes dbms_sql.varchar2_table;
134: gUoms dbms_sql.varchar2_table;
135:
136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;
138: gChangedOldCatIds dbms_sql.number_table;

Line 137: gChangedCatItemIds dbms_sql.number_table;

133: gPriceTypes dbms_sql.varchar2_table;
134: gUoms dbms_sql.varchar2_table;
135:
136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;
138: gChangedOldCatIds dbms_sql.number_table;
139: gChangedNewCatIds dbms_sql.number_table;
140: gChangedCatActions dbms_sql.varchar2_table;
141:

Line 138: gChangedOldCatIds dbms_sql.number_table;

134: gUoms dbms_sql.varchar2_table;
135:
136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;
138: gChangedOldCatIds dbms_sql.number_table;
139: gChangedNewCatIds dbms_sql.number_table;
140: gChangedCatActions dbms_sql.varchar2_table;
141:
142: -- BUYER NORMALIZATION

Line 139: gChangedNewCatIds dbms_sql.number_table;

135:
136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;
138: gChangedOldCatIds dbms_sql.number_table;
139: gChangedNewCatIds dbms_sql.number_table;
140: gChangedCatActions dbms_sql.varchar2_table;
141:
142: -- BUYER NORMALIZATION
143: gDistinctItemIds dbms_sql.number_table;

Line 140: gChangedCatActions dbms_sql.varchar2_table;

136: -- Category_Change
137: gChangedCatItemIds dbms_sql.number_table;
138: gChangedOldCatIds dbms_sql.number_table;
139: gChangedNewCatIds dbms_sql.number_table;
140: gChangedCatActions dbms_sql.varchar2_table;
141:
142: -- BUYER NORMALIZATION
143: gDistinctItemIds dbms_sql.number_table;
144: gDistinctBuyerIds dbms_sql.number_table;

Line 143: gDistinctItemIds dbms_sql.number_table;

139: gChangedNewCatIds dbms_sql.number_table;
140: gChangedCatActions dbms_sql.varchar2_table;
141:
142: -- BUYER NORMALIZATION
143: gDistinctItemIds dbms_sql.number_table;
144: gDistinctBuyerIds dbms_sql.number_table;
145:
146: --Bug#3396442
147: --gRootDescKeys is only used in save_failed_item to insert into failed lines

Line 144: gDistinctBuyerIds dbms_sql.number_table;

140: gChangedCatActions dbms_sql.varchar2_table;
141:
142: -- BUYER NORMALIZATION
143: gDistinctItemIds dbms_sql.number_table;
144: gDistinctBuyerIds dbms_sql.number_table;
145:
146: --Bug#3396442
147: --gRootDescKeys is only used in save_failed_item to insert into failed lines
148: --This is not needed. save_failed_item has a new cursor to get the non-seeded

Line 152: gErrorRowids dbms_sql.urowid_table;

148: --This is not needed. save_failed_item has a new cursor to get the non-seeded
149: --root descriptors
150: --gRootDescKeys KeyTab;
151:
152: gErrorRowids dbms_sql.urowid_table;
153: gErrorCatId NUMBER;
154: gErrorCatDescKeys KeyTab;
155:
156: gTranslateItemsSQL VARCHAR2(32767);

Line 255: PROCEDURE get_distinct(pNumbers IN dbms_sql.number_table,

251: /**
252: ** Proc : get_distinct
253: ** Desc : Gets the distinct values from a pl/sql number table
254: **/
255: PROCEDURE get_distinct(pNumbers IN dbms_sql.number_table,
256: pDistinctNumbers OUT NOCOPY dbms_sql.number_table) IS
257: i NUMBER;
258: j NUMBER;
259: v_current_num NUMBER;

Line 256: pDistinctNumbers OUT NOCOPY dbms_sql.number_table) IS

252: ** Proc : get_distinct
253: ** Desc : Gets the distinct values from a pl/sql number table
254: **/
255: PROCEDURE get_distinct(pNumbers IN dbms_sql.number_table,
256: pDistinctNumbers OUT NOCOPY dbms_sql.number_table) IS
257: i NUMBER;
258: j NUMBER;
259: v_current_num NUMBER;
260: v_found BOOLEAN;

Line 261: v_temp_num dbms_sql.number_table;

257: i NUMBER;
258: j NUMBER;
259: v_current_num NUMBER;
260: v_found BOOLEAN;
261: v_temp_num dbms_sql.number_table;
262: v_empty_tab dbms_sql.number_table;
263: xErrLoc PLS_INTEGER := 100;
264: BEGIN
265: -- Initialize

Line 262: v_empty_tab dbms_sql.number_table;

258: j NUMBER;
259: v_current_num NUMBER;
260: v_found BOOLEAN;
261: v_temp_num dbms_sql.number_table;
262: v_empty_tab dbms_sql.number_table;
263: xErrLoc PLS_INTEGER := 100;
264: BEGIN
265: -- Initialize
266: pDistinctNumbers := v_empty_tab;

Line 538: v_distinct_catids dbms_sql.number_table;

534: END build_category_sql;
535:
536: /* Loads information about the categories in the current batch */
537: PROCEDURE load_distinct_categories IS
538: v_distinct_catids dbms_sql.number_table;
539: v_category_info CategoryInfo;
540: i PLS_INTEGER;
541: CURSOR get_category_name(p_category_id NUMBER) IS
542: SELECT category_name FROM icx_cat_categories_tl

Line 775: v_buyer_ids dbms_sql.number_table;

771: i PLS_INTEGER;
772: v_action VARCHAR2(10) := 'ADD';
773: xErrLoc PLS_INTEGER := 100;
774: v_sequence PLS_INTEGER := 10001;
775: v_buyer_ids dbms_sql.number_table;
776: v_item_ids dbms_sql.number_table;
777: v_count PLS_INTEGER := 0;
778: BEGIN
779: -- This is used only for ITEM_PRICES. New prices or updates in the PRICE

Line 776: v_item_ids dbms_sql.number_table;

772: v_action VARCHAR2(10) := 'ADD';
773: xErrLoc PLS_INTEGER := 100;
774: v_sequence PLS_INTEGER := 10001;
775: v_buyer_ids dbms_sql.number_table;
776: v_item_ids dbms_sql.number_table;
777: v_count PLS_INTEGER := 0;
778: BEGIN
779: -- This is used only for ITEM_PRICES. New prices or updates in the PRICE
780: -- section is handled by process_batch_addupdate_prices

Line 850: v_price_updated dbms_sql.number_table;

846: PROCEDURE process_batch_addupdate_prices(p_batch_type IN VARCHAR2,
847: p_action IN VARCHAR2 DEFAULT 'UPDATE',
848: p_num_failed_lines OUT NOCOPY NUMBER) IS
849: i PLS_INTEGER;
850: v_price_updated dbms_sql.number_table;
851: xErrLoc PLS_INTEGER := 100;
852: v_sequence PLS_INTEGER := 10001;
853: numErrors NUMBER := 0;
854: BEGIN

Line 1186: vItemIds dbms_sql.number_table;

1182: */
1183: PROCEDURE process_batch_common IS
1184: i PLS_INTEGER;
1185: vCount PLS_INTEGER;
1186: vItemIds dbms_sql.number_table;
1187: vCategoryIds dbms_sql.number_table;
1188: xErrLoc PLS_INTEGER := 100;
1189:
1190: BEGIN

Line 1187: vCategoryIds dbms_sql.number_table;

1183: PROCEDURE process_batch_common IS
1184: i PLS_INTEGER;
1185: vCount PLS_INTEGER;
1186: vItemIds dbms_sql.number_table;
1187: vCategoryIds dbms_sql.number_table;
1188: xErrLoc PLS_INTEGER := 100;
1189:
1190: BEGIN
1191:

Line 1629: v_cursor_id := DBMS_SQL.open_cursor;

1625: xErrLoc := 700;
1626:
1627: FOR j IN 1..gAddCatCtxSQL.COUNT LOOP
1628: xErrLoc := 800;
1629: v_cursor_id := DBMS_SQL.open_cursor;
1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);
1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);

Line 1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);

1626:
1627: FOR j IN 1..gAddCatCtxSQL.COUNT LOOP
1628: xErrLoc := 800;
1629: v_cursor_id := DBMS_SQL.open_cursor;
1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);
1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);

Line 1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

1627: FOR j IN 1..gAddCatCtxSQL.COUNT LOOP
1628: xErrLoc := 800;
1629: v_cursor_id := DBMS_SQL.open_cursor;
1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);
1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',

1628: xErrLoc := 800;
1629: v_cursor_id := DBMS_SQL.open_cursor;
1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);
1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

Line 1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);

1630: DBMS_SQL.parse(v_cursor_id, gAddCatCtxSQL(j), dbms_sql.native);
1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

Line 1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1631: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

1632: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);

Line 1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

1633: gJobLanguage);
1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);
1641: DBMS_SQL.close_cursor(v_cursor_id);

Line 1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

1634: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);
1641: DBMS_SQL.close_cursor(v_cursor_id);
1642: END LOOP;

Line 1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

1635: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);
1641: DBMS_SQL.close_cursor(v_cursor_id);
1642: END LOOP;
1643:

Line 1640: v_count := DBMS_SQL.execute(v_cursor_id);

1636: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);
1641: DBMS_SQL.close_cursor(v_cursor_id);
1642: END LOOP;
1643:
1644: END IF;

Line 1641: DBMS_SQL.close_cursor(v_cursor_id);

1637: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1638: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1639: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1640: v_count := DBMS_SQL.execute(v_cursor_id);
1641: DBMS_SQL.close_cursor(v_cursor_id);
1642: END LOOP;
1643:
1644: END IF;
1645:

Line 1653: v_cursor_id := DBMS_SQL.open_cursor;

1649: -- ICX_POR_ITEMS_CTX_TLP
1650:
1651: FOR i IN 1..gAddRootCtxSQL.COUNT LOOP
1652: xErrLoc := 900 + i;
1653: v_cursor_id := DBMS_SQL.open_cursor;
1654:
1655: DBMS_SQL.parse(v_cursor_id, gAddRootCtxSQL(i), dbms_sql.native);
1656: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);

Line 1655: DBMS_SQL.parse(v_cursor_id, gAddRootCtxSQL(i), dbms_sql.native);

1651: FOR i IN 1..gAddRootCtxSQL.COUNT LOOP
1652: xErrLoc := 900 + i;
1653: v_cursor_id := DBMS_SQL.open_cursor;
1654:
1655: DBMS_SQL.parse(v_cursor_id, gAddRootCtxSQL(i), dbms_sql.native);
1656: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1658:
1659: IF (i = gAddRootCtxSQL.COUNT - 1) THEN

Line 1656: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

1652: xErrLoc := 900 + i;
1653: v_cursor_id := DBMS_SQL.open_cursor;
1654:
1655: DBMS_SQL.parse(v_cursor_id, gAddRootCtxSQL(i), dbms_sql.native);
1656: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1658:
1659: IF (i = gAddRootCtxSQL.COUNT - 1) THEN
1660: -- This is the line

Line 1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);

1653: v_cursor_id := DBMS_SQL.open_cursor;
1654:
1655: DBMS_SQL.parse(v_cursor_id, gAddRootCtxSQL(i), dbms_sql.native);
1656: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1658:
1659: IF (i = gAddRootCtxSQL.COUNT - 1) THEN
1660: -- This is the line
1661: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

Line 1661: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

1657: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1658:
1659: IF (i = gAddRootCtxSQL.COUNT - 1) THEN
1660: -- This is the line
1661: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
1662: ELSIF (i = gAddRootCtxSQL.COUNT) THEN
1663: -- This is the line
1664: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1665: ELSE

Line 1664: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);

1660: -- This is the line
1661: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
1662: ELSIF (i = gAddRootCtxSQL.COUNT) THEN
1663: -- This is the line
1664: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1665: ELSE
1666: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1667: END IF;
1668:

Line 1666: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);

1662: ELSIF (i = gAddRootCtxSQL.COUNT) THEN
1663: -- This is the line
1664: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1665: ELSE
1666: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1667: END IF;
1668:
1669: IF (i = 1) THEN
1670: -- The first SQL contains category id and name

Line 1671: DBMS_SQL.bind_array(v_cursor_id, ':p_supplier_id', gSupplierIds);

1667: END IF;
1668:
1669: IF (i = 1) THEN
1670: -- The first SQL contains category id and name
1671: DBMS_SQL.bind_array(v_cursor_id, ':p_supplier_id', gSupplierIds);
1672: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);
1674: END IF;
1675:

Line 1672: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

1668:
1669: IF (i = 1) THEN
1670: -- The first SQL contains category id and name
1671: DBMS_SQL.bind_array(v_cursor_id, ':p_supplier_id', gSupplierIds);
1672: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);
1674: END IF;
1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

Line 1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);

1669: IF (i = 1) THEN
1670: -- The first SQL contains category id and name
1671: DBMS_SQL.bind_array(v_cursor_id, ':p_supplier_id', gSupplierIds);
1672: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);
1674: END IF;
1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

1672: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);
1674: END IF;
1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1679: v_count := DBMS_SQL.execute(v_cursor_id);
1680: DBMS_SQL.close_cursor(v_cursor_id);

Line 1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

1673: DBMS_SQL.bind_array(v_cursor_id, ':p_category_name', gCategoryNames);
1674: END IF;
1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1679: v_count := DBMS_SQL.execute(v_cursor_id);
1680: DBMS_SQL.close_cursor(v_cursor_id);
1681: END LOOP;

Line 1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1674: END IF;
1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1679: v_count := DBMS_SQL.execute(v_cursor_id);
1680: DBMS_SQL.close_cursor(v_cursor_id);
1681: END LOOP;
1682:

Line 1679: v_count := DBMS_SQL.execute(v_cursor_id);

1675:
1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1679: v_count := DBMS_SQL.execute(v_cursor_id);
1680: DBMS_SQL.close_cursor(v_cursor_id);
1681: END LOOP;
1682:
1683: EXCEPTION

Line 1680: DBMS_SQL.close_cursor(v_cursor_id);

1676: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1677: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1678: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1679: v_count := DBMS_SQL.execute(v_cursor_id);
1680: DBMS_SQL.close_cursor(v_cursor_id);
1681: END LOOP;
1682:
1683: EXCEPTION
1684: WHEN OTHERS THEN

Line 1727: v_cursor_id := DBMS_SQL.open_cursor;

1723: -- of the ICX_CAT_ITEMS_TLP
1724:
1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

Line 1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);

1724:
1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);

Line 1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);

Line 1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);

Line 1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);

1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:

Line 1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

1730: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors

Line 1735: v_count := DBMS_SQL.execute(v_cursor_id);

1731: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;

Line 1736: DBMS_SQL.close_cursor(v_cursor_id);

1732: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1733: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;

Line 1740: v_cursor_id := DBMS_SQL.open_cursor;

1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);

1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

Line 1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);

1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);

Line 1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);

Line 1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);
1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);

Line 1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);

1743: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);
1751: DBMS_SQL.close_cursor(v_cursor_id);

Line 1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

1744: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);
1751: DBMS_SQL.close_cursor(v_cursor_id);
1752:

Line 1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);

1745: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);
1751: DBMS_SQL.close_cursor(v_cursor_id);
1752:
1753: xErrLoc := 300;

Line 1750: v_count := DBMS_SQL.execute(v_cursor_id);

1746: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);
1751: DBMS_SQL.close_cursor(v_cursor_id);
1752:
1753: xErrLoc := 300;
1754:

Line 1751: DBMS_SQL.close_cursor(v_cursor_id);

1747: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'UPDATE', 10);
1748: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1749: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1750: v_count := DBMS_SQL.execute(v_cursor_id);
1751: DBMS_SQL.close_cursor(v_cursor_id);
1752:
1753: xErrLoc := 300;
1754:
1755: -- Delete the ctx entries for the items that we update now.

Line 1784: v_cursor_id := DBMS_SQL.open_cursor;

1780: IF (gCategoryInfo(v_catid).descriptor_count > 0) THEN
1781: xErrLoc := 500;
1782:
1783: -- Update the Non-Translateable local descriptors for the given category
1784: v_cursor_id := DBMS_SQL.open_cursor;
1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,

1781: xErrLoc := 500;
1782:
1783: -- Update the Non-Translateable local descriptors for the given category
1784: v_cursor_id := DBMS_SQL.open_cursor;
1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 1786: DBMS_SQL.NATIVE);

1782:
1783: -- Update the Non-Translateable local descriptors for the given category
1784: v_cursor_id := DBMS_SQL.open_cursor;
1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',

Line 1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1783: -- Update the Non-Translateable local descriptors for the given category
1784: v_cursor_id := DBMS_SQL.open_cursor;
1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);

Line 1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1784: v_cursor_id := DBMS_SQL.open_cursor;
1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

1785: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',

1786: DBMS_SQL.NATIVE);
1787: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

1788: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1795: v_count := DBMS_SQL.execute(v_cursor_id);
1796: DBMS_SQL.close_cursor(v_cursor_id);

Line 1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1789: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1795: v_count := DBMS_SQL.execute(v_cursor_id);
1796: DBMS_SQL.close_cursor(v_cursor_id);
1797:

Line 1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1790: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1795: v_count := DBMS_SQL.execute(v_cursor_id);
1796: DBMS_SQL.close_cursor(v_cursor_id);
1797:
1798: xErrLoc := 600;

Line 1795: v_count := DBMS_SQL.execute(v_cursor_id);

1791: 'UPDATE', 10);
1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1795: v_count := DBMS_SQL.execute(v_cursor_id);
1796: DBMS_SQL.close_cursor(v_cursor_id);
1797:
1798: xErrLoc := 600;
1799:

Line 1796: DBMS_SQL.close_cursor(v_cursor_id);

1792: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1793: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1794: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1795: v_count := DBMS_SQL.execute(v_cursor_id);
1796: DBMS_SQL.close_cursor(v_cursor_id);
1797:
1798: xErrLoc := 600;
1799:
1800: -- Update the Translateable local descriptors for the given category

Line 1801: v_cursor_id := DBMS_SQL.open_cursor;

1797:
1798: xErrLoc := 600;
1799:
1800: -- Update the Translateable local descriptors for the given category
1801: v_cursor_id := DBMS_SQL.open_cursor;
1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,
1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',

Line 1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,

1798: xErrLoc := 600;
1799:
1800: -- Update the Translateable local descriptors for the given category
1801: v_cursor_id := DBMS_SQL.open_cursor;
1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,
1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);

Line 1803: DBMS_SQL.NATIVE);

1799:
1800: -- Update the Translateable local descriptors for the given category
1801: v_cursor_id := DBMS_SQL.open_cursor;
1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,
1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

Line 1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);

1800: -- Update the Translateable local descriptors for the given category
1801: v_cursor_id := DBMS_SQL.open_cursor;
1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,
1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',

1801: v_cursor_id := DBMS_SQL.open_cursor;
1802: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateTLSQL,
1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1803: DBMS_SQL.NATIVE);
1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);

Line 1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1804: DBMS_SQL.bind_variable(v_cursor_id, ':p_request_id', gJobNumber);
1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

1805: DBMS_SQL.bind_variable(v_cursor_id, ':p_language',
1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',

1806: gJobLanguage, 4);
1807: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

1808: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1815: v_count := DBMS_SQL.execute(v_cursor_id);
1816: DBMS_SQL.close_cursor(v_cursor_id);

Line 1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1809: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1815: v_count := DBMS_SQL.execute(v_cursor_id);
1816: DBMS_SQL.close_cursor(v_cursor_id);
1817:

Line 1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1810: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1815: v_count := DBMS_SQL.execute(v_cursor_id);
1816: DBMS_SQL.close_cursor(v_cursor_id);
1817:
1818: xErrLoc := 700;

Line 1815: v_count := DBMS_SQL.execute(v_cursor_id);

1811: 'UPDATE', 10);
1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1815: v_count := DBMS_SQL.execute(v_cursor_id);
1816: DBMS_SQL.close_cursor(v_cursor_id);
1817:
1818: xErrLoc := 700;
1819:

Line 1816: DBMS_SQL.close_cursor(v_cursor_id);

1812: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1813: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1814: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1815: v_count := DBMS_SQL.execute(v_cursor_id);
1816: DBMS_SQL.close_cursor(v_cursor_id);
1817:
1818: xErrLoc := 700;
1819:
1820: END IF; -- end of if local descriptors exist

Line 1830: v_cursor_id := DBMS_SQL.open_cursor;

1826: build_category_ctx_sql(v_catid);
1827: xErrLoc := 900;
1828:
1829: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
1830: v_cursor_id := DBMS_SQL.open_cursor;
1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

Line 1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),

1827: xErrLoc := 900;
1828:
1829: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
1830: v_cursor_id := DBMS_SQL.open_cursor;
1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

Line 1832: dbms_sql.native);

1828:
1829: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
1830: v_cursor_id := DBMS_SQL.open_cursor;
1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);

1829: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
1830: v_cursor_id := DBMS_SQL.open_cursor;
1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

Line 1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

1830: v_cursor_id := DBMS_SQL.open_cursor;
1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

1831: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);

Line 1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

1832: dbms_sql.native);
1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);
1840: DBMS_SQL.close_cursor(v_cursor_id);

Line 1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

1833: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);
1840: DBMS_SQL.close_cursor(v_cursor_id);
1841: END LOOP;

Line 1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

1834: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);
1840: DBMS_SQL.close_cursor(v_cursor_id);
1841: END LOOP;
1842: END IF;

Line 1839: v_count := DBMS_SQL.execute(v_cursor_id);

1835: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);
1840: DBMS_SQL.close_cursor(v_cursor_id);
1841: END LOOP;
1842: END IF;
1843:

Line 1840: DBMS_SQL.close_cursor(v_cursor_id);

1836: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
1837: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1838: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1839: v_count := DBMS_SQL.execute(v_cursor_id);
1840: DBMS_SQL.close_cursor(v_cursor_id);
1841: END LOOP;
1842: END IF;
1843:
1844: END LOOP;

Line 1850: v_cursor_id := DBMS_SQL.open_cursor;

1846: -- ICX_POR_CTX_TL
1847: xErrLoc := 1100;
1848:
1849: FOR i IN 1..gUpdateRootCtxSQL.COUNT LOOP
1850: v_cursor_id := DBMS_SQL.open_cursor;
1851:
1852: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
1853:
1854: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN

Line 1852: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);

1848:
1849: FOR i IN 1..gUpdateRootCtxSQL.COUNT LOOP
1850: v_cursor_id := DBMS_SQL.open_cursor;
1851:
1852: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
1853:
1854: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN
1855: -- This is the line
1856: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

Line 1856: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

1852: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
1853:
1854: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN
1855: -- This is the line
1856: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
1857: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
1858: -- This is the line
1859: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1860: ELSE

Line 1859: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);

1855: -- This is the line
1856: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
1857: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
1858: -- This is the line
1859: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1860: ELSE
1861: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1862: END IF;
1863:

Line 1861: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);

1857: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
1858: -- This is the line
1859: DBMS_SQL.BIND_VARIABLE(v_cursor_id, ':p_sequence',15000);
1860: ELSE
1861: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1862: END IF;
1863:
1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

1860: ELSE
1861: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1862: END IF;
1863:
1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1867: v_count := DBMS_SQL.execute(v_cursor_id);
1868: DBMS_SQL.close_cursor(v_cursor_id);

Line 1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

1861: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
1862: END IF;
1863:
1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1867: v_count := DBMS_SQL.execute(v_cursor_id);
1868: DBMS_SQL.close_cursor(v_cursor_id);
1869: END LOOP;

Line 1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

1862: END IF;
1863:
1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1867: v_count := DBMS_SQL.execute(v_cursor_id);
1868: DBMS_SQL.close_cursor(v_cursor_id);
1869: END LOOP;
1870:

Line 1867: v_count := DBMS_SQL.execute(v_cursor_id);

1863:
1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1867: v_count := DBMS_SQL.execute(v_cursor_id);
1868: DBMS_SQL.close_cursor(v_cursor_id);
1869: END LOOP;
1870:
1871: -- BUYER ID NORMALIZATION

Line 1868: DBMS_SQL.close_cursor(v_cursor_id);

1864: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
1865: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
1866: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
1867: v_count := DBMS_SQL.execute(v_cursor_id);
1868: DBMS_SQL.close_cursor(v_cursor_id);
1869: END LOOP;
1870:
1871: -- BUYER ID NORMALIZATION
1872: -- Inserts the buyer ids for the items

Line 1897: IF (DBMS_SQL.is_open(v_cursor_id)) THEN

1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: ROLLBACK;
1896:
1897: IF (DBMS_SQL.is_open(v_cursor_id)) THEN
1898: DBMS_SQL.close_cursor(v_cursor_id);
1899: END IF;
1900:
1901: RAISE_APPLICATION_ERROR(-20000,

Line 1898: DBMS_SQL.close_cursor(v_cursor_id);

1894: WHEN OTHERS THEN
1895: ROLLBACK;
1896:
1897: IF (DBMS_SQL.is_open(v_cursor_id)) THEN
1898: DBMS_SQL.close_cursor(v_cursor_id);
1899: END IF;
1900:
1901: RAISE_APPLICATION_ERROR(-20000,
1902: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_update('

Line 1984: v_cursor_id := DBMS_SQL.open_cursor;

1980: v_delete_ctx_sql VARCHAR2(255);
1981: BEGIN
1982: -- ICX_CAT_ITEMS_TLP: Insert new Row
1983: xErrLoc := 100;
1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

Line 1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);

1981: BEGIN
1982: -- ICX_CAT_ITEMS_TLP: Insert new Row
1983: xErrLoc := 100;
1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1982: -- ICX_CAT_ITEMS_TLP: Insert new Row
1983: xErrLoc := 100;
1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

Line 1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1983: xErrLoc := 100;
1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);

Line 1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);

Line 1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);

Line 1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

1987: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:

Line 1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);

1988: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:
1996: xErrLoc := 200;

Line 1993: v_count := DBMS_SQL.execute(v_cursor_id);

1989: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:
1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors

Line 1994: DBMS_SQL.close_cursor(v_cursor_id);

1990: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
1991: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1992: -- DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage);
1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:
1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;

Line 1998: v_cursor_id := DBMS_SQL.open_cursor;

1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:
1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

Line 1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);

1995:
1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

Line 2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2006: v_count := DBMS_SQL.execute(v_cursor_id);

Line 2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2006: v_count := DBMS_SQL.execute(v_cursor_id);
2007: DBMS_SQL.close_cursor(v_cursor_id);

Line 2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2006: v_count := DBMS_SQL.execute(v_cursor_id);
2007: DBMS_SQL.close_cursor(v_cursor_id);
2008:

Line 2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
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.

Line 2006: v_count := DBMS_SQL.execute(v_cursor_id);

2002: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
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';

Line 2007: DBMS_SQL.close_cursor(v_cursor_id);

2003: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2004: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2005: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
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;

Line 2011: v_cursor_id := DBMS_SQL.open_cursor;

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');

Line 2012: DBMS_SQL.parse(v_cursor_id, v_delete_ctx_sql, dbms_sql.native);

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);

Line 2013: DBMS_SQL.bind_array(v_cursor_id, ':rt_item_id', gItemIds);

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);
2017: DBMS_SQL.close_cursor(v_cursor_id);

Line 2014: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);
2017: DBMS_SQL.close_cursor(v_cursor_id);
2018: xErrLoc := 300;

Line 2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);
2017: DBMS_SQL.close_cursor(v_cursor_id);
2018: xErrLoc := 300;
2019:

Line 2016: v_count := DBMS_SQL.execute(v_cursor_id);

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);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);
2017: DBMS_SQL.close_cursor(v_cursor_id);
2018: xErrLoc := 300;
2019:
2020: xErrLoc := 600;

Line 2017: DBMS_SQL.close_cursor(v_cursor_id);

2013: DBMS_SQL.bind_array(v_cursor_id, ':rt_item_id', gItemIds);
2014: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2015: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE');
2016: v_count := DBMS_SQL.execute(v_cursor_id);
2017: DBMS_SQL.close_cursor(v_cursor_id);
2018: xErrLoc := 300;
2019:
2020: xErrLoc := 600;
2021: -- Erase out the existing local descriptor values when category is changed.

Line 2035: v_cursor_id := DBMS_SQL.open_cursor;

2031: --So put the cursor gCategoryInfo(v_catid).translateSQL to insert into icx_cat_ext_items_tlp
2032: --outside of the if check (gCategoryInfo(v_catid).descriptor_count > 0)
2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,

2032: --outside of the if check (gCategoryInfo(v_catid).descriptor_count > 0)
2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 2037: DBMS_SQL.NATIVE);

2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

Line 2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

2037: DBMS_SQL.NATIVE);
2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);

Line 2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);

2038: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);
2046: DBMS_SQL.close_cursor(v_cursor_id);

Line 2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

2039: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);
2046: DBMS_SQL.close_cursor(v_cursor_id);
2047:

Line 2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

2040: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);
2046: DBMS_SQL.close_cursor(v_cursor_id);
2047:
2048: IF (gCategoryInfo(v_catid).descriptor_count > 0) THEN

Line 2045: v_count := DBMS_SQL.execute(v_cursor_id);

2041: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);
2046: DBMS_SQL.close_cursor(v_cursor_id);
2047:
2048: IF (gCategoryInfo(v_catid).descriptor_count > 0) THEN
2049: -- Handle category changes

Line 2046: DBMS_SQL.close_cursor(v_cursor_id);

2042: DBMS_SQL.bind_variable(v_cursor_id, ':update_action', 'TRANSLATE', 10);
2043: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2044: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2045: v_count := DBMS_SQL.execute(v_cursor_id);
2046: DBMS_SQL.close_cursor(v_cursor_id);
2047:
2048: IF (gCategoryInfo(v_catid).descriptor_count > 0) THEN
2049: -- Handle category changes
2050: xErrLoc := 400;

Line 2054: v_cursor_id := DBMS_SQL.open_cursor;

2050: xErrLoc := 400;
2051:
2052: -- Update the Non-Translateable local descriptors for the given category
2053: -- updateNonTLSQL is reused for Translate here
2054: v_cursor_id := DBMS_SQL.open_cursor;
2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

Line 2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,

2051:
2052: -- Update the Non-Translateable local descriptors for the given category
2053: -- updateNonTLSQL is reused for Translate here
2054: v_cursor_id := DBMS_SQL.open_cursor;
2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 2056: DBMS_SQL.NATIVE);

2052: -- Update the Non-Translateable local descriptors for the given category
2053: -- updateNonTLSQL is reused for Translate here
2054: v_cursor_id := DBMS_SQL.open_cursor;
2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',

Line 2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);

2053: -- updateNonTLSQL is reused for Translate here
2054: v_cursor_id := DBMS_SQL.open_cursor;
2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);

Line 2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);

2054: v_cursor_id := DBMS_SQL.open_cursor;
2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

Line 2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

2055: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).updateNonTLSQL,
2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',

2056: DBMS_SQL.NATIVE);
2057: DBMS_SQL.bind_array(v_cursor_id, ':old_item_id', gCurrentItemIds);
2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);

2058: DBMS_SQL.bind_array(v_cursor_id, ':p_rowid', gRowids);
2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2065: v_count := DBMS_SQL.execute(v_cursor_id);
2066: DBMS_SQL.close_cursor(v_cursor_id);

Line 2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

2059: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2065: v_count := DBMS_SQL.execute(v_cursor_id);
2066: DBMS_SQL.close_cursor(v_cursor_id);
2067:

Line 2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

2060: DBMS_SQL.bind_variable(v_cursor_id, ':update_action',
2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2065: v_count := DBMS_SQL.execute(v_cursor_id);
2066: DBMS_SQL.close_cursor(v_cursor_id);
2067:
2068: IF (gCategoryInfo(v_catid).searchable_desc_count > 0) THEN

Line 2065: v_count := DBMS_SQL.execute(v_cursor_id);

2061: 'TRANSLATE', 10);
2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2065: v_count := DBMS_SQL.execute(v_cursor_id);
2066: DBMS_SQL.close_cursor(v_cursor_id);
2067:
2068: IF (gCategoryInfo(v_catid).searchable_desc_count > 0) THEN
2069: xErrLoc := 700;

Line 2066: DBMS_SQL.close_cursor(v_cursor_id);

2062: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
2063: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2064: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);
2065: v_count := DBMS_SQL.execute(v_cursor_id);
2066: DBMS_SQL.close_cursor(v_cursor_id);
2067:
2068: IF (gCategoryInfo(v_catid).searchable_desc_count > 0) THEN
2069: xErrLoc := 700;
2070: build_category_ctx_sql(v_catid);

Line 2073: v_cursor_id := DBMS_SQL.open_cursor;

2069: xErrLoc := 700;
2070: build_category_ctx_sql(v_catid);
2071:
2072: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
2073: v_cursor_id := DBMS_SQL.open_cursor;
2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

Line 2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),

2070: build_category_ctx_sql(v_catid);
2071:
2072: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
2073: v_cursor_id := DBMS_SQL.open_cursor;
2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

Line 2075: dbms_sql.native);

2071:
2072: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
2073: v_cursor_id := DBMS_SQL.open_cursor;
2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

Line 2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);

2072: FOR j IN 1..gUpdateCatCtxSQL.COUNT LOOP
2073: v_cursor_id := DBMS_SQL.open_cursor;
2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);

2073: v_cursor_id := DBMS_SQL.open_cursor;
2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

Line 2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);

2074: DBMS_SQL.parse(v_cursor_id, gUpdateCatCtxSQL(j),
2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);

Line 2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

2075: dbms_sql.native);
2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);
2083: DBMS_SQL.close_cursor(v_cursor_id);

Line 2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

2076: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', 5000 + j);
2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);
2083: DBMS_SQL.close_cursor(v_cursor_id);
2084: END LOOP;

Line 2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

2077: DBMS_SQL.bind_variable(v_cursor_id, ':current_category_id', v_catid);
2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);
2083: DBMS_SQL.close_cursor(v_cursor_id);
2084: END LOOP;
2085:

Line 2082: v_count := DBMS_SQL.execute(v_cursor_id);

2078: DBMS_SQL.bind_array(v_cursor_id, ':p_category_id', gCategoryIds);
2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);
2083: DBMS_SQL.close_cursor(v_cursor_id);
2084: END LOOP;
2085:
2086: END IF;

Line 2083: DBMS_SQL.close_cursor(v_cursor_id);

2079: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2080: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2081: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2082: v_count := DBMS_SQL.execute(v_cursor_id);
2083: DBMS_SQL.close_cursor(v_cursor_id);
2084: END LOOP;
2085:
2086: END IF;
2087:

Line 2096: v_cursor_id := DBMS_SQL.open_cursor;

2092: -- ICX_POR_CTX_TL
2093: xErrLoc := 800;
2094:
2095: FOR i IN 1..gUpdateRootCtxSQL.COUNT LOOP
2096: v_cursor_id := DBMS_SQL.open_cursor;
2097: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
2098:
2099: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN
2100: -- This is the line

Line 2097: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);

2093: xErrLoc := 800;
2094:
2095: FOR i IN 1..gUpdateRootCtxSQL.COUNT LOOP
2096: v_cursor_id := DBMS_SQL.open_cursor;
2097: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
2098:
2099: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN
2100: -- This is the line
2101: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

Line 2101: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);

2097: DBMS_SQL.parse(v_cursor_id, gUpdateRootCtxSQL(i), dbms_sql.native);
2098:
2099: IF (i = gUpdateRootCtxSQL.COUNT - 1) THEN
2100: -- This is the line
2101: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
2102: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
2103: -- This is the line
2104: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',15000);
2105: ELSE

Line 2104: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',15000);

2100: -- This is the line
2101: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',10000);
2102: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
2103: -- This is the line
2104: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',15000);
2105: ELSE
2106: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
2107: END IF;
2108:

Line 2106: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);

2102: ELSIF (i = gUpdateRootCtxSQL.COUNT) THEN
2103: -- This is the line
2104: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence',15000);
2105: ELSE
2106: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
2107: END IF;
2108:
2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

Line 2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);

2105: ELSE
2106: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
2107: END IF;
2108:
2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2112: v_count := DBMS_SQL.execute(v_cursor_id);
2113: DBMS_SQL.close_cursor(v_cursor_id);

Line 2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);

2106: DBMS_SQL.bind_variable(v_cursor_id, ':p_sequence', i);
2107: END IF;
2108:
2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2112: v_count := DBMS_SQL.execute(v_cursor_id);
2113: DBMS_SQL.close_cursor(v_cursor_id);
2114: END LOOP;

Line 2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);

2107: END IF;
2108:
2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2112: v_count := DBMS_SQL.execute(v_cursor_id);
2113: DBMS_SQL.close_cursor(v_cursor_id);
2114: END LOOP;
2115:

Line 2112: v_count := DBMS_SQL.execute(v_cursor_id);

2108:
2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2112: v_count := DBMS_SQL.execute(v_cursor_id);
2113: DBMS_SQL.close_cursor(v_cursor_id);
2114: END LOOP;
2115:
2116: -- BUYER ID NORMALIZATION

Line 2113: DBMS_SQL.close_cursor(v_cursor_id);

2109: DBMS_SQL.bind_variable(v_cursor_id, ':action_name', v_action);
2110: DBMS_SQL.bind_array(v_cursor_id, ':p_system_action', gSystemActions);
2111: DBMS_SQL.bind_array(v_cursor_id, ':p_item_id', gItemIds);
2112: v_count := DBMS_SQL.execute(v_cursor_id);
2113: DBMS_SQL.close_cursor(v_cursor_id);
2114: END LOOP;
2115:
2116: -- BUYER ID NORMALIZATION
2117: -- Inserts the buyer ids for the items

Line 2137: IF (DBMS_SQL.is_open(v_cursor_id)) THEN

2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: ROLLBACK;
2136:
2137: IF (DBMS_SQL.is_open(v_cursor_id)) THEN
2138: DBMS_SQL.close_cursor(v_cursor_id);
2139: END IF;
2140:
2141: RAISE_APPLICATION_ERROR(-20000,

Line 2138: DBMS_SQL.close_cursor(v_cursor_id);

2134: WHEN OTHERS THEN
2135: ROLLBACK;
2136:
2137: IF (DBMS_SQL.is_open(v_cursor_id)) THEN
2138: DBMS_SQL.close_cursor(v_cursor_id);
2139: END IF;
2140:
2141: RAISE_APPLICATION_ERROR(-20000,
2142: 'Exception at ICX_POR_ITEM_UPLOAD.process_batch_translate('

Line 3280: dbms_sql.urowid_table) IS

3276: END save_required_desc_errors;
3277:
3278: /* Processes failed prices in the current batch */
3279: PROCEDURE process_batch_price_errors(pErrorRowids IN
3280: dbms_sql.urowid_table) IS
3281: i PLS_INTEGER;
3282: CURSOR get_failed_price(p_rowid IN VARCHAR2) IS
3283: SELECT line_number, decode(action, 'SYNC','ADD',action) system_action,
3284: supplier, supplier_part_num, supplier_part_auxid, --Bug#2611529

Line 3340: dbms_sql.urowid_table) IS

3336: END process_batch_price_errors;
3337:
3338: /* Processes failed items in the current batch */
3339: PROCEDURE process_batch_item_errors(pErrorRowids IN
3340: dbms_sql.urowid_table) IS
3341: i PLS_INTEGER;
3342: CURSOR get_failed_line(p_rowid IN VARCHAR2) IS
3343: SELECT * FROM ICX_CAT_ITEMS_GT
3344: WHERE rowid = p_rowid;

Line 3436: vRowids dbms_sql.urowid_table;

3432: it.supplier_part_auxid asc,
3433: it.org_id asc, it.currency asc, it.supplier_site_id asc,
3434: it.line_number desc;
3435:
3436: vRowids dbms_sql.urowid_table;
3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;

Line 3437: vSupplierPartNums dbms_sql.varchar2_table;

3433: it.org_id asc, it.currency asc, it.supplier_site_id asc,
3434: it.line_number desc;
3435:
3436: vRowids dbms_sql.urowid_table;
3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;

Line 3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529

3434: it.line_number desc;
3435:
3436: vRowids dbms_sql.urowid_table;
3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;
3442: vSupplierSiteIds dbms_sql.number_table;

Line 3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529

3435:
3436: vRowids dbms_sql.urowid_table;
3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;
3442: vSupplierSiteIds dbms_sql.number_table;
3443:

Line 3440: vCurrencies dbms_sql.varchar2_table;

3436: vRowids dbms_sql.urowid_table;
3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;
3442: vSupplierSiteIds dbms_sql.number_table;
3443:
3444: vPrevPartNum VARCHAR2(2000) := null;

Line 3441: vOrgIds dbms_sql.number_table;

3437: vSupplierPartNums dbms_sql.varchar2_table;
3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;
3442: vSupplierSiteIds dbms_sql.number_table;
3443:
3444: vPrevPartNum VARCHAR2(2000) := null;
3445: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529

Line 3442: vSupplierSiteIds dbms_sql.number_table;

3438: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3439: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3440: vCurrencies dbms_sql.varchar2_table;
3441: vOrgIds dbms_sql.number_table;
3442: vSupplierSiteIds dbms_sql.number_table;
3443:
3444: vPrevPartNum VARCHAR2(2000) := null;
3445: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3446: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529

Line 3562: vRowids dbms_sql.urowid_table;

3558: AND it.supplier_part_auxid = i.supplier_part_auxid (+) -- Bug#2611529
3559: AND it.org_id = i.org_id(+)
3560: AND it.processed_flag = 'N';
3561:
3562: vRowids dbms_sql.urowid_table;
3563: --DUPE FAILED LINES Contract Auto Sourcing
3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;

Line 3564: vLineNums dbms_sql.number_table;

3560: AND it.processed_flag = 'N';
3561:
3562: vRowids dbms_sql.urowid_table;
3563: --DUPE FAILED LINES Contract Auto Sourcing
3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;

Line 3565: vSupplierPartNums dbms_sql.varchar2_table;

3561:
3562: vRowids dbms_sql.urowid_table;
3563: --DUPE FAILED LINES Contract Auto Sourcing
3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;

Line 3566: vCurrentItemIds dbms_sql.number_table;

3562: vRowids dbms_sql.urowid_table;
3563: --DUPE FAILED LINES Contract Auto Sourcing
3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;

Line 3567: vSystemActions dbms_sql.varchar2_table;

3563: --DUPE FAILED LINES Contract Auto Sourcing
3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;

Line 3568: vActiveFlags dbms_sql.varchar2_table;

3564: vLineNums dbms_sql.number_table;
3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;

Line 3569: vHasErrors dbms_sql.varchar2_table;

3565: vSupplierPartNums dbms_sql.varchar2_table;
3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;

Line 3570: vRowTypes dbms_sql.varchar2_table;

3566: vCurrentItemIds dbms_sql.number_table;
3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;

Line 3571: vPriceTypes dbms_sql.varchar2_table;

3567: vSystemActions dbms_sql.varchar2_table;
3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529

Line 3572: vOrgIds dbms_sql.number_table;

3568: vActiveFlags dbms_sql.varchar2_table;
3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;

Line 3573: vPricelistIds dbms_sql.number_table;

3569: vHasErrors dbms_sql.varchar2_table;
3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;
3577:

Line 3574: vSupplierSiteIds dbms_sql.number_table;

3570: vRowTypes dbms_sql.varchar2_table;
3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;
3577:
3578: -- BUYER NORMALIZATION

Line 3575: vSupplierIds dbms_sql.number_table; --Bug#2611529

3571: vPriceTypes dbms_sql.varchar2_table;
3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;
3577:
3578: -- BUYER NORMALIZATION
3579: vItemJobNums dbms_sql.number_table;

Line 3576: vUoms dbms_sql.varchar2_table;

3572: vOrgIds dbms_sql.number_table;
3573: vPricelistIds dbms_sql.number_table;
3574: vSupplierSiteIds dbms_sql.number_table;
3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;
3577:
3578: -- BUYER NORMALIZATION
3579: vItemJobNums dbms_sql.number_table;
3580: vPrevItemId NUMBER := -1;

Line 3579: vItemJobNums dbms_sql.number_table;

3575: vSupplierIds dbms_sql.number_table; --Bug#2611529
3576: vUoms dbms_sql.varchar2_table;
3577:
3578: -- BUYER NORMALIZATION
3579: vItemJobNums dbms_sql.number_table;
3580: vPrevItemId NUMBER := -1;
3581: vPrevOrgId NUMBER := -1;
3582: vDistinctBuyerCount NUMBER := 0;
3583:

Line 3772: vRowids dbms_sql.urowid_table;

3768: FROM ICX_CAT_ITEMS_GT it
3769: WHERE language = p_language
3770: ORDER BY supplier asc, supplier_part_num asc, supplier_part_auxid asc, org_id asc, supplier_site_id asc, currency asc, line_number desc;
3771:
3772: vRowids dbms_sql.urowid_table;
3773: vSupplierPartNums dbms_sql.varchar2_table;
3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3776: vRowTypes dbms_sql.varchar2_table;

Line 3773: vSupplierPartNums dbms_sql.varchar2_table;

3769: WHERE language = p_language
3770: ORDER BY supplier asc, supplier_part_num asc, supplier_part_auxid asc, org_id asc, supplier_site_id asc, currency asc, line_number desc;
3771:
3772: vRowids dbms_sql.urowid_table;
3773: vSupplierPartNums dbms_sql.varchar2_table;
3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3776: vRowTypes dbms_sql.varchar2_table;
3777: vPrevPartNum VARCHAR2(2000) := null;

Line 3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529

3770: ORDER BY supplier asc, supplier_part_num asc, supplier_part_auxid asc, org_id asc, supplier_site_id asc, currency asc, line_number desc;
3771:
3772: vRowids dbms_sql.urowid_table;
3773: vSupplierPartNums dbms_sql.varchar2_table;
3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3776: vRowTypes dbms_sql.varchar2_table;
3777: vPrevPartNum VARCHAR2(2000) := null;
3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529

Line 3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529

3771:
3772: vRowids dbms_sql.urowid_table;
3773: vSupplierPartNums dbms_sql.varchar2_table;
3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3776: vRowTypes dbms_sql.varchar2_table;
3777: vPrevPartNum VARCHAR2(2000) := null;
3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529

Line 3776: vRowTypes dbms_sql.varchar2_table;

3772: vRowids dbms_sql.urowid_table;
3773: vSupplierPartNums dbms_sql.varchar2_table;
3774: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3775: vSupplierNames dbms_sql.varchar2_table; --Bug#2611529
3776: vRowTypes dbms_sql.varchar2_table;
3777: vPrevPartNum VARCHAR2(2000) := null;
3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529
3780: vOrgIds dbms_sql.varchar2_table;

Line 3780: vOrgIds dbms_sql.varchar2_table;

3776: vRowTypes dbms_sql.varchar2_table;
3777: vPrevPartNum VARCHAR2(2000) := null;
3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529
3780: vOrgIds dbms_sql.varchar2_table;
3781: vCurrencies dbms_sql.varchar2_table;
3782: vSupplierSiteIds dbms_sql.number_table; -- Bug# 3366614 sosingha: for supp site ids
3783: vDupeRowIds dbms_sql.urowid_table; -- Bug# 3366614 sosingha: for row ids of duplicates
3784: vPrevCurrency VARCHAR2(30);

Line 3781: vCurrencies dbms_sql.varchar2_table;

3777: vPrevPartNum VARCHAR2(2000) := null;
3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529
3780: vOrgIds dbms_sql.varchar2_table;
3781: vCurrencies dbms_sql.varchar2_table;
3782: vSupplierSiteIds dbms_sql.number_table; -- Bug# 3366614 sosingha: for supp site ids
3783: vDupeRowIds dbms_sql.urowid_table; -- Bug# 3366614 sosingha: for row ids of duplicates
3784: vPrevCurrency VARCHAR2(30);
3785: vPrevSupplierSiteId NUMBER := -1; -- Bug# 3366614 sosingha: previous supp site ids

Line 3782: vSupplierSiteIds dbms_sql.number_table; -- Bug# 3366614 sosingha: for supp site ids

3778: vPrevPartAuxid VARCHAR2(2000) := null; --Bug#2611529
3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529
3780: vOrgIds dbms_sql.varchar2_table;
3781: vCurrencies dbms_sql.varchar2_table;
3782: vSupplierSiteIds dbms_sql.number_table; -- Bug# 3366614 sosingha: for supp site ids
3783: vDupeRowIds dbms_sql.urowid_table; -- Bug# 3366614 sosingha: for row ids of duplicates
3784: vPrevCurrency VARCHAR2(30);
3785: vPrevSupplierSiteId NUMBER := -1; -- Bug# 3366614 sosingha: previous supp site ids
3786: vPrevOrgId NUMBER;

Line 3783: vDupeRowIds dbms_sql.urowid_table; -- Bug# 3366614 sosingha: for row ids of duplicates

3779: vPrevSupplierName VARCHAR2(2000) := null; --Bug#2611529
3780: vOrgIds dbms_sql.varchar2_table;
3781: vCurrencies dbms_sql.varchar2_table;
3782: vSupplierSiteIds dbms_sql.number_table; -- Bug# 3366614 sosingha: for supp site ids
3783: vDupeRowIds dbms_sql.urowid_table; -- Bug# 3366614 sosingha: for row ids of duplicates
3784: vPrevCurrency VARCHAR2(30);
3785: vPrevSupplierSiteId NUMBER := -1; -- Bug# 3366614 sosingha: previous supp site ids
3786: vPrevOrgId NUMBER;
3787: xErrLoc PLS_INTEGER := 100;

Line 3957: vRowids dbms_sql.urowid_table;

3953: -- Bug# 3366614 sosingha: p_processed_flag willl have a value 'N' first and then 'D' if duplicates exists
3954: -- AND it.processed_flag = 'N';
3955: AND it.processed_flag = p_processed_flag;
3956:
3957: vRowids dbms_sql.urowid_table;
3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;

Line 3958: vSupplierPartNums dbms_sql.varchar2_table;

3954: -- AND it.processed_flag = 'N';
3955: AND it.processed_flag = p_processed_flag;
3956:
3957: vRowids dbms_sql.urowid_table;
3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;

Line 3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328

3955: AND it.processed_flag = p_processed_flag;
3956:
3957: vRowids dbms_sql.urowid_table;
3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;

Line 3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529

3956:
3957: vRowids dbms_sql.urowid_table;
3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;

Line 3961: vCurrentItemIds dbms_sql.number_table;

3957: vRowids dbms_sql.urowid_table;
3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;

Line 3962: vSystemActions dbms_sql.varchar2_table;

3958: vSupplierPartNums dbms_sql.varchar2_table;
3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;

Line 3963: vHasErrors dbms_sql.varchar2_table;

3959: vSuppliers dbms_sql.varchar2_table; --Bug#2729328
3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;

Line 3964: vItemIds dbms_sql.number_table;

3960: vSupplierPartAuxids dbms_sql.varchar2_table; --Bug#2611529
3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;

Line 3965: vRowTypes dbms_sql.varchar2_table;

3961: vCurrentItemIds dbms_sql.number_table;
3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;

Line 3966: vPriceTypes dbms_sql.varchar2_table;

3962: vSystemActions dbms_sql.varchar2_table;
3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;

Line 3967: vCategoryIds dbms_sql.number_table;

3963: vHasErrors dbms_sql.varchar2_table;
3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;

Line 3968: vOldCategoryIds dbms_sql.number_table;

3964: vItemIds dbms_sql.number_table;
3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;

Line 3969: vCategoryNames dbms_sql.varchar2_table;

3965: vRowTypes dbms_sql.varchar2_table;
3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;

Line 3970: vOrgIds dbms_sql.number_table;

3966: vPriceTypes dbms_sql.varchar2_table;
3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;

Line 3971: vPricelistIds dbms_sql.number_table;

3967: vCategoryIds dbms_sql.number_table;
3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;

Line 3972: vSupplierSiteIds dbms_sql.number_table;

3968: vOldCategoryIds dbms_sql.number_table;
3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;

Line 3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;

3969: vCategoryNames dbms_sql.varchar2_table;
3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716

Line 3974: vActiveFlags dbms_sql.varchar2_table;

3970: vOrgIds dbms_sql.number_table;
3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529

Line 3975: vMissingRequired dbms_sql.varchar2_table;

3971: vPricelistIds dbms_sql.number_table;
3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529

Line 3976: vMissingTLRequired dbms_sql.varchar2_table;

3972: vSupplierSiteIds dbms_sql.number_table;
3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529
3980: vGTSystemAction dbms_sql.varchar2_table;

Line 3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716

3973: vExtractorUpdatedFlags dbms_sql.varchar2_table;
3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529
3980: vGTSystemAction dbms_sql.varchar2_table;
3981:

Line 3978: vSupplierIds dbms_sql.number_table; --Bug#2611529

3974: vActiveFlags dbms_sql.varchar2_table;
3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529
3980: vGTSystemAction dbms_sql.varchar2_table;
3981:
3982: vCount PLS_INTEGER := 0;

Line 3979: vUoms dbms_sql.varchar2_table; --Bug#2611529

3975: vMissingRequired dbms_sql.varchar2_table;
3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529
3980: vGTSystemAction dbms_sql.varchar2_table;
3981:
3982: vCount PLS_INTEGER := 0;
3983: vASLCount PLS_INTEGER := 0;

Line 3980: vGTSystemAction dbms_sql.varchar2_table;

3976: vMissingTLRequired dbms_sql.varchar2_table;
3977: vUnitPrices dbms_sql.varchar2_table; --Bug#2733716
3978: vSupplierIds dbms_sql.number_table; --Bug#2611529
3979: vUoms dbms_sql.varchar2_table; --Bug#2611529
3980: vGTSystemAction dbms_sql.varchar2_table;
3981:
3982: vCount PLS_INTEGER := 0;
3983: vASLCount PLS_INTEGER := 0;
3984: vHasAdd BOOLEAN := FALSE;

Line 4979: xLangArray DBMS_SQL.VARCHAR2_TABLE;

4975: -- Category_Change
4976: PROCEDURE handle_category_change (p_action IN VARCHAR2) IS
4977: l_progress VARCHAR2(5) := '100';
4978:
4979: xLangArray DBMS_SQL.VARCHAR2_TABLE;
4980: CURSOR langCsr IS
4981: SELECT language_code
4982: FROM fnd_languages
4983: WHERE installed_flag in ('B', 'I')