DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on INV_CONVERT

Line 343: INV_CONVERT.inv_um_conversion(

339: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';
340: BEGIN
341:
342: IF p_transaction_uom_code <> p_primary_uom_code THEN
343: INV_CONVERT.inv_um_conversion(
344: p_transaction_uom_code, p_primary_uom_code,
345: p_inventory_item_id, vTransToPrimaryUOMConv
346: );
347:

Line 349: INV_CONVERT.inv_um_conversion(

345: p_inventory_item_id, vTransToPrimaryUOMConv
346: );
347:
348: IF nvl(vTransToPrimaryUOMConv, 0) <= 0 THEN
349: INV_CONVERT.inv_um_conversion(
350: p_transaction_uom_code, p_primary_uom_code,
351: 0, vTransToPrimaryUOMConv
352: );
353: IF nvl(vTransToPrimaryUOMConv, 0) <= 0 THEN

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

857: --2. Assessable Value is picked up for the Customer Id, Null Site, UOM Code, Assessable value date
858:
859: --3. Assessable Value and Primary UOM is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
860: for the Primary UOM defined in Price List.
861: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
862: as the product of the Assessable value.
863: --4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
864: on a first come first serve basis.
865: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)

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

862: as the product of the Assessable value.
863: --4. Assessable Value is picked up for the Customer Id, Address Id, inventory_item_id, Assessable value date
864: on a first come first serve basis.
865: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
866: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
867: as the product of the Assessable value.
868: */
869: ----------------------------------------------------------------------------------------------------------
870:

Line 930: inv_convert.inv_um_conversion

926: close c_vat_ass_value_pri_uom_cust;
927:
928: IF v_primary_uom_code is not null THEN
929:
930: inv_convert.inv_um_conversion
931: (
932: p_uom_code,
933: v_primary_uom_code,
934: p_inventory_item_id,

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

936: );
937:
938:
939: IF nvl(v_conversion_rate, 0) <= 0 THEN
940: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
941: IF NVL(v_conversion_rate, 0) <= 0 THEN
942: v_conversion_rate := 0;
943: END IF;
944: END IF;

Line 965: inv_convert.inv_um_conversion

961: FETCH c_vat_ass_value_other_uom_cust into v_assessable_value,v_other_uom_code;
962: CLOSE c_vat_ass_value_other_uom_cust;
963:
964: IF v_other_uom_code is not null THEN
965: inv_convert.inv_um_conversion
966: (
967: p_uom_code,
968: v_other_uom_code,
969: p_inventory_item_id,

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

971: );
972:
973: IF nvl(v_conversion_rate, 0) <= 0 THEN
974:
975: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
976:
977: IF NVL(v_conversion_rate, 0) <= 0 THEN
978: v_conversion_rate := 0;
979: END IF;

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

1005: --2. Assessable Value is picked up for the Vendor Id, Null Site, UOM Code, Assessable value date
1006:
1007: --3. Assessable Value and Primary UOM is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1008: for the Primary UOM defined in Price List.
1009: Then Inv_convert.Inv_um_conversion is called and the UOM rate is calculated and is included
1010: as the product of the Assessable value.
1011: --4. Assessable Value is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1012: on a first come first serve basis.
1013: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)

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

1010: as the product of the Assessable value.
1011: --4. Assessable Value is picked up for the Vendor Id, Address Id, inventory_item_id, Assessable value date
1012: on a first come first serve basis.
1013: --5. If all the above are not found then the initial logic of picking up the Assessable value is followed (Unit selling price)
1014: and then inv_convert.inv_um_conversion is called and the UOM rate is calculated and is included
1015: as the product of the Assessable value.
1016: */
1017: ----------------------------------------------------------------------------------------------------------
1018:

Line 1082: inv_convert.inv_um_conversion

1078: close c_vat_ass_value_pri_uom_vend;
1079:
1080: IF v_primary_uom_code is not null THEN
1081:
1082: inv_convert.inv_um_conversion
1083: (
1084: p_uom_code,
1085: v_primary_uom_code,
1086: p_inventory_item_id,

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

1088: );
1089:
1090:
1091: IF nvl(v_conversion_rate, 0) <= 0 THEN
1092: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1093: IF NVL(v_conversion_rate, 0) <= 0 THEN
1094: v_conversion_rate := 0;
1095: END IF;
1096: END IF;

Line 1117: inv_convert.inv_um_conversion

1113: FETCH c_vat_ass_value_other_uom_vend into v_assessable_value,v_other_uom_code;
1114: CLOSE c_vat_ass_value_other_uom_vend;
1115:
1116: IF v_other_uom_code is not null THEN
1117: inv_convert.inv_um_conversion
1118: (
1119: p_uom_code,
1120: v_other_uom_code,
1121: p_inventory_item_id,

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

1123: );
1124:
1125: IF nvl(v_conversion_rate, 0) <= 0 THEN
1126:
1127: Inv_Convert.inv_um_conversion( p_uom_code, v_primary_uom_code, 0, v_conversion_rate );
1128:
1129: IF NVL(v_conversion_rate, 0) <= 0 THEN
1130: v_conversion_rate := 0;
1131: END IF;