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_REGNS

Line 5: p_organization_id IN JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE ,

1: PACKAGE BODY jai_inv_items_pkg AS
2: /* $Header: jai_inv_items.plb 120.4 2007/02/26 17:25:43 sacsethi ship $ */
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 ,

Line 6: p_inventory_item_id IN JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE ,

2: /* $Header: jai_inv_items.plb 120.4 2007/02/26 17:25:43 sacsethi ship $ */
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

Line 241: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

237: END jai_create_template;
238: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
239:
240: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
241: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
242: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
243: )
244: AS
245:

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

238: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
239:
240: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
241: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
242: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
243: )
244: AS
245:
246: CURSOR cur_get_items

Line 265: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

261: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_assign_template';
262:
263: /* -------------------------------------- Local Procedure ---------------------------------------*/
264: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
265: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
266: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
267: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE
268: )
269: AS

Line 266: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

262:
263: /* -------------------------------------- Local Procedure ---------------------------------------*/
264: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
265: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
266: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
267: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE
268: )
269: AS
270:

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

372: app_exception.raise_exception;
373: END jai_assign_template;
374:
375: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
376: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
377: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
378: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
379: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
380: )

Line 377: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

373: END jai_assign_template;
374:
375: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
376: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
377: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
378: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
379: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
380: )
381: AS

Line 378: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

374:
375: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
376: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
377: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
378: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
379: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
380: )
381: AS
382: CURSOR cur_chk_rgm_item_regns

Line 385: FROM JAI_RGM_ITM_REGNS rirg

381: AS
382: CURSOR cur_chk_rgm_item_regns
383: IS
384: SELECT rgm_item_regns_id
385: FROM JAI_RGM_ITM_REGNS rirg
386: WHERE rirg.regime_code = p_regime_code
387: AND rirg.organization_id = p_organization_id
388: AND rirg.inventory_item_id = p_inventory_item_id;
389:

Line 390: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL;

386: WHERE rirg.regime_code = p_regime_code
387: AND rirg.organization_id = p_organization_id
388: AND rirg.inventory_item_id = p_inventory_item_id;
389:
390: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL;
391: ltab_attribs jai_inv_items_pkg.GT_ATTRIBUTES%TYPE;
392: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_item_regns';
393:
394: BEGIN

Line 403: * JAI_RGM_ITM_REGNS

399:
400: IF ln_rgm_item_regns_id IS NULL THEN
401: /*
402: * Item specific registration does not exist so create one by inserting a row in
403: * JAI_RGM_ITM_REGNS
404: */
405:
406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
407:

Line 406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;

402: * Item specific registration does not exist so create one by inserting a row in
403: * JAI_RGM_ITM_REGNS
404: */
405:
406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
407:
408: INSERT INTO JAI_RGM_ITM_REGNS
409: ( rgm_item_regns_id
410: ,regime_code

Line 408: INSERT INTO JAI_RGM_ITM_REGNS

404: */
405:
406: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
407:
408: INSERT INTO JAI_RGM_ITM_REGNS
409: ( rgm_item_regns_id
410: ,regime_code
411: ,organization_id
412: ,inventory_item_id

Line 421: JAI_RGM_ITM_REGNS_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */

417: ,last_update_login
418: )
419: VALUES(
420: --ln_rgm_item_regns_id
421: JAI_RGM_ITM_REGNS_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */
422: , p_regime_code
423: , p_organization_id
424: , p_inventory_item_id
425: , sysdate

Line 446: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE

442: app_exception.raise_exception;
443: END jai_create_item_regns ;
444: /* -------------------------------------- CREATE TEMPLATE ATTRIBUTES ------------------------------*/
445: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
446: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE
447: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
448: )
449: IS
450: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_attribs';

Line 718: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

714: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;
715: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';
716:
717: CURSOR cur_get_item_regns
718: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
719: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
720: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
721: )
722: IS

Line 719: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

715: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';
716:
717: CURSOR cur_get_item_regns
718: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
719: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
720: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
721: )
722: IS
723: SELECT rgm_item_regns_id

Line 720: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

716:
717: CURSOR cur_get_item_regns
718: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
719: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
720: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
721: )
722: IS
723: SELECT rgm_item_regns_id
724: FROM JAI_RGM_ITM_REGNS

Line 724: FROM JAI_RGM_ITM_REGNS

720: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
721: )
722: IS
723: SELECT rgm_item_regns_id
724: FROM JAI_RGM_ITM_REGNS
725: WHERE regime_code = cpv_regime_code
726: AND organization_id = cpn_organization_id
727: AND inventory_item_id = cpn_inventory_item_id;
728:

Line 744: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

740: ( rgm_item_regns_id = cpn_itm_templ_id AND cpv_itm_templ_flg = 'I')
741: );
742:
743: CURSOR cur_get_template_id
744: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
745: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
746: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
747: )
748: IS

Line 745: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

741: );
742:
743: CURSOR cur_get_template_id
744: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
745: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
746: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
747: )
748: IS
749: SELECT torg.template_id

Line 746: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

742:
743: CURSOR cur_get_template_id
744: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
745: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
746: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
747: )
748: IS
749: SELECT torg.template_id
750: FROM JAI_RGM_TMPL_ITM_REGNS tirg

Line 905: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;

901: )
902: IS
903: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
904: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
905: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
906: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
907: ln_templ_itm_regns NUMBER := NULL;
908: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';
909:

Line 920: DELETE FROM JAI_RGM_ITM_REGNS

916: BEGIN
917: ln_organization_id := pn_organization_id;
918: ln_inventory_item_id := pn_inventory_item_id;
919:
920: DELETE FROM JAI_RGM_ITM_REGNS
921: WHERE inventory_item_id = ln_inventory_item_id
922: AND organization_id = ln_organization_id
923: AND regime_code = jai_constants.excise_regime
924: RETURNING rgm_item_regns_id INTO ln_rgm_item_regns_id;