APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on WIP_PARAMETERS

Line 1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;

1612:
1613: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;

Line 1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;

1613: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1621:

Line 1935: Default Supply Subinventory from WIP Parameters.

1931: END IF ; /*end if p_receive_quantity > l_quantity_ordered - l_quantity_delivered*/
1932:
1933: /*
1934: If there is no subinventory associated with PO Distributions then get
1935: Default Supply Subinventory from WIP Parameters.
1936: */
1937: IF l_dest_subinventory IS NULL
1938: THEN
1939: -- find the default subinventory

Line 1953: FROM wip_parameters wip_para

1949:
1950: BEGIN
1951: SELECT wip_para.default_pull_supply_subinv
1952: INTO l_dest_subinventory
1953: FROM wip_parameters wip_para
1954: WHERE wip_para.Organization_Id = p_inventory_org_id;
1955: EXCEPTION
1956: WHEN no_data_found THEN
1957: JMF_SHIKYU_UTIL.debug_output

Line 2004: FROM wip_parameters wip_para

2000: --get the DEFAULT_PULL_SUPPLY_LOCATOR_ID
2001: BEGIN
2002: SELECT wip_para.default_pull_supply_locator_id
2003: INTO l_default_locator_id
2004: FROM wip_parameters wip_para
2005: WHERE wip_para.Organization_Id = p_inventory_org_id;
2006: EXCEPTION
2007: WHEN no_data_found THEN
2008: JMF_SHIKYU_UTIL.debug_output