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.15 2011/08/01 09:45:16 yjian ship $*/
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.15 2011/08/01 09:45:16 yjian ship $*/
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 639: get_wms_install is a local helper function that takes an org_id

635:
636: x_order_row get_po_order%ROWTYPE;
637:
638: /*
639: get_wms_install is a local helper function that takes an org_id
640: and memoizes it in order to increase performance because we are
641: likely to perform the same check against wms many times.
642: */
643: FUNCTION get_wms_install(

Line 643: FUNCTION get_wms_install(

639: get_wms_install is a local helper function that takes an org_id
640: and memoizes it in order to increase performance because we are
641: likely to perform the same check against wms many times.
642: */
643: FUNCTION get_wms_install(
644: p_organization_id NUMBER
645: )
646: RETURN BOOLEAN IS
647: BEGIN

Line 648: IF g_wms_install_table.EXISTS(p_organization_id) THEN

644: p_organization_id NUMBER
645: )
646: RETURN BOOLEAN IS
647: BEGIN
648: IF g_wms_install_table.EXISTS(p_organization_id) THEN
649: RETURN g_wms_install_table(p_organization_id);
650: END IF;
651:
652: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,

Line 649: RETURN g_wms_install_table(p_organization_id);

645: )
646: RETURN BOOLEAN IS
647: BEGIN
648: IF g_wms_install_table.EXISTS(p_organization_id) THEN
649: RETURN g_wms_install_table(p_organization_id);
650: END IF;
651:
652: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,
653: x_msg_count,

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

648: IF g_wms_install_table.EXISTS(p_organization_id) THEN
649: RETURN g_wms_install_table(p_organization_id);
650: END IF;
651:
652: g_wms_install_table(p_organization_id) := wms_install.check_install(x_return_status,
653: x_msg_count,
654: x_msg_data,
655: p_organization_id
656: );

Line 657: RETURN g_wms_install_table(p_organization_id);

653: x_msg_count,
654: x_msg_data,
655: p_organization_id
656: );
657: RETURN g_wms_install_table(p_organization_id);
658: END get_wms_install;
659:
660: /*
661: update_rcv_quantity is a local helper function that takes care

Line 658: END get_wms_install;

654: x_msg_data,
655: p_organization_id
656: );
657: RETURN g_wms_install_table(p_organization_id);
658: END get_wms_install;
659:
660: /*
661: update_rcv_quantity is a local helper function that takes care
662: of the house keeping to keep the code easy to read. This

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

670: x_local_quantity NUMBER;
671: BEGIN
672: x_local_quantity := 0;
673:
674: IF (get_wms_install(p_row.to_organization_id)) THEN
675: po_uom_s.uom_convert(NVL(p_row.quantity_received, 0),
676: p_row.unit_of_measure,
677: p_row.item_id,
678: NVL(p_row.primary_unit_of_measure, p_row.unit_of_measure),

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

765: This is to avoid double counting. If I have a PO for quantity
766: 100, and I have already processed an ASN for quantity 50, a
767: processed receipt for quantity 10, a pending delivery for
768: quantity 5 for that receipt, and a new pending receipt for
769: quantity 3 then in a WMS installation I want to return an
770: available quantity of 87 = (100 - 10 - 3) or 50 = (100 - 50) in
771: a non-WMS installation. The deliver has already been accounted
772: for in the 'RECEIVE' so the reason for only looking at these RTI
773: types is to avoid double counting.

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

767: processed receipt for quantity 10, a pending delivery for
768: quantity 5 for that receipt, and a new pending receipt for
769: quantity 3 then in a WMS installation I want to return an
770: available quantity of 87 = (100 - 10 - 3) or 50 = (100 - 50) in
771: a non-WMS installation. The deliver has already been accounted
772: for in the 'RECEIVE' so the reason for only looking at these RTI
773: types is to avoid double counting.
774: */
775: IF (p_supply_demand_type_id IN(7, 17)) THEN --internal and external req