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.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 ,

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 129: jai_inv_items_pkg_b.sql

125:
126: -------------------------------------------------------------------------------------------------------------------------------------------------
127: Current Version Current Bug Dependent Dependency On Files Version Author Date Remarks
128: Of File On Bug/Patchset
129: jai_inv_items_pkg_b.sql
130: --------------------------------------------------------------------------------------------------------------------------------------------------
131: 115.0 4245134 IN60105D2 VAT Objects 115.0 Brathod 17-Mar-2005 Technical Dependacny
132: +4245089
133: --------------------------------------------------------------------------------------------------------------------------------------------------*/

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

194: RETURN NUMBER
195: AS
196:
197: ln_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE DEFAULT NULL;
198: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_create_template';
199: BEGIN -- Create Template
200:
201: --SELECT JAI_RGM_ITM_TEMPLATES_S.NEXTVAL INTO ln_template_id FROM DUAL;
202:

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

257: WHERE torg.organization_id = p_organization_id
258: AND torg.template_id = p_template_id;
259:
260: ln_templ_org_regns_id JAI_RGM_TMPL_ORG_REGNS.TEMPL_ORG_REGNS_ID%TYPE DEFAULT NULL;
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

Line 379: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE

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

Line 391: ltab_attribs jai_inv_items_pkg.GT_ATTRIBUTES%TYPE;

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

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

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

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

429: , fnd_global.login_id
430: ) returning rgm_item_regns_id into ln_rgm_item_regns_id;
431: END IF;
432:
433: jai_inv_items_pkg.jai_create_attribs( p_template_id => ''
434: ,p_rgm_item_regns_id => ln_rgm_item_regns_id
435: ,p_tab_attributes => p_tab_attributes
436: );
437:

Line 447: ,p_tab_attributes jai_inv_items_pkg.GT_ATTRIBUTES%TYPE

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

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

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';
451: BEGIN
452: /*
453: * For each row in pl-sql table create row in jai_item_templ_attribs
454: */

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

491: lv_new_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag%type;
492: lv_new_item_tariff JAI_INV_ITM_SETUPS.item_tariff%type;
493: lv_new_item_folio JAI_INV_ITM_SETUPS.item_folio%type;
494: lv_new_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag%type;
495: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.jai_synchronize_jmsi';
496:
497: cursor cur_get_jmsi_row(cpn_synchronization_number number ) is
498: select
499: jmsi.rowid,

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

618: AND intf.set_process_id = pn_set_process_id
619: AND intf.organization_id = master_org.organization_id
620: AND intf.organization_id <> master_org.master_organization_id ;
621:
622: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_inv_items_pkg.propagate_item_action';
623:
624: BEGIN
625: /*
626: pv_action_type "IMPORT" indicates to import items from interface.

Line 648: jai_inv_items_pkg.copy_items

644: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
645: app_exception.raise_exception;
646: END IF;
647:
648: jai_inv_items_pkg.copy_items
649: ( pn_organization_id => rec_itms.organization_id
650: ,pn_inventory_item_id => rec_itms.inventory_item_id
651: ,pn_source_organization_id => rec_itms.source_organization_id
652: ,pn_source_inventory_item_id => rec_itms.inventory_item_id

Line 667: jai_inv_items_pkg.copy_items

663: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
664: app_exception.raise_exception;
665: END IF;
666:
667: jai_inv_items_pkg.copy_items
668: ( pn_organization_id => pn_organization_id
669: ,pn_inventory_item_id => pn_inventory_item_id
670: ,pn_source_organization_id => pn_source_organization_id
671: ,pn_source_inventory_item_id => pn_source_inventory_item_id

Line 682: jai_inv_items_pkg.delete_items

678: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
679: app_exception.raise_exception;
680: END IF;
681:
682: jai_inv_items_pkg.delete_items
683: (
684: pn_organization_id => pn_organization_id
685: ,pn_inventory_item_id => pn_inventory_item_id
686: );

Line 714: lt_attribs JAI_INV_ITEMS_PKG.GT_ATTRIBUTES%TYPE;

710: ln_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:
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

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

711: ln_source_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE ;
712: ln_source_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE ;
713:
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

Line 809: jai_inv_items_pkg.jai_create_item_regns

805: lt_attribs(lt_attribs.count+1).attribute_code := cur_attribs.attribute_code;
806: lt_attribs(lt_attribs.count).attribute_value := cur_attribs.attribute_value;
807: END LOOP;
808:
809: jai_inv_items_pkg.jai_create_item_regns
810: ( p_regime_code => jai_constants.excise_regime
811: ,p_organization_id => ln_organization_id
812: ,p_inventory_item_id => ln_inventory_item_id
813: ,p_tab_attributes => lt_attribs

Line 845: jai_inv_items_pkg.jai_assign_template (p_template_id => ln_template_id

841: /*
842: Source item is assigned to a template and so new item should also
843: be assigned to the same template
844: */
845: jai_inv_items_pkg.jai_assign_template (p_template_id => ln_template_id
846: ,p_organization_id => ln_organization_id
847: ,p_inventory_item_id => ln_inventory_item_id
848: );
849:

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

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:
910: CURSOR cur_chk_templ_itm_regns (cpn_templ_org_regns_id JAI_RGM_TMPL_ITM_REGNS.TEMPL_ORG_REGNS_ID%TYPE)
911: IS
912: SELECT 1

Line 970: end jai_inv_items_pkg;

966: END delete_items;
967: /* -----------------------END OF PROCEDURE DELETE_ITEMS ----------------------------*/
968: /* End of Bug# 4389149 */
969:
970: end jai_inv_items_pkg;