2: /* $Header: OPIILFKB.pls 120.1 2005/06/08 05:31:38 appldev $ */
3:
4: FUNCTION get_locator_fk (p_inventory_location_id IN NUMBER, p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2) RETURN VARCHAR2 IS
5: v_locator_fk VARCHAR2(240) := 'NA_EDW';
6: v_instance_code edw_local_instance.instance_code%TYPE;
7: v_organization_code mtl_parameters.organization_code%TYPE;
8: BEGIN
9:
10: SELECT instance_code INTO v_instance_code
7: v_organization_code mtl_parameters.organization_code%TYPE;
8: BEGIN
9:
10: SELECT instance_code INTO v_instance_code
11: FROM edw_local_instance;
12:
13: IF p_organization_id IS NULL THEN
14: RETURN 'NA_EDW';
15: ELSE
65: END IF;
66: END get_locator_fk;
67:
68: FUNCTION get_stock_room_fk (p_secondary_inventory_name IN VARCHAR2, p_organization_id IN NUMBER) RETURN VARCHAR2 IS
69: v_instance_code edw_local_instance.instance_code%TYPE;
70: v_organization_code mtl_parameters.organization_code%TYPE;
71: BEGIN
72:
73: SELECT instance_code INTO v_instance_code
70: v_organization_code mtl_parameters.organization_code%TYPE;
71: BEGIN
72:
73: SELECT instance_code INTO v_instance_code
74: FROM edw_local_instance;
75:
76: IF p_organization_id IS NULL THEN
77: RETURN 'NA_EDW';
78: ELSE