DBA Data[Home] [Help]

APPS.INV_INVARPAR_XMLP_PKG dependencies on WMS_INSTALL

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

70: M_RETURN_STATUS VARCHAR2(1);
71: M_MSG_COUNT NUMBER;
72: M_MSG_DATA VARCHAR2(2000);
73: BEGIN
74: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
75: ,X_MSG_COUNT => M_MSG_COUNT
76: ,X_MSG_DATA => M_MSG_DATA
77: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
78: P_WMS_INSTALLED := 'TRUE';

Line 78: P_WMS_INSTALLED := 'TRUE';

74: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
75: ,X_MSG_COUNT => M_MSG_COUNT
76: ,X_MSG_DATA => M_MSG_DATA
77: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
78: P_WMS_INSTALLED := 'TRUE';
79: END IF;
80: END;
81: RETURN (TRUE);
82: END BEFOREREPORT;

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

130:
131: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
132: M_COST_GROUP VARCHAR2(10) := NULL;
133: BEGIN
134: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
135: BEGIN
136: SELECT
137: COST_GROUP
138: INTO M_COST_GROUP

Line 153: IF ((P_WMS_INSTALLED = 'TRUE') AND (OUTERMOST_LPN_ID IS NOT NULL)) THEN

149:
150: FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
151: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
152: BEGIN
153: IF ((P_WMS_INSTALLED = 'TRUE') AND (OUTERMOST_LPN_ID IS NOT NULL)) THEN
154: BEGIN
155: SELECT
156: LICENSE_PLATE_NUMBER
157: INTO M_OUTERMOST_LPN

Line 172: IF ((P_WMS_INSTALLED = 'TRUE') AND (PARENT_LPN_ID IS NOT NULL)) THEN

168:
169: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
170: M_PARENT_LPN VARCHAR2(30) := NULL;
171: BEGIN
172: IF ((P_WMS_INSTALLED = 'TRUE') AND (PARENT_LPN_ID IS NOT NULL)) THEN
173: BEGIN
174: SELECT
175: LICENSE_PLATE_NUMBER
176: INTO M_PARENT_LPN