APPS.RCV_AVAILABILITY dependencies on WMS_INSTALL

Line 3: TYPE wms_install_table_type IS TABLE OF BOOLEAN

1: PACKAGE BODY rcv_availability AS
2: /* $Header: RCVAVALB.pls 120.9 2006/10/16 11:47:08 srnatara noship $*/
3: TYPE wms_install_table_type IS TABLE OF BOOLEAN
4: INDEX BY BINARY_INTEGER;
5:
6: g_wms_install_table wms_install_table_type;
7: g_pkg_name CONSTANT VARCHAR2(30) := 'rcv_availability';

Line 6: g_wms_install_table wms_install_table_type;

2: /* $Header: RCVAVALB.pls 120.9 2006/10/16 11:47:08 srnatara noship $*/
3: TYPE wms_install_table_type IS TABLE OF BOOLEAN
4: INDEX BY BINARY_INTEGER;
5:
6: g_wms_install_table wms_install_table_type;
7: g_pkg_name CONSTANT VARCHAR2(30) := 'rcv_availability';
8: g_rti_normalized VARCHAR2(1);
9:
10: /*

Line 594: get_wms_install is a local helper function that takes an org_id

590:
591: x_order_row get_po_order%ROWTYPE;
592:
593: /*
594: get_wms_install is a local helper function that takes an org_id
595: and memoizes it in order to increase performance because we are
596: likely to perform the same check against wms many times.
597: */
598: FUNCTION get_wms_install(

Line 598: FUNCTION get_wms_install(

594: get_wms_install is a local helper function that takes an org_id
595: and memoizes it in order to increase performance because we are
596: likely to perform the same check against wms many times.
597: */
598: FUNCTION get_wms_install(
599: p_organization_id NUMBER
600: )
601: RETURN BOOLEAN IS
602: BEGIN

Line 603: IF g_wms_install_table.EXISTS(p_organization_id) THEN

599: p_organization_id NUMBER
600: )
601: RETURN BOOLEAN IS
602: BEGIN
603: IF g_wms_install_table.EXISTS(p_organization_id) THEN
604: RETURN g_wms_install_table(p_organization_id);
605: END IF;
606:
607: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,

Line 604: RETURN g_wms_install_table(p_organization_id);

600: )
601: RETURN BOOLEAN IS
602: BEGIN
603: IF g_wms_install_table.EXISTS(p_organization_id) THEN
604: RETURN g_wms_install_table(p_organization_id);
605: END IF;
606:
607: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,
608: x_msg_count,

Line 607: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,

603: IF g_wms_install_table.EXISTS(p_organization_id) THEN
604: RETURN g_wms_install_table(p_organization_id);
605: END IF;
606:
607: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,
608: x_msg_count,
609: x_msg_data,
610: p_organization_id
611: );

Line 612: RETURN g_wms_install_table(p_organization_id);

608: x_msg_count,
609: x_msg_data,
610: p_organization_id
611: );
612: RETURN g_wms_install_table(p_organization_id);
613: END get_wms_install;
614:
615: /*
616: update_rcv_quantity is a local helper function that takes care

Line 613: END get_wms_install;

609: x_msg_data,
610: p_organization_id
611: );
612: RETURN g_wms_install_table(p_organization_id);
613: END get_wms_install;
614:
615: /*
616: update_rcv_quantity is a local helper function that takes care
617: of the house keeping to keep the code easy to read. This

Line 629: IF (get_wms_install(p_row.to_organization_id)) THEN

625: x_local_quantity NUMBER;
626: BEGIN
627: x_local_quantity := 0;
628:
629: IF (get_wms_install(p_row.to_organization_id)) THEN
630: po_uom_s.uom_convert(NVL(p_row.quantity_received, 0),
631: p_row.unit_of_measure,
632: p_row.item_id,
633: NVL(p_row.primary_unit_of_measure, p_row.unit_of_measure),

Line 719: quantity 3 then in a WMS installation I want to return an

715: This is to avoid double counting. If I have a PO for quantity
716: 100, and I have already processed an ASN for quantity 50, a
717: processed receipt for quantity 10, a pending delivery for
718: quantity 5 for that receipt, and a new pending receipt for
719: quantity 3 then in a WMS installation I want to return an
720: available quantity of 87 = (100 - 10 - 3) or 50 = (100 - 50) in
721: a non-WMS installation. The deliver has already been accounted
722: for in the 'RECEIVE' so the reason for only looking at these RTI
723: types is to avoid double counting.

Line 721: a non-WMS installation. The deliver has already been accounted

717: processed receipt for quantity 10, a pending delivery for
718: quantity 5 for that receipt, and a new pending receipt for
719: quantity 3 then in a WMS installation I want to return an
720: available quantity of 87 = (100 - 10 - 3) or 50 = (100 - 50) in
721: a non-WMS installation. The deliver has already been accounted
722: for in the 'RECEIVE' so the reason for only looking at these RTI
723: types is to avoid double counting.
724: */
725: IF (p_supply_demand_type_id IN(7, 17)) THEN --internal and external req