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.6 2012/05/23 08:40:50 zxin 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.6 2012/05/23 08:40:50 zxin 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 246: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

242: END jai_create_template;
243: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
244:
245: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
246: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
247: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
248: )
249: AS
250:

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

243: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
244:
245: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
246: , p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
247: , p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
248: )
249: AS
250:
251: CURSOR cur_get_items

Line 270: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

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

Line 271: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

267:
268: /* -------------------------------------- Local Procedure ---------------------------------------*/
269: PROCEDURE assign_template (p_templ_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
270: ,p_org_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
271: ,p_inv_itm_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
272: ,p_templ_org_regns_id IN OUT NOCOPY JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE
273: )
274: AS
275:

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

377: app_exception.raise_exception;
378: END jai_assign_template;
379:
380: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
381: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
382: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
383: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
384: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
385: )

Line 382: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

378: END jai_assign_template;
379:
380: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
381: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
382: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
383: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
384: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
385: )
386: AS

Line 383: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

379:
380: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
381: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
382: ,p_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
383: ,p_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
384: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE
385: )
386: AS
387: CURSOR cur_chk_rgm_item_regns

Line 390: FROM JAI_RGM_ITM_REGNS rirg

386: AS
387: CURSOR cur_chk_rgm_item_regns
388: IS
389: SELECT rgm_item_regns_id
390: FROM JAI_RGM_ITM_REGNS rirg
391: WHERE rirg.regime_code = p_regime_code
392: AND rirg.organization_id = p_organization_id
393: AND rirg.inventory_item_id = p_inventory_item_id;
394:

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

391: WHERE rirg.regime_code = p_regime_code
392: AND rirg.organization_id = p_organization_id
393: AND rirg.inventory_item_id = p_inventory_item_id;
394:
395: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL;
396: ltab_attribs jai_inv_items_pkg.GT_ATTRIBUTES%TYPE;
397: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_item_regns';
398:
399: BEGIN

Line 408: * JAI_RGM_ITM_REGNS

404:
405: IF ln_rgm_item_regns_id IS NULL THEN
406: /*
407: * Item specific registration does not exist so create one by inserting a row in
408: * JAI_RGM_ITM_REGNS
409: */
410:
411: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
412:

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

407: * Item specific registration does not exist so create one by inserting a row in
408: * JAI_RGM_ITM_REGNS
409: */
410:
411: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
412:
413: INSERT INTO JAI_RGM_ITM_REGNS
414: ( rgm_item_regns_id
415: ,regime_code

Line 413: INSERT INTO JAI_RGM_ITM_REGNS

409: */
410:
411: --SELECT JAI_RGM_ITM_REGNS_S.NEXTVAL INTO ln_rgm_item_regns_id FROM DUAL;
412:
413: INSERT INTO JAI_RGM_ITM_REGNS
414: ( rgm_item_regns_id
415: ,regime_code
416: ,organization_id
417: ,inventory_item_id

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

422: ,last_update_login
423: )
424: VALUES(
425: --ln_rgm_item_regns_id
426: JAI_RGM_ITM_REGNS_S.NEXTVAL /* Modified by Ramananda for removal of SQL LITERALs */
427: , p_regime_code
428: , p_organization_id
429: , p_inventory_item_id
430: , sysdate

Line 451: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE

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

Line 706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274

702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
703: ,pn_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
704: ,pn_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
705: ,pn_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
706: ,pn_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE DEFAULT 'EXCISE' --added for bug#9191274
707: )
708: IS
709: ln_items NUMBER := 0;
710: ln_item_regns_id NUMBER ;

Line 725: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

721: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';
722: lv_regime_code VARCHAR2(15);
723:
724: CURSOR cur_get_item_regns
725: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
726: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
727: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
728: )
729: IS

Line 726: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

722: lv_regime_code VARCHAR2(15);
723:
724: CURSOR cur_get_item_regns
725: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
726: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
727: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
728: )
729: IS
730: SELECT rgm_item_regns_id

Line 727: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

723:
724: CURSOR cur_get_item_regns
725: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
726: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
727: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
728: )
729: IS
730: SELECT rgm_item_regns_id
731: FROM JAI_RGM_ITM_REGNS

Line 731: FROM JAI_RGM_ITM_REGNS

727: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
728: )
729: IS
730: SELECT rgm_item_regns_id
731: FROM JAI_RGM_ITM_REGNS
732: WHERE regime_code = cpv_regime_code
733: AND organization_id = cpn_organization_id
734: AND inventory_item_id = cpn_inventory_item_id;
735:

Line 751: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

747: ( rgm_item_regns_id = cpn_itm_templ_id AND cpv_itm_templ_flg = 'I')
748: );
749:
750: CURSOR cur_get_template_id
751: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
752: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
753: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
754: )
755: IS

Line 752: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE

748: );
749:
750: CURSOR cur_get_template_id
751: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
752: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
753: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
754: )
755: IS
756: SELECT torg.template_id

Line 753: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE

749:
750: CURSOR cur_get_template_id
751: (cpv_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE
752: ,cpn_organization_id JAI_RGM_ITM_REGNS.ORGANIZATION_ID%TYPE
753: ,cpn_inventory_item_id JAI_RGM_ITM_REGNS.INVENTORY_ITEM_ID%TYPE
754: )
755: IS
756: SELECT torg.template_id
757: FROM JAI_RGM_TMPL_ITM_REGNS tirg

Line 916: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;

912: )
913: IS
914: ln_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
915: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
916: ln_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE;
917: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE;
918: ln_templ_itm_regns NUMBER := NULL;
919: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';
920:

Line 931: DELETE FROM JAI_RGM_ITM_REGNS

927: BEGIN
928: ln_organization_id := pn_organization_id;
929: ln_inventory_item_id := pn_inventory_item_id;
930:
931: DELETE FROM JAI_RGM_ITM_REGNS
932: WHERE inventory_item_id = ln_inventory_item_id
933: AND organization_id = ln_organization_id
934: AND regime_code = jai_constants.excise_regime
935: RETURNING rgm_item_regns_id INTO ln_rgm_item_regns_id;