DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITM_REGNS

Line 92: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,

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

Line 93: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,

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

Line 107: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

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

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

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

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

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

Line 112: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

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

Line 113: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

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

Line 118: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE

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