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 JAI_RGM_ITM_REGNS

Line 96: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,

92:
93: /* API to find out attribute of particular inventory item */
94: PROCEDURE jai_get_attrib
95: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,
96: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,
97: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,
98: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,
99: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,
100: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 97: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,

93: /* API to find out attribute of particular inventory item */
94: PROCEDURE jai_get_attrib
95: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,
96: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,
97: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,
98: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,
99: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,
100: p_process_flag OUT NOCOPY VARCHAR2 ,
101: p_process_msg OUT NOCOPY VARCHAR2

Line 111: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

107: )
108: RETURN NUMBER;
109: /* Procedure to assign template to particular / all inventory items in organization */
110: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
111: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
112: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
113: ) ;
114: /* Procedure to create item specific registration */
115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

Line 112: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

108: RETURN NUMBER;
109: /* Procedure to assign template to particular / all inventory items in organization */
110: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
111: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
112: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
113: ) ;
114: /* Procedure to create item specific registration */
115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
116: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

Line 115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

111: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
112: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
113: ) ;
114: /* Procedure to create item specific registration */
115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
116: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
117: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
118: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
119: );

Line 116: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

112: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
113: ) ;
114: /* Procedure to create item specific registration */
115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
116: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
117: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
118: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
119: );
120: /* Procedure will create either item/template attributes based on attributes passed as pl-sql table */

Line 117: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

113: ) ;
114: /* Procedure to create item specific registration */
115: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
116: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
117: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
118: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
119: );
120: /* Procedure will create either item/template attributes based on attributes passed as pl-sql table */
121: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

Line 122: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE

118: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
119: );
120: /* Procedure will create either item/template attributes based on attributes passed as pl-sql table */
121: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
122: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE
123: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
124: );
125: /* Synchronization procedure for JAI_INV_ITM_SETUPS table */
126: PROCEDURE jai_synchronize_jmsi (p_synchronization_number JAI_INV_ITM_SETUPS.SYNCHRONIZATION_NUMBER%TYPE DEFAULT NULL

Line 148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274

144: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
145: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
146: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
147: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
148: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
149: );
150:
151: PROCEDURE delete_items
152: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE