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_INV_ITEMS_PKG

Line 1: PACKAGE BODY jai_inv_items_pkg AS

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 ,

Line 60: Package fie is renamed to JAI_INV_ITEMS_PKG.PLB

56: 1. 22/04/2005 Brathod for Bug # 4299606 (Item DFF Elimination), File Version 116.1
57:
58: Issue:- Item DFF Needs to be eliminated
59:
60: Package fie is renamed to JAI_INV_ITEMS_PKG.PLB
61: -----------------------------------------------
62: 2. 24/05/2005 Brathod, For Bug# 4389149 (Item Code Hook - API), File Version 116.1
63: Issue:-
64: Code hook (API) needs to developed that will be called when item is either

Line 134: jai_inv_items_pkg_b.sql

130:
131: -------------------------------------------------------------------------------------------------------------------------------------------------
132: Current Version Current Bug Dependent Dependency On Files Version Author Date Remarks
133: Of File On Bug/Patchset
134: jai_inv_items_pkg_b.sql
135: --------------------------------------------------------------------------------------------------------------------------------------------------
136: 115.0 4245134 IN60105D2 VAT Objects 115.0 Brathod 17-Mar-2005 Technical Dependacny
137: +4245089
138: --------------------------------------------------------------------------------------------------------------------------------------------------*/

Line 203: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';

199: RETURN NUMBER
200: AS
201:
202: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
203: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
204: BEGIN -- Create Template
205:
206: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
207:

Line 266: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_assign_template';

262: WHERE torg.organization_id = p_organization_id
263: AND torg.template_id = p_template_id;
264:
265: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;
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

Line 384: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE

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
388: IS

Line 396: ltab_attribs jai_inv_items_pkg.GT_ATTRIBUTES%TYPE;

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
400: /* Chekc if item specific registration already exists */

Line 397: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_item_regns';

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
400: /* Chekc if item specific registration already exists */
401: OPEN cur_chk_rgm_item_regns;

Line 438: jai_inv_items_pkg.jai_create_attribs( p_template_id => ''

434: , fnd_global.login_id
435: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
436: END IF;
437:
438: jai_inv_items_pkg.jai_create_attribs( p_template_id => ''
439: ,p_rgm_item_regns_id => ln_rgm_item_regns_id
440: ,p_tab_attributes => p_tab_attributes
441: );
442:

Line 452: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE

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';
456: BEGIN

Line 455: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_attribs';

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';
456: BEGIN
457: /*
458: * For each row in pl-sql table create row in jai_item_templ_attribs
459: */

Line 500: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_synchronize_jmsi';

496: lv_new_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag%type;
497: lv_new_item_tariff JAI_INV_ITM_SETUPS.item_tariff%type;
498: lv_new_item_folio JAI_INV_ITM_SETUPS.item_folio%type;
499: lv_new_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag%type;
500: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_synchronize_jmsi';
501:
502: cursor cur_get_jmsi_row(cpn_synchronization_number number ) is
503: select
504: jmsi.rowid,

Line 627: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.propagate_item_action';

623: AND intf.set_process_id = pn_set_process_id
624: AND intf.organization_id = master_org.organization_id
625: AND intf.organization_id <> master_org.master_organization_id ;
626:
627: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.propagate_item_action';
628:
629: BEGIN
630: /*
631: pv_action_type "IMPORT" indicates to import items from interface.

Line 653: jai_inv_items_pkg.copy_items

649: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
650: app_exception.raise_exception;
651: END IF;
652:
653: jai_inv_items_pkg.copy_items
654: ( pn_organization_id => rec_itms.organization_id
655: ,pn_inventory_item_id => rec_itms.inventory_item_id
656: ,pn_source_organization_id => rec_itms.source_organization_id
657: ,pn_source_inventory_item_id => rec_itms.inventory_item_id

Line 672: jai_inv_items_pkg.copy_items

668: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
669: app_exception.raise_exception;
670: END IF;
671:
672: jai_inv_items_pkg.copy_items
673: ( pn_organization_id => pn_organization_id
674: ,pn_inventory_item_id => pn_inventory_item_id
675: ,pn_source_organization_id => pn_source_organization_id
676: ,pn_source_inventory_item_id => pn_source_inventory_item_id

Line 687: jai_inv_items_pkg.delete_items

683: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
684: app_exception.raise_exception;
685: END IF;
686:
687: jai_inv_items_pkg.delete_items
688: (
689: pn_organization_id => pn_organization_id
690: ,pn_inventory_item_id => pn_inventory_item_id
691: );

Line 720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;

716: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:
720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%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

Line 721: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.copy_items';

717: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
718: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
719:
720: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%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

Line 817: jai_inv_items_pkg.jai_create_item_regns

813: lt_attribs(lt_attribs.count+1).attribute_code := cur_attribs.attribute_code;
814: lt_attribs(lt_attribs.count).attribute_value := cur_attribs.attribute_value;
815: END LOOP;
816:
817: jai_inv_items_pkg.jai_create_item_regns
818: ( p_regime_code => lv_regime_code --replaced jai_constants.excise_regime for bug#9191274
819: ,p_organization_id => ln_organization_id
820: ,p_inventory_item_id => ln_inventory_item_id
821: ,p_tab_attributes => lt_attribs

Line 853: jai_inv_items_pkg.jai_assign_template (p_template_id => ln_template_id

849: /*
850: Source item is assigned to a template and so new item should also
851: be assigned to the same template
852: */
853: jai_inv_items_pkg.jai_assign_template (p_template_id => ln_template_id
854: ,p_organization_id => ln_organization_id
855: ,p_inventory_item_id => ln_inventory_item_id
856: );
857:

Line 919: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.delete_items';

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:
921: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
922: IS
923: SELECT 1

Line 981: end jai_inv_items_pkg;

977: END delete_items;
978: /* -----------------------END OF PROCEDURE DELETE_ITEMS ----------------------------*/
979: /* End of Bug# 4389149 */
980:
981: end jai_inv_items_pkg;