eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_INVARPTP_XMLP_PKG dependencies on WMS_INSTALL

Line 216: WMS_INSTALLED;

212: Because original 5 & 11 for item & locator are always null
213: P_ORDER_BY := 'order by 5, 10, 11';*/
214: P_ORDER_BY := 'order by 18, 10, 19';
215: END IF;
216: WMS_INSTALLED;
217: RETURN (TRUE);
218: END BEFOREREPORT;
219: PROCEDURE WMS_INSTALLED IS
220: X_RETURN_STATUS VARCHAR2(240) := NULL;

Line 219: PROCEDURE WMS_INSTALLED IS

215: END IF;
216: WMS_INSTALLED;
217: RETURN (TRUE);
218: END BEFOREREPORT;
219: PROCEDURE WMS_INSTALLED IS
220: X_RETURN_STATUS VARCHAR2(240) := NULL;
221: X_MSG_COUNT NUMBER := NULL;
222: X_MSG_DATA VARCHAR2(240) := NULL;
223: BEGIN

Line 224: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS

220: X_RETURN_STATUS VARCHAR2(240) := NULL;
221: X_MSG_COUNT NUMBER := NULL;
222: X_MSG_DATA VARCHAR2(240) := NULL;
223: BEGIN
224: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS
225: ,X_MSG_COUNT
226: ,X_MSG_DATA
227: ,P_ORG_ID)) THEN
228: P_WMS_INSTALLED := 'TRUE';

Line 228: P_WMS_INSTALLED := 'TRUE';

224: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS
225: ,X_MSG_COUNT
226: ,X_MSG_DATA
227: ,P_ORG_ID)) THEN
228: P_WMS_INSTALLED := 'TRUE';
229: ELSE
230: P_WMS_INSTALLED := 'FALSE';
231: END IF;
232: EXCEPTION

Line 230: P_WMS_INSTALLED := 'FALSE';

226: ,X_MSG_DATA
227: ,P_ORG_ID)) THEN
228: P_WMS_INSTALLED := 'TRUE';
229: ELSE
230: P_WMS_INSTALLED := 'FALSE';
231: END IF;
232: EXCEPTION
233: WHEN OTHERS THEN
234: /*SRW.MESSAGE(12

Line 235: ,'WMS Installed failed before report trigger')*/NULL;

231: END IF;
232: EXCEPTION
233: WHEN OTHERS THEN
234: /*SRW.MESSAGE(12
235: ,'WMS Installed failed before report trigger')*/NULL;
236: END WMS_INSTALLED;
237: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN IN NUMBER) RETURN CHAR IS
238: L_LPN VARCHAR2(30) := NULL;
239: BEGIN

Line 236: END WMS_INSTALLED;

232: EXCEPTION
233: WHEN OTHERS THEN
234: /*SRW.MESSAGE(12
235: ,'WMS Installed failed before report trigger')*/NULL;
236: END WMS_INSTALLED;
237: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN IN NUMBER) RETURN CHAR IS
238: L_LPN VARCHAR2(30) := NULL;
239: BEGIN
240: --commetented as fix

Line 249: --IF (P_WMS_INSTALLED = 'TRUE' AND PARENT_LPN IS NOT NULL) THEN

245: END CF_PARENT_LPNFORMULA;
246: FUNCTION GET_LPN(P_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
247: L_LPN_NAME VARCHAR2(30) := NULL;
248: BEGIN
249: --IF (P_WMS_INSTALLED = 'TRUE' AND PARENT_LPN IS NOT NULL) THEN
250: IF (P_WMS_INSTALLED = 'TRUE' AND P_LPN_ID IS NOT NULL) THEN
251: SELECT
252: LICENSE_PLATE_NUMBER
253: INTO L_LPN_NAME

Line 250: IF (P_WMS_INSTALLED = 'TRUE' AND P_LPN_ID IS NOT NULL) THEN

246: FUNCTION GET_LPN(P_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
247: L_LPN_NAME VARCHAR2(30) := NULL;
248: BEGIN
249: --IF (P_WMS_INSTALLED = 'TRUE' AND PARENT_LPN IS NOT NULL) THEN
250: IF (P_WMS_INSTALLED = 'TRUE' AND P_LPN_ID IS NOT NULL) THEN
251: SELECT
252: LICENSE_PLATE_NUMBER
253: INTO L_LPN_NAME
254: FROM

Line 277: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID_1 IS NOT NULL)) THEN

273: END CF_OUTERMOST_LPNFORMULA;
274: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID_1 IN NUMBER) RETURN CHAR IS
275: M_COST_GROUP VARCHAR2(10) := NULL;
276: BEGIN
277: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID_1 IS NOT NULL)) THEN
278: BEGIN
279: SELECT
280: COST_GROUP
281: INTO M_COST_GROUP