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.JAI_INV_ITEMS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;

25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;
26: -- Added by sacsethi for bug 5631784 on 31-01-2007
27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;
28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;
29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;
30: --END 5631784
31:
32: /* Added by Brathod from bug# 4299606 */
33: CURSOR cur_get_item_attrib

Line 46: FROM MTL_SYSTEM_ITEMS_KFV

42:
43: CURSOR C_GET_ITEM_NAME
44: IS
45: SELECT CONCATENATED_SEGMENTS
46: FROM MTL_SYSTEM_ITEMS_KFV
47: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
48: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
49: --END 5631784
50: BEGIN

Line 605: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

601: /* India Localization code hook for Base item copy/delete/assignment/import action */
602: PROCEDURE propagate_item_action
603: (
604: pv_action_type IN VARCHAR2
605: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
606: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
607: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
608: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
609: , pn_set_process_id IN NUMBER

Line 606: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

602: PROCEDURE propagate_item_action
603: (
604: pv_action_type IN VARCHAR2
605: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
606: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
607: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
608: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
609: , pn_set_process_id IN NUMBER
610: , pv_called_from IN VARCHAR2

Line 607: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

603: (
604: pv_action_type IN VARCHAR2
605: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
606: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
607: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
608: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
609: , pn_set_process_id IN NUMBER
610: , pv_called_from IN VARCHAR2
611: )

Line 608: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

604: pv_action_type IN VARCHAR2
605: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
606: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
607: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
608: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
609: , pn_set_process_id IN NUMBER
610: , pv_called_from IN VARCHAR2
611: )
612: IS

Line 618: FROM mtl_system_items_interface intf

614: IS
615: SELECT intf.organization_id organization_id
616: ,intf.inventory_item_id inventory_item_id
617: ,master_org.master_organization_id source_organization_id
618: FROM mtl_system_items_interface intf
619: ,mtl_parameters master_org
620: WHERE intf.process_flag = 7
621: AND intf.transaction_type = 'CREATE'
622: AND intf.request_id = fnd_global.conc_request_id

Line 702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

698: app_exception.raise_exception;
699: END propagate_item_action;
700: /*----------------------------------------------------------------------------------*/
701: PROCEDURE copy_items
702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274

Line 703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

699: END propagate_item_action;
700: /*----------------------------------------------------------------------------------*/
701: PROCEDURE copy_items
702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
707: )

Line 704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

700: /*----------------------------------------------------------------------------------*/
701: PROCEDURE copy_items
702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
707: )
708: IS

Line 705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

701: PROCEDURE copy_items
702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
707: )
708: IS
709: ln_items NUMBER := 0;

Line 715: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

711: ln_dest_item_regns_id NUMBER ;
712: ln_template_id NUMBER ;
713: ln_dest_template_id NUMBER ;
714:
715: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:

Line 716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

712: ln_template_id NUMBER ;
713: ln_dest_template_id NUMBER ;
714:
715: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:
720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;

Line 717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

713: ln_dest_template_id NUMBER ;
714:
715: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:
720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;
721: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';

Line 718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

714:
715: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:
720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;
721: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';
722: lv_regime_code VARCHAR2(15);

Line 910: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

906: app_exception.raise_exception;
907: END copy_items;
908: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
909:
910: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
911: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
912: )
913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

Line 911: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

907: END copy_items;
908: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
909:
910: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
911: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
912: )
913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

Line 914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

910: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
911: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
912: )
913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
916: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
917: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
918: ln_templ_itm_regns NUMBER := NULL;

Line 915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

911: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
912: )
913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
916: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
917: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
918: ln_templ_itm_regns NUMBER := NULL;
919: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';