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.

[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on JAI_INV_ITM_SETUPS

Line 249: FROM JAI_INV_ITM_SETUPS

245:
246: CURSOR cur_get_items
247: IS
248: SELECT inventory_item_id
249: FROM JAI_INV_ITM_SETUPS
250: WHERE organization_id = p_organization_id
251: AND inventory_item_id = p_inventory_item_id;
252:
253: CURSOR cur_chk_templ_org

Line 486: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null

482: /* ------------------------------------------- SYNCHRONIZATION ---------------------------------------*/
483:
484: procedure jai_synchronize_jmsi
485: (
486: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
487: )
488: is
489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;

Line 489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;

485: (
486: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
487: )
488: is
489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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;

Line 490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;

486: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
487: )
488: is
489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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;

Line 491: lv_new_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag%type;

487: )
488: is
489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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';

Line 492: lv_new_item_tariff JAI_INV_ITM_SETUPS.item_tariff%type;

488: is
489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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:

Line 493: lv_new_item_folio JAI_INV_ITM_SETUPS.item_folio%type;

489: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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

Line 494: lv_new_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag%type;

490: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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

Line 508: from JAI_INV_ITM_SETUPS jmsi

504: jmsi.item_folio ,
505: jmsi.item_trading_flag,
506: jmsi.organization_id,
507: jmsi.inventory_item_id
508: from JAI_INV_ITM_SETUPS jmsi
509: where (
510: (cpn_synchronization_number is null)
511: or
512: ( (cpn_synchronization_number is not null ) and (synchronization_number = cpn_synchronization_number ) )

Line 564: /* Update JAI_INV_ITM_SETUPS if atleast one attribute is changed */

560: end if;
561:
562: end loop; /* Attributes */
563:
564: /* Update JAI_INV_ITM_SETUPS if atleast one attribute is changed */
565:
566: if nvl(lv_new_excise_flag, 'NULL') <> nvl(rec_jmsi.excise_flag, 'NULL') or
567: nvl(lv_new_item_class, 'NULL') <> nvl(rec_jmsi.item_class, 'NULL') or
568: nvl(lv_new_modvat_flag, 'NULL') <> nvl(rec_jmsi.modvat_flag, 'NULL') or

Line 574: update JAI_INV_ITM_SETUPS

570: nvl(lv_new_item_folio, 'NULL') <> nvl(rec_jmsi.item_folio, 'NULL') or
571: nvl(lv_new_item_trading_flag, 'NULL') <> nvl(rec_jmsi.item_trading_flag, 'NULL')
572: then
573:
574: update JAI_INV_ITM_SETUPS
575: set excise_flag = lv_new_excise_flag
576: , item_class = lv_new_item_class
577: , modvat_flag = lv_new_modvat_flag
578: , item_tariff = lv_new_item_tariff

Line 852: For Excise regime create a copy record in the JAI_INV_ITM_SETUPS

848: );
849:
850: END IF; /* End of Template Assignment */
851: /*
852: For Excise regime create a copy record in the JAI_INV_ITM_SETUPS
853: from the source item
854: */
855: INSERT INTO JAI_INV_ITM_SETUPS
856: (

Line 855: INSERT INTO JAI_INV_ITM_SETUPS

851: /*
852: For Excise regime create a copy record in the JAI_INV_ITM_SETUPS
853: from the source item
854: */
855: INSERT INTO JAI_INV_ITM_SETUPS
856: (
857: inventory_item_id
858: , organization_id
859: , item_class

Line 887: FROM JAI_INV_ITM_SETUPS

883: , fnd_global.user_id
884: , fnd_global.login_id
885: , item_trading_flag
886: , NULL
887: FROM JAI_INV_ITM_SETUPS
888: WHERE organization_id = ln_source_organization_id
889: AND inventory_item_id = ln_source_inventory_item_id
890: );
891: EXCEPTION

Line 957: DELETE FROM JAI_INV_ITM_SETUPS

953: DELETE FROM JAI_RGM_TMPL_ORG_REGNS
954: WHERE templ_org_regns_id = ln_templ_org_regns_id;
955: END IF;
956:
957: DELETE FROM JAI_INV_ITM_SETUPS
958: WHERE organization_id = ln_organization_id
959: AND inventory_item_id = ln_inventory_item_id;
960:
961: EXCEPTION