APPS.EDW_MTL_INVENTORY_LOC_PKG dependencies on MTL_PARAMETERS

Line 7: v_organization_code mtl_parameters.organization_code%TYPE;

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
11: FROM edw_local_instance;

Line 17: FROM mtl_parameters mp

13: IF p_organization_id IS NULL THEN
14: RETURN 'NA_EDW';
15: ELSE
16: SELECT mp.organization_code INTO v_organization_code
17: FROM mtl_parameters mp
18: WHERE mp.organization_id = p_organization_id;
19: IF (p_inventory_location_id IS NOT null and p_inventory_location_id<>0) THEN
20: RETURN(p_inventory_location_id ||'-'||v_organization_code||'-'||v_instance_code);
21: ELSIF (p_subinventory_code IS NOT NULL) THEN

Line 70: v_organization_code mtl_parameters.organization_code%TYPE;

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
74: FROM edw_local_instance;

Line 80: FROM mtl_parameters mp

76: IF p_organization_id IS NULL THEN
77: RETURN 'NA_EDW';
78: ELSE
79: SELECT mp.organization_code INTO v_organization_code
80: FROM mtl_parameters mp
81: WHERE mp.organization_id = p_organization_id;
82:
83: IF (p_secondary_inventory_name IS NOT NULL) THEN
84: RETURN(p_secondary_inventory_name ||'-'||v_organization_code||'-'||v_instance_code||'-SUBI');