APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITM_TEMPLATES

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

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

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

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

Line 105: , p_template_name JAI_RGM_ITM_TEMPLATES.TEMPLATE_NAME%TYPE

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

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

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

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

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

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