DBA Data[Home] [Help]

APPS.INV_INVARCTA_XMLP_PKG dependencies on WMS_INSTALL

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

120: M_RETURN_STATUS VARCHAR2(1);
121: M_MSG_COUNT NUMBER;
122: M_MSG_DATA VARCHAR2(2000);
123: BEGIN
124: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
125: ,X_MSG_COUNT => M_MSG_COUNT
126: ,X_MSG_DATA => M_MSG_DATA
127: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
128: P_WMS_INSTALLED := 'TRUE';

Line 128: P_WMS_INSTALLED := 'TRUE';

124: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
125: ,X_MSG_COUNT => M_MSG_COUNT
126: ,X_MSG_DATA => M_MSG_DATA
127: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
128: P_WMS_INSTALLED := 'TRUE';
129: END IF;
130: END;
131: RETURN (TRUE);
132: END BEFOREREPORT;

Line 404: IF (P_WMS_INSTALLED = 'TRUE') THEN

400:
401: FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
402: X_OUTERMOST_LPN VARCHAR2(30) := NULL;
403: BEGIN
404: IF (P_WMS_INSTALLED = 'TRUE') THEN
405: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
406: BEGIN
407: SELECT
408: LICENSE_PLATE_NUMBER

Line 425: IF (P_WMS_INSTALLED = 'TRUE') THEN

421:
422: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
423: X_PARENT_LPN VARCHAR2(30) := NULL;
424: BEGIN
425: IF (P_WMS_INSTALLED = 'TRUE') THEN
426: IF (PARENT_LPN_ID IS NOT NULL) THEN
427: BEGIN
428: SELECT
429: LICENSE_PLATE_NUMBER

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

442:
443: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
444: M_COST_GROUP VARCHAR2(10) := NULL;
445: BEGIN
446: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
447: BEGIN
448: SELECT
449: COST_GROUP
450: INTO M_COST_GROUP