[Home] [Help]
54: | p_item_rec parameter to gmi_item_categories. 3) Added |
55: | code to get category set information and to call |
56: | gmi_item_categories_insert. |
57: | 24-Feb-2004 Anoop Baddam B3151733 - Added a new procedure |
58: | mtl_item_categories_insert that inserts data into |
59: | mtl_item_categories table. This procedure is called from|
60: | GMI_ITEM_CATEGORIES_INSERT procedure. |
61: +=========================================================================+
62: */
55: | code to get category set information and to call |
56: | gmi_item_categories_insert. |
57: | 24-Feb-2004 Anoop Baddam B3151733 - Added a new procedure |
58: | mtl_item_categories_insert that inserts data into |
59: | mtl_item_categories table. This procedure is called from|
60: | GMI_ITEM_CATEGORIES_INSERT procedure. |
61: +=========================================================================+
62: */
63: /* All of the following routines take a rowtype record appropriate to */
316: END ic_item_mst_insert;
317:
318:
319: --BEGIN BUG#3151733 Anoop.
320: PROCEDURE mtl_item_categories_insert(p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
321: l_category_set_id IN NUMBER,l_category_id IN NUMBER)
322: IS
323: CURSOR c_inventory_org IS
324: SELECT organization_id
354: FOR Cur_get_organizations_rec IN c_inventory_org
355: LOOP
356:
357: IF (l_mult_item_cat_assign_flag = 'N') THEN
358: UPDATE mtl_item_categories
359: SET category_id = l_category_id
360: WHERE inventory_item_id = l_inventory_item_id
361: AND organization_id = Cur_get_organizations_rec.organization_id
362: AND category_set_id = l_category_set_id;
363: END IF;
364:
365: IF ( (SQL%ROWCOUNT = 0) OR
366: (l_mult_item_cat_assign_flag = 'Y')) THEN
367: INSERT INTO mtl_item_categories(
368: INVENTORY_ITEM_ID,
369: ORGANIZATION_ID,
370: CATEGORY_SET_ID,
371: CATEGORY_ID,
408:
409: GMIGUTL.DB_ERRNUM := SQLCODE;
410: GMIGUTL.DB_ERRMSG:= SQLERRM;
411:
412: END mtl_item_categories_insert;
413: --END BUG#3151733 Anoop.
414:
415: -- TKW 9/11/2003 B2378017 Changed signature of proc below.
416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );
802: --BUG#3151733 Anoop.
803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);
804: END GMI_ITEM_CATEGORIES_INSERT;
805:
806:
807: FUNCTION ic_item_mst_select