APPS.INV_INVARCLI_XMLP_PKG dependencies on WMS_INSTALL

Line 57: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS

53: M_RETURN_STATUS VARCHAR2(1);
54: M_MSG_COUNT NUMBER;
55: M_MSG_DATA VARCHAR2(2000);
56: BEGIN
57: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
58: ,X_MSG_COUNT => M_MSG_COUNT
59: ,X_MSG_DATA => M_MSG_DATA
60: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
61: P_WMS_INSTALLED := 'TRUE';

Line 61: P_WMS_INSTALLED := 'TRUE';

57: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
58: ,X_MSG_COUNT => M_MSG_COUNT
59: ,X_MSG_DATA => M_MSG_DATA
60: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
61: P_WMS_INSTALLED := 'TRUE';
62: END IF;
63: END;
64: RETURN (TRUE);
65: END BEFOREREPORT;

Line 200: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN

196: FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
197: --M_COST_GROUP VARCHAR2(10) := NULL;
198: M_COST_GROUP CST_COST_GROUPS.COST_GROUP%TYPE := NULL;
199: BEGIN
200: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN
201: BEGIN
202: SELECT
203: COST_GROUP
204: INTO M_COST_GROUP

Line 222: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(P_CONTAINER_ENABLED_FLAG,-99) > 0)) THEN

218: FUNCTION CF_OUTERMOST_LPNFORMULA(P_CONTAINER_ENABLED_FLAG IN NUMBER
219: ,P_OUTERMOST_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
220: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
221: BEGIN
222: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(P_CONTAINER_ENABLED_FLAG,-99) > 0)) THEN
223: IF (P_OUTERMOST_LPN_ID IS NOT NULL) THEN
224: SELECT
225: LICENSE_PLATE_NUMBER
226: INTO M_OUTERMOST_LPN

Line 249: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(P_CONTAINER_ENABLED_FLAG

245: FUNCTION CF_PARENT_LPNFORMULA(P_CONTAINER_ENABLED_FLAG IN NUMBER
246: ,P_PARENT_LPN_ID IN NUMBER) RETURN VARCHAR2 IS
247: M_PARENT_LPN VARCHAR2(30) := NULL;
248: BEGIN
249: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(P_CONTAINER_ENABLED_FLAG
250: ,-99) > 0)) THEN
251: IF (P_PARENT_LPN_ID IS NOT NULL) THEN
252: SELECT
253: LICENSE_PLATE_NUMBER