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 135: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN

131: --bug#11737196 changing the function argument
132: FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN CHAR IS
133: M_COST_GROUP VARCHAR2(10) := NULL;
134: BEGIN
135: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN
136: BEGIN
137: SELECT
138: COST_GROUP
139: INTO M_COST_GROUP

Line 155: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_OUTERMOST_LPN_ID IS NOT NULL)) THEN

151: --bug#11737196 changing the function argument
152: FUNCTION CF_OUTERMOST_LPNFORMULA(P_OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
153: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
154: BEGIN
155: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_OUTERMOST_LPN_ID IS NOT NULL)) THEN
156: BEGIN
157: SELECT
158: LICENSE_PLATE_NUMBER
159: INTO M_OUTERMOST_LPN

Line 175: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_PARENT_LPN_ID IS NOT NULL)) THEN

171: --bug#11737196 changing the function argument
172: FUNCTION CF_PARENT_LPNFORMULA(P_PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
173: M_PARENT_LPN VARCHAR2(30) := NULL;
174: BEGIN
175: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_PARENT_LPN_ID IS NOT NULL)) THEN
176: BEGIN
177: SELECT
178: LICENSE_PLATE_NUMBER
179: INTO M_PARENT_LPN