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 254: FROM JAI_INV_ITM_SETUPS

250:
251: CURSOR cur_get_items
252: IS
253: SELECT inventory_item_id
254: FROM JAI_INV_ITM_SETUPS
255: WHERE organization_id = p_organization_id
256: AND inventory_item_id = p_inventory_item_id;
257:
258: CURSOR cur_chk_templ_org

Line 491: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null

487: /* ------------------------------------------- SYNCHRONIZATION ---------------------------------------*/
488:
489: procedure jai_synchronize_jmsi
490: (
491: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
492: )
493: is
494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;

Line 494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;

490: (
491: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
492: )
493: is
494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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;

Line 495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;

491: p_synchronization_number JAI_INV_ITM_SETUPS.synchronization_number%type default null
492: )
493: is
494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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;

Line 496: lv_new_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag%type;

492: )
493: is
494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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';

Line 497: lv_new_item_tariff JAI_INV_ITM_SETUPS.item_tariff%type;

493: is
494: lv_new_excise_flag JAI_INV_ITM_SETUPS.excise_flag%type;
495: lv_new_item_class JAI_INV_ITM_SETUPS.item_class%type;
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:

Line 498: lv_new_item_folio JAI_INV_ITM_SETUPS.item_folio%type;

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

Line 499: lv_new_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag%type;

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

Line 513: from JAI_INV_ITM_SETUPS jmsi

509: jmsi.item_folio ,
510: jmsi.item_trading_flag,
511: jmsi.organization_id,
512: jmsi.inventory_item_id
513: from JAI_INV_ITM_SETUPS jmsi
514: where (
515: (cpn_synchronization_number is null)
516: or
517: ( (cpn_synchronization_number is not null ) and (synchronization_number = cpn_synchronization_number ) )

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

565: end if;
566:
567: end loop; /* Attributes */
568:
569: /* Update JAI_INV_ITM_SETUPS if atleast one attribute is changed */
570:
571: if nvl(lv_new_excise_flag, 'NULL') <> nvl(rec_jmsi.excise_flag, 'NULL') or
572: nvl(lv_new_item_class, 'NULL') <> nvl(rec_jmsi.item_class, 'NULL') or
573: nvl(lv_new_modvat_flag, 'NULL') <> nvl(rec_jmsi.modvat_flag, 'NULL') or

Line 579: update JAI_INV_ITM_SETUPS

575: nvl(lv_new_item_folio, 'NULL') <> nvl(rec_jmsi.item_folio, 'NULL') or
576: nvl(lv_new_item_trading_flag, 'NULL') <> nvl(rec_jmsi.item_trading_flag, 'NULL')
577: then
578:
579: update JAI_INV_ITM_SETUPS
580: set excise_flag = lv_new_excise_flag
581: , item_class = lv_new_item_class
582: , modvat_flag = lv_new_modvat_flag
583: , item_tariff = lv_new_item_tariff

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

856: );
857:
858: END IF; /* End of Template Assignment */
859: /*
860: For Excise regime create a copy record in the JAI_INV_ITM_SETUPS
861: from the source item
862: */
863: --added the IF condition for bug#9191274
864: IF lv_regime_code = jai_constants.excise_regime THEN

Line 865: INSERT INTO JAI_INV_ITM_SETUPS

861: from the source item
862: */
863: --added the IF condition for bug#9191274
864: IF lv_regime_code = jai_constants.excise_regime THEN
865: INSERT INTO JAI_INV_ITM_SETUPS
866: (
867: inventory_item_id
868: , organization_id
869: , item_class

Line 897: FROM JAI_INV_ITM_SETUPS

893: , fnd_global.user_id
894: , fnd_global.login_id
895: , item_trading_flag
896: , NULL
897: FROM JAI_INV_ITM_SETUPS
898: WHERE organization_id = ln_source_organization_id
899: AND inventory_item_id = ln_source_inventory_item_id
900: );
901: END IF;

Line 968: DELETE FROM JAI_INV_ITM_SETUPS

964: DELETE FROM JAI_RGM_TMPL_ORG_REGNS
965: WHERE templ_org_regns_id = ln_templ_org_regns_id;
966: END IF;
967:
968: DELETE FROM JAI_INV_ITM_SETUPS
969: WHERE organization_id = ln_organization_id
970: AND inventory_item_id = ln_inventory_item_id;
971:
972: EXCEPTION