APPS.INV_INVARCLI_XMLP_PKG dependencies on WMS_INSTALL

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

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

Line 59: P_WMS_INSTALLED := 'TRUE';

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

Line 193: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN

189:
190: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
191: M_COST_GROUP VARCHAR2(10) := NULL;
192: BEGIN
193: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
194: BEGIN
195: SELECT
196: COST_GROUP
197: INTO M_COST_GROUP

Line 213: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG

209: FUNCTION CF_OUTERMOST_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
210: ,OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
211: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
212: BEGIN
213: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
214: ,-99) > 0)) THEN
215: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
216: SELECT
217: LICENSE_PLATE_NUMBER

Line 234: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG

230: FUNCTION CF_PARENT_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
231: ,PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
232: M_PARENT_LPN VARCHAR2(30) := NULL;
233: BEGIN
234: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
235: ,-99) > 0)) THEN
236: IF (PARENT_LPN_ID IS NOT NULL) THEN
237: SELECT
238: LICENSE_PLATE_NUMBER