DBA Data[Home] [Help]

APPS.POS_ASN dependencies on FND_NUMBER

Line 1438: quantity_shipped = fnd_number.canonical_to_number(nvl(rtrim(ltrim(pos_quantity_shipped(l_counter))), 0)),

1434:
1435: FOR l_counter IN 1..pos_asn_line_id.count LOOP
1436:
1437: update pos_asn_shop_cart_details set
1438: quantity_shipped = fnd_number.canonical_to_number(nvl(rtrim(ltrim(pos_quantity_shipped(l_counter))), 0)),
1439: unit_of_measure = pos_unit_of_measure(l_counter),
1440: comments = pos_comments(l_counter),
1441: wip_job_info = pos_osp_job.get_wip_info(pos_po_distribution_id(l_counter)),
1442: po_distribution_id = pos_po_distribution_id(l_counter),

Line 1616: num_of_containers = fnd_number.canonical_to_number(rtrim(ltrim(pos_num_of_containers))),

1612: bill_of_lading = pos_bill_of_lading,
1613: waybill_airbill_num = pos_waybill_airbill_num,
1614: ship_date = l_ship_date,
1615: expected_receipt_date = l_receipt_date,
1616: num_of_containers = fnd_number.canonical_to_number(rtrim(ltrim(pos_num_of_containers))),
1617: comments = pos_comments,
1618: packing_slip = pos_packing_slip,
1619: freight_carrier_code = pos_freight_carrier_code,
1620: freight_terms = pos_freight_term_code,

Line 1624: gross_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_gross_weight))),

1620: freight_terms = pos_freight_term_code,
1621: freight_bill_number = pos_freight_bill_num,
1622: carrier_method = pos_carrier_method,
1623: carrier_equipment = pos_carrier_equipment,
1624: gross_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_gross_weight))),
1625: gross_weight_uom_code = pos_gross_weight_uom_code,
1626: net_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_net_weight))),
1627: net_weight_uom_code = pos_net_weight_uom_code,
1628: tar_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_tar_weight))),

Line 1626: net_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_net_weight))),

1622: carrier_method = pos_carrier_method,
1623: carrier_equipment = pos_carrier_equipment,
1624: gross_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_gross_weight))),
1625: gross_weight_uom_code = pos_gross_weight_uom_code,
1626: net_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_net_weight))),
1627: net_weight_uom_code = pos_net_weight_uom_code,
1628: tar_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_tar_weight))),
1629: tar_weight_uom_code = pos_tar_weight_uom_code,
1630: packaging_code = pos_packaging_code,

Line 1628: tar_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_tar_weight))),

1624: gross_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_gross_weight))),
1625: gross_weight_uom_code = pos_gross_weight_uom_code,
1626: net_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_net_weight))),
1627: net_weight_uom_code = pos_net_weight_uom_code,
1628: tar_weight = fnd_number.canonical_to_number(rtrim(ltrim(pos_tar_weight))),
1629: tar_weight_uom_code = pos_tar_weight_uom_code,
1630: packaging_code = pos_packaging_code,
1631: special_handling_code = pos_special_handling_code
1632: where session_id = l_session_id;