68: );
69:
70: TYPE type_rec_rgm_itm_attribs IS RECORD
71: (
72: attribute_code JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE
73: ,attribute_value JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE
74: );
75:
76: TYPE type_tab_attributes IS TABLE OF type_rec_rgm_itm_attribs
69:
70: TYPE type_rec_rgm_itm_attribs IS RECORD
71: (
72: attribute_code JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE
73: ,attribute_value JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE
74: );
75:
76: TYPE type_tab_attributes IS TABLE OF type_rec_rgm_itm_attribs
77: INDEX BY BINARY_INTEGER;
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
98: );
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
98: );
99: /* This function will create template and retrun the newly created template_id */