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 207: WMS_INSTALLED;

203: P_ORDER_BY := 'order by 10, 5, 8, 13, 14, 11, 4';
204: ELSIF P_SORT_ID = 4 THEN
205: P_ORDER_BY := 'order by 5, 10, 11';
206: END IF;
207: WMS_INSTALLED;
208: RETURN (TRUE);
209: END BEFOREREPORT;
210: PROCEDURE WMS_INSTALLED IS
211: X_RETURN_STATUS VARCHAR2(240) := NULL;

Line 210: PROCEDURE WMS_INSTALLED IS

206: END IF;
207: WMS_INSTALLED;
208: RETURN (TRUE);
209: END BEFOREREPORT;
210: PROCEDURE WMS_INSTALLED IS
211: X_RETURN_STATUS VARCHAR2(240) := NULL;
212: X_MSG_COUNT NUMBER := NULL;
213: X_MSG_DATA VARCHAR2(240) := NULL;
214: BEGIN

Line 215: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS

211: X_RETURN_STATUS VARCHAR2(240) := NULL;
212: X_MSG_COUNT NUMBER := NULL;
213: X_MSG_DATA VARCHAR2(240) := NULL;
214: BEGIN
215: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS
216: ,X_MSG_COUNT
217: ,X_MSG_DATA
218: ,P_ORG_ID)) THEN
219: P_WMS_INSTALLED := 'TRUE';

Line 219: P_WMS_INSTALLED := 'TRUE';

215: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS
216: ,X_MSG_COUNT
217: ,X_MSG_DATA
218: ,P_ORG_ID)) THEN
219: P_WMS_INSTALLED := 'TRUE';
220: ELSE
221: P_WMS_INSTALLED := 'FALSE';
222: END IF;
223: EXCEPTION

Line 221: P_WMS_INSTALLED := 'FALSE';

217: ,X_MSG_DATA
218: ,P_ORG_ID)) THEN
219: P_WMS_INSTALLED := 'TRUE';
220: ELSE
221: P_WMS_INSTALLED := 'FALSE';
222: END IF;
223: EXCEPTION
224: WHEN OTHERS THEN
225: /*SRW.MESSAGE(12

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

222: END IF;
223: EXCEPTION
224: WHEN OTHERS THEN
225: /*SRW.MESSAGE(12
226: ,'WMS Installed failed before report trigger')*/NULL;
227: END WMS_INSTALLED;
228: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN IN NUMBER) RETURN CHAR IS
229: L_LPN VARCHAR2(30) := NULL;
230: BEGIN

Line 227: END WMS_INSTALLED;

223: EXCEPTION
224: WHEN OTHERS THEN
225: /*SRW.MESSAGE(12
226: ,'WMS Installed failed before report trigger')*/NULL;
227: END WMS_INSTALLED;
228: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN IN NUMBER) RETURN CHAR IS
229: L_LPN VARCHAR2(30) := NULL;
230: BEGIN
231: --commetented as fix

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

236: END CF_PARENT_LPNFORMULA;
237: FUNCTION GET_LPN(P_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
238: L_LPN_NAME VARCHAR2(30) := NULL;
239: BEGIN
240: --IF (P_WMS_INSTALLED = 'TRUE' AND PARENT_LPN IS NOT NULL) THEN
241: IF (P_WMS_INSTALLED = 'TRUE' AND P_LPN_ID IS NOT NULL) THEN
242: SELECT
243: LICENSE_PLATE_NUMBER
244: INTO L_LPN_NAME

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

237: FUNCTION GET_LPN(P_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
238: L_LPN_NAME VARCHAR2(30) := NULL;
239: BEGIN
240: --IF (P_WMS_INSTALLED = 'TRUE' AND PARENT_LPN IS NOT NULL) THEN
241: IF (P_WMS_INSTALLED = 'TRUE' AND P_LPN_ID IS NOT NULL) THEN
242: SELECT
243: LICENSE_PLATE_NUMBER
244: INTO L_LPN_NAME
245: FROM

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

264: END CF_OUTERMOST_LPNFORMULA;
265: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID_1 IN NUMBER) RETURN CHAR IS
266: M_COST_GROUP VARCHAR2(10) := NULL;
267: BEGIN
268: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID_1 IS NOT NULL)) THEN
269: BEGIN
270: SELECT
271: COST_GROUP
272: INTO M_COST_GROUP