DBA Data[Home] [Help]

APPS.JAI_OM_UTILS_PKG dependencies on INV_CONVERT

Line 405: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

401: 2. Assessable Value is picked up for the Customer Id, Null Site, UOM Code, Assessable value date
402:
403: 3. Assessable Value and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
404: for the Primary UOM defined in Price List.
405: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
406: as the product of the Assessable value.
407: 4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
408: on a first come first serve basis.
409: 5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)

Line 410: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included

406: as the product of the Assessable value.
407: 4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
408: on a first come first serve basis.
409: 5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
410: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
411: as the product of the Assessable value.
412:
413: 6. 08-Jun-2009 Jia Li for IL Advanced Pricing.
414: There were enhancement requests from customers to enhance the current India Localization functionality

Line 458: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

454: --2.1. Assessable Value of item cetegory is picked up for the Customer Id, Null Site, UOM Code, Assessable value date
455:
456: --3. Assessable Value and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
457: for the Primary UOM defined in Price List.
458: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
459: as the product of the Assessable value.
460: --3.1. Assessable Value of item cetegory and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
461: for the Primary UOM defined in Price List.
462: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

Line 462: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included

458: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
459: as the product of the Assessable value.
460: --3.1. Assessable Value of item cetegory and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
461: for the Primary UOM defined in Price List.
462: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
463: as the product of the Assessable value.
464:
465: --4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
466: on a first come first serve basis.

Line 471: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included

467: --4.1. Assessable Value of item cetegory is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
468: on a first come first serve basis.
469:
470: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
471: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
472: as the product of the Assessable value.
473: */
474: ----------------------------------------------------------------------------------------------------------
475:

Line 633: inv_convert.inv_um_conversion

629: close c_assessable_value_pri_uom;
630:
631: IF v_primary_uom_code is not null THEN
632:
633: inv_convert.inv_um_conversion
634: (
635: p_uom_code,
636: v_primary_uom_code,
637: p_inventory_item_id,

Line 643: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

639: );
640:
641:
642: IF nvl(v_conversion_rate, 0) <= 0 THEN
643: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
644: IF NVL(v_conversion_rate, 0) <= 0 THEN
645: v_conversion_rate := 0;
646: END IF;
647: END IF;

Line 674: inv_convert.inv_um_conversion( p_uom_code

670: CLOSE cust_ass_value_pri_uom_cur;
671:
672: IF v_primary_uom_code IS NOT NULL
673: THEN
674: inv_convert.inv_um_conversion( p_uom_code
675: , v_primary_uom_code
676: , p_inventory_item_id
677: , v_conversion_rate
678: );

Line 682: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

678: );
679:
680: IF NVL(v_conversion_rate, 0) <= 0
681: THEN
682: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
683: IF NVL(v_conversion_rate, 0) <= 0
684: THEN
685: v_conversion_rate := 0;
686: END IF;

Line 715: inv_convert.inv_um_conversion

711: FETCH c_assessable_value_other_uom into v_assessable_value,v_other_uom_code,lv_assess_val_curr_code; /* Added for bug#8844209 */
712: CLOSE c_assessable_value_other_uom;
713:
714: IF v_other_uom_code is not null THEN
715: inv_convert.inv_um_conversion
716: (
717: p_uom_code,
718: v_other_uom_code,
719: p_inventory_item_id,

Line 725: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

721: );
722:
723: IF nvl(v_conversion_rate, 0) <= 0 THEN
724:
725: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
726:
727: IF NVL(v_conversion_rate, 0) <= 0 THEN
728: v_conversion_rate := 0;
729: END IF;

Line 758: inv_convert.inv_um_conversion( p_uom_code

754: CLOSE cust_ass_value_other_uom_cur;
755:
756: IF v_other_uom_code IS NOT NULL
757: THEN
758: inv_convert.inv_um_conversion( p_uom_code
759: , v_other_uom_code
760: , p_inventory_item_id
761: , v_conversion_rate
762: );

Line 766: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );

762: );
763:
764: IF NVL(v_conversion_rate, 0) <= 0
765: THEN
766: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
767: IF NVL(v_conversion_rate, 0) <= 0
768: THEN
769: v_conversion_rate := 0;
770: END IF;

Line 795: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 1');

791: -- If still the Assessable Value is available
792: IF v_price_list_uom_code IS NOT NULL THEN
793:
794: IF v_debug = 'Y' THEN
795: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 1');
796: END IF;
797:
798: Inv_Convert.inv_um_conversion ( v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate );
799: IF NVL(v_conversion_rate, 0) <= 0 THEN

Line 798: Inv_Convert.inv_um_conversion ( v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate );

794: IF v_debug = 'Y' THEN
795: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 1');
796: END IF;
797:
798: Inv_Convert.inv_um_conversion ( v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate );
799: IF NVL(v_conversion_rate, 0) <= 0 THEN
800:
801: IF v_debug = 'Y' THEN
802: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 2');

Line 802: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 2');

798: Inv_Convert.inv_um_conversion ( v_uom_code, v_price_list_uom_code, v_inventory_item_id, v_conversion_rate );
799: IF NVL(v_conversion_rate, 0) <= 0 THEN
800:
801: IF v_debug = 'Y' THEN
802: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 2');
803: END IF;
804:
805: Inv_Convert.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
806: IF NVL(v_conversion_rate, 0) <= 0 THEN

Line 805: Inv_Convert.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);

801: IF v_debug = 'Y' THEN
802: fnd_file.put_line(fnd_file.log,' BEFORE Calling Inv_Convert.inv_um_conversion 2');
803: END IF;
804:
805: Inv_Convert.inv_um_conversion(v_uom_code, v_price_list_uom_code, 0, v_conversion_rate);
806: IF NVL(v_conversion_rate, 0) <= 0 THEN
807: v_conversion_rate := 0;
808: END IF;
809: