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 600: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

596: /* India Localization code hook for Base item copy/delete/assignment/import action */
597: PROCEDURE propagate_item_action
598: (
599: pv_action_type IN VARCHAR2
600: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
601: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
602: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
603: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
604: , pn_set_process_id IN NUMBER

Line 601: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

597: PROCEDURE propagate_item_action
598: (
599: pv_action_type IN VARCHAR2
600: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
601: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
602: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
603: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
604: , pn_set_process_id IN NUMBER
605: , pv_called_from IN VARCHAR2

Line 602: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

598: (
599: pv_action_type IN VARCHAR2
600: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
601: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
602: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
603: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
604: , pn_set_process_id IN NUMBER
605: , pv_called_from IN VARCHAR2
606: )

Line 603: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

599: pv_action_type IN VARCHAR2
600: , pn_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
601: , pn_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
602: , pn_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
603: , pn_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
604: , pn_set_process_id IN NUMBER
605: , pv_called_from IN VARCHAR2
606: )
607: IS

Line 613: FROM mtl_system_items_interface intf

609: IS
610: SELECT intf.organization_id organization_id
611: ,intf.inventory_item_id inventory_item_id
612: ,master_org.master_organization_id source_organization_id
613: FROM mtl_system_items_interface intf
614: ,mtl_parameters master_org
615: WHERE intf.process_flag = 7
616: AND intf.transaction_type = 'CREATE'
617: AND intf.request_id = fnd_global.conc_request_id

Line 697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

693: app_exception.raise_exception;
694: END propagate_item_action;
695: /*----------------------------------------------------------------------------------*/
696: PROCEDURE copy_items
697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
698: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
699: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
700: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
701: )

Line 698: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

694: END propagate_item_action;
695: /*----------------------------------------------------------------------------------*/
696: PROCEDURE copy_items
697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
698: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
699: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
700: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
701: )
702: IS

Line 699: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

695: /*----------------------------------------------------------------------------------*/
696: PROCEDURE copy_items
697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
698: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
699: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
700: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
701: )
702: IS
703: ln_items NUMBER := 0;

Line 700: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

696: PROCEDURE copy_items
697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
698: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
699: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
700: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
701: )
702: IS
703: ln_items NUMBER := 0;
704: ln_item_regns_id NUMBER ;

Line 709: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

705: ln_dest_item_regns_id NUMBER ;
706: ln_template_id NUMBER ;
707: ln_dest_template_id NUMBER ;
708:
709: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:

Line 710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

706: ln_template_id NUMBER ;
707: ln_dest_template_id NUMBER ;
708:
709: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:
714: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;

Line 711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

707: ln_dest_template_id NUMBER ;
708:
709: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:
714: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;
715: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';

Line 712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

708:
709: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:
714: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;
715: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';
716:

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

895: app_exception.raise_exception;
896: END copy_items;
897: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
898:
899: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
900: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
901: )
902: IS
903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

Line 900: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

896: END copy_items;
897: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
898:
899: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
900: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
901: )
902: IS
903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
904: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

Line 903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;

899: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
900: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
901: )
902: IS
903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
904: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
905: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
906: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
907: ln_templ_itm_regns NUMBER := NULL;

Line 904: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;

900: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
901: )
902: IS
903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
904: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
905: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
906: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
907: ln_templ_itm_regns NUMBER := NULL;
908: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';