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.GMIVDBL dependencies on GMI_ITEM_CATEGORIES

Line 52: | classes. 1) Moved the call to gmi_item_categories from |

48: | retrieval for gmi_item_conv_audit to |
49: | gmi_conv_audit_id_s. Was incorrectly calling |
50: | gmi_conv_audit_detail_id_s. |
51: | 11-Sep-2003 Teresa Wong B2378017 - Modified code to support new |
52: | classes. 1) Moved the call to gmi_item_categories from |
53: | ic_item_mst_insert to GMIGAPIB.Create_Item. 2) Added |
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. |

Line 54: | p_item_rec parameter to gmi_item_categories. 3) Added |

50: | gmi_conv_audit_detail_id_s. |
51: | 11-Sep-2003 Teresa Wong B2378017 - Modified code to support new |
52: | classes. 1) Moved the call to gmi_item_categories from |
53: | ic_item_mst_insert to GMIGAPIB.Create_Item. 2) Added |
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 |

Line 56: | gmi_item_categories_insert. |

52: | classes. 1) Moved the call to gmi_item_categories from |
53: | ic_item_mst_insert to GMIGAPIB.Create_Item. 2) Added |
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. |

Line 60: | GMI_ITEM_CATEGORIES_INSERT procedure. |

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 */
64: /* the table being accessed and return rowtype records, also appropriate to */

Line 297: -- TKW 9/11/2003 B2378017 Moved gmi_item_categories to Create_Item procedure.

293: );
294:
295: GMIGUTL.DB_ERRNUM := NULL;
296:
297: -- TKW 9/11/2003 B2378017 Moved gmi_item_categories to Create_Item procedure.
298: --Jalaj Srivastava Bug 1735676
299: --Item Categories convergence
300: -- gmi_item_categories(x_ic_item_mst_row);
301:

Line 300: -- gmi_item_categories(x_ic_item_mst_row);

296:
297: -- TKW 9/11/2003 B2378017 Moved gmi_item_categories to Create_Item procedure.
298: --Jalaj Srivastava Bug 1735676
299: --Item Categories convergence
300: -- gmi_item_categories(x_ic_item_mst_row);
301:
302: RETURN TRUE;
303:
304: EXCEPTION

Line 416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)

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)
417: IS
418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS
419: SELECT gmi.category_set_id,mtl.structure_id
420: FROM gmi_category_sets gmi,

Line 437: gmi_item_categories_insert(p_ic_item_mst_row,

433: OPEN get_category_set_id('ALLOC_CLASS');
434: FETCH get_category_set_id into l_category_set_id,l_structure_id;
435: CLOSE get_category_set_id;
436:
437: gmi_item_categories_insert(p_ic_item_mst_row,
438: l_category_set_id,
439: p_ic_item_mst_row.alloc_class,
440: l_structure_id,
441: l_category_id);

Line 454: gmi_item_categories_insert(p_ic_item_mst_row,

450: OPEN get_category_set_id('COST_CLASS');
451: FETCH get_category_set_id into l_category_set_id,l_structure_id;
452: CLOSE get_category_set_id;
453:
454: gmi_item_categories_insert(p_ic_item_mst_row,
455: l_category_set_id,
456: p_ic_item_mst_row.itemcost_class,
457: l_structure_id,
458: l_category_id);

Line 471: gmi_item_categories_insert(p_ic_item_mst_row,

467: OPEN get_category_set_id('CUSTOMS_CLASS');
468: FETCH get_category_set_id into l_category_set_id,l_structure_id;
469: CLOSE get_category_set_id;
470:
471: gmi_item_categories_insert(p_ic_item_mst_row,
472: l_category_set_id,
473: p_ic_item_mst_row.customs_class,
474: l_structure_id,
475: l_category_id);

Line 489: gmi_item_categories_insert(p_ic_item_mst_row,

485: OPEN get_category_set_id('FRT_CLASS');
486: FETCH get_category_set_id into l_category_set_id,l_structure_id;
487: CLOSE get_category_set_id;
488:
489: gmi_item_categories_insert(p_ic_item_mst_row,
490: l_category_set_id,
491: p_ic_item_mst_row.frt_class,
492: l_structure_id,
493: l_category_id);

Line 507: gmi_item_categories_insert(p_ic_item_mst_row,

503: OPEN get_category_set_id('GL_CLASS');
504: FETCH get_category_set_id into l_category_set_id,l_structure_id;
505: CLOSE get_category_set_id;
506:
507: gmi_item_categories_insert(p_ic_item_mst_row,
508: l_category_set_id,
509: p_ic_item_mst_row.gl_class,
510: l_structure_id,
511: l_category_id);

Line 524: gmi_item_categories_insert(p_ic_item_mst_row,

520: OPEN get_category_set_id('INV_CLASS');
521: FETCH get_category_set_id into l_category_set_id,l_structure_id;
522: CLOSE get_category_set_id;
523:
524: gmi_item_categories_insert(p_ic_item_mst_row,
525: l_category_set_id,
526: p_ic_item_mst_row.inv_class,
527: l_structure_id,
528: l_category_id);

Line 541: gmi_item_categories_insert(p_ic_item_mst_row,

537: OPEN get_category_set_id('PRICE_CLASS');
538: FETCH get_category_set_id into l_category_set_id,l_structure_id;
539: CLOSE get_category_set_id;
540:
541: gmi_item_categories_insert(p_ic_item_mst_row,
542: l_category_set_id,
543: p_ic_item_mst_row.price_class,
544: l_structure_id,
545: l_category_id);

Line 558: gmi_item_categories_insert(p_ic_item_mst_row,

554: OPEN get_category_set_id('PURCH_CLASS');
555: FETCH get_category_set_id into l_category_set_id,l_structure_id;
556: CLOSE get_category_set_id;
557:
558: gmi_item_categories_insert(p_ic_item_mst_row,
559: l_category_set_id,
560: p_ic_item_mst_row.purch_class,
561: l_structure_id,
562: l_category_id);

Line 576: gmi_item_categories_insert(p_ic_item_mst_row,

572: OPEN get_category_set_id('SALES_CLASS');
573: FETCH get_category_set_id into l_category_set_id,l_structure_id;
574: CLOSE get_category_set_id;
575:
576: gmi_item_categories_insert(p_ic_item_mst_row,
577: l_category_set_id,
578: p_ic_item_mst_row.sales_class,
579: l_structure_id,
580: l_category_id);

Line 594: gmi_item_categories_insert(p_ic_item_mst_row,

590: OPEN get_category_set_id('SHIP_CLASS');
591: FETCH get_category_set_id into l_category_set_id,l_structure_id;
592: CLOSE get_category_set_id;
593:
594: gmi_item_categories_insert(p_ic_item_mst_row,
595: l_category_set_id,
596: p_ic_item_mst_row.ship_class,
597: l_structure_id,
598: l_category_id);

Line 612: gmi_item_categories_insert(p_ic_item_mst_row,

608: OPEN get_category_set_id('STORAGE_CLASS');
609: FETCH get_category_set_id into l_category_set_id,l_structure_id;
610: CLOSE get_category_set_id;
611:
612: gmi_item_categories_insert(p_ic_item_mst_row,
613: l_category_set_id,
614: p_ic_item_mst_row.storage_class,
615: l_structure_id,
616: l_category_id);

Line 630: gmi_item_categories_insert(p_ic_item_mst_row,

626: OPEN get_category_set_id('TAX_CLASS');
627: FETCH get_category_set_id into l_category_set_id,l_structure_id;
628: CLOSE get_category_set_id;
629:
630: gmi_item_categories_insert(p_ic_item_mst_row,
631: l_category_set_id,
632: p_ic_item_mst_row.tax_class,
633: l_structure_id,
634: l_category_id);

Line 673: gmi_item_categories_insert(p_ic_item_mst_row,

669: OPEN get_category_set_id('PLANNING_CLASS');
670: FETCH get_category_set_id into l_category_set_id,l_structure_id;
671: CLOSE get_category_set_id;
672:
673: gmi_item_categories_insert(p_ic_item_mst_row,
674: l_category_set_id,
675: p_ic_item_mst_row.planning_class,
676: l_structure_id,
677: l_category_id);

Line 691: gmi_item_categories_insert(p_ic_item_mst_row,

687: OPEN get_category_set_id('SEQ_CLASS');
688: FETCH get_category_set_id into l_category_set_id,l_structure_id;
689: CLOSE get_category_set_id;
690:
691: gmi_item_categories_insert(p_ic_item_mst_row,
692: l_category_set_id,
693: p_ic_item_mst_row.seq_dpnd_class,
694: l_structure_id,
695: l_category_id);

Line 709: gmi_item_categories_insert(p_ic_item_mst_row,

705: OPEN get_category_set_id('GL_BUSINESS_CLASS');
706: FETCH get_category_set_id into l_category_set_id,l_structure_id;
707: CLOSE get_category_set_id;
708:
709: gmi_item_categories_insert(p_ic_item_mst_row,
710: l_category_set_id,
711: p_item_rec.gl_business_class,
712: l_structure_id,
713: l_category_id);

Line 724: gmi_item_categories_insert(p_ic_item_mst_row,

720: OPEN get_category_set_id('GL_PRODUCT_LINE');
721: FETCH get_category_set_id into l_category_set_id,l_structure_id;
722: CLOSE get_category_set_id;
723:
724: gmi_item_categories_insert(p_ic_item_mst_row,
725: l_category_set_id,
726: p_item_rec.gl_prod_line,
727: l_structure_id,
728: l_category_id);

Line 739: gmi_item_categories_insert(p_ic_item_mst_row,

735: OPEN get_category_set_id('SUB_STANDARD_CLASS');
736: FETCH get_category_set_id into l_category_set_id,l_structure_id;
737: CLOSE get_category_set_id;
738:
739: gmi_item_categories_insert(p_ic_item_mst_row,
740: l_category_set_id,
741: p_item_rec.sub_standard_class,
742: l_structure_id,
743: l_category_id);

Line 754: gmi_item_categories_insert(p_ic_item_mst_row,

750: OPEN get_category_set_id('TECH_CLASS');
751: FETCH get_category_set_id into l_category_set_id,l_structure_id;
752: CLOSE get_category_set_id;
753:
754: gmi_item_categories_insert(p_ic_item_mst_row,
755: l_category_set_id,
756: p_item_rec.tech_class,
757: l_structure_id,
758: l_category_id);

Line 762: END GMI_ITEM_CATEGORIES;

758: l_category_id);
759:
760: END IF;
761:
762: END GMI_ITEM_CATEGORIES;
763:
764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
765: p_category_set_id NUMBER,
766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,

Line 764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,

760: END IF;
761:
762: END GMI_ITEM_CATEGORIES;
763:
764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
765: p_category_set_id NUMBER,
766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,
767: p_structure_id NUMBER,
768: p_category_id IN OUT NOCOPY NUMBER)

Line 782: INSERT INTO gmi_item_categories(

778: OPEN get_category_id(p_category_concat_segs,p_structure_id);
779: FETCH get_category_id INTO p_category_id;
780: CLOSE get_category_id;
781:
782: INSERT INTO gmi_item_categories(
783: item_id,
784: category_set_id,
785: category_id,
786: created_by,

Line 804: END GMI_ITEM_CATEGORIES_INSERT;

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
808: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)