APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITM_TEMPLATES

Line 91: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,

87: /* End of Bug# 4389149 */
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,

Line 100: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE

96: p_process_flag OUT NOCOPY VARCHAR2 ,
97: p_process_msg OUT NOCOPY VARCHAR2
98: );
99: /* This function will create template and retrun the newly created template_id */
100: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
101: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
102: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
103: )
104: RETURN NUMBER;

Line 101: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE

97: p_process_msg OUT NOCOPY VARCHAR2
98: );
99: /* This function will create template and retrun the newly created template_id */
100: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
101: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
102: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
103: )
104: RETURN NUMBER;
105: /* Procedure to assign template to particular / all inventory items in organization */

Line 102: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL

98: );
99: /* This function will create template and retrun the newly created template_id */
100: FUNCTION jai_create_template( p_regime_code JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE
101: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE
102: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
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

Line 106: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

102: , p_description JAI_RGM_ITM_TEMPLATES.DESCRIPTION%TYPE DEFAULT NULL
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 */

Line 117: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_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
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 */