DBA Data[Home] [Help]

APPS.WSH_WSHRDBSR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 171: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

167: RP_FLEX_OR_DESC := NULL;
168: END;
169: IF P_ORGANIZATION_ID IS NOT NULL THEN
170: DECLARE
171: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
172: BEGIN
173: SELECT
174: NAME
175: INTO WAREHOUSE_NAME

Line 177: HR_ORGANIZATION_UNITS

173: SELECT
174: NAME
175: INTO WAREHOUSE_NAME
176: FROM
177: HR_ORGANIZATION_UNITS
178: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
179: RP_WAREHOUSE := WAREHOUSE_NAME;
180: EXCEPTION
181: WHEN NO_DATA_FOUND THEN

Line 261: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

257: END CF_SHIPPED_AMTFORMULA;
258:
259: --FUNCTION CF_WAREHOUSEFORMULA(ORGANIZATION_ID IN NUMBER) RETURN CHAR IS
260: FUNCTION CF_WAREHOUSEFORMULA(ORGANIZATION_ID_V IN NUMBER) RETURN CHAR IS
261: WAREHOUSE_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;
262: BEGIN
263: SELECT
264: NAME
265: INTO WAREHOUSE_NAME

Line 267: HR_ORGANIZATION_UNITS

263: SELECT
264: NAME
265: INTO WAREHOUSE_NAME
266: FROM
267: HR_ORGANIZATION_UNITS
268: WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;
269: RETURN (WAREHOUSE_NAME);
270: EXCEPTION
271: WHEN NO_DATA_FOUND THEN