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_TMPL_ATTRS

Line 7: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,

3: PROCEDURE jai_get_attrib
4: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,
5: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,
6: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,
7: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,
8: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,
9: p_process_flag OUT NOCOPY VARCHAR2 ,
10: p_process_msg OUT NOCOPY VARCHAR2
11: )

Line 8: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,

4: ( p_regime_code IN JAI_RGM_ITM_TEMPLATES.REGIME_CODE%TYPE ,
5: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,
6: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,
7: p_attribute_code IN JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_CODE%TYPE,
8: p_attribute_value OUT NOCOPY JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE,
9: p_process_flag OUT NOCOPY VARCHAR2 ,
10: p_process_msg OUT NOCOPY VARCHAR2
11: )
12: IS

Line 25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;

21: || process_msg VARCHAR2 (1000) ;
22: || process_flag VARCHAR2 (2);
23: ************************************************************************************/
24:
25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;
26: -- Added by sacsethi for bug 5631784 on 31-01-2007
27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;
28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;
29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;

Line 27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;

23: ************************************************************************************/
24:
25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;
26: -- Added by sacsethi for bug 5631784 on 31-01-2007
27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;
28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;
29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;
30: --END 5631784
31:

Line 28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;

24:
25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;
26: -- Added by sacsethi for bug 5631784 on 31-01-2007
27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;
28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;
29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;
30: --END 5631784
31:
32: /* Added by Brathod from bug# 4299606 */

Line 461: INSERT INTO JAI_RGM_ITM_TMPL_ATTRS(

457: /*
458: * For each row in pl-sql table create row in jai_item_templ_attribs
459: */
460: FOR ln_attrib IN 1..p_tab_attributes.COUNT LOOP
461: INSERT INTO JAI_RGM_ITM_TMPL_ATTRS(
462: ITM_TEMPL_ATTRIBUTE_ID,
463: TEMPLATE_ID,
464: RGM_ITEM_REGNS_ID,
465: ATTRIBUTE_CODE,

Line 472: ) VALUES (JAI_RGM_ITM_TMPL_ATTRS_S.nextval

468: CREATED_BY,
469: LAST_UPDATE_DATE,
470: LAST_UPDATE_LOGIN,
471: LAST_UPDATED_BY
472: ) VALUES (JAI_RGM_ITM_TMPL_ATTRS_S.nextval
473: ,p_template_id
474: ,p_rgm_item_regns_id
475: ,p_tab_attributes(ln_attrib).attribute_code
476: ,p_tab_attributes(ln_attrib).attribute_value

Line 744: FROM JAI_RGM_ITM_TMPL_ATTRS

740: SELECT template_id
741: ,rgm_item_regns_id
742: ,attribute_code
743: ,attribute_value
744: FROM JAI_RGM_ITM_TMPL_ATTRS
745: WHERE (( template_id = cpn_itm_templ_id AND cpv_itm_templ_flg = 'T')
746: OR
747: ( rgm_item_regns_id = cpn_itm_templ_id AND cpv_itm_templ_flg = 'I')
748: );

Line 938: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS

934: AND regime_code = jai_constants.excise_regime
935: RETURNING rgm_item_regns_id INTO ln_rgm_item_regns_id;
936:
937: IF ln_rgm_item_regns_id IS NOT NULL THEN
938: DELETE FROM JAI_RGM_ITM_TMPL_ATTRS
939: WHERE rgm_item_regns_id = ln_rgm_item_regns_id;
940: END IF;
941:
942: DELETE FROM JAI_RGM_TMPL_ITM_REGNS