DBA Data[Home] [Help]

APPS.INV_INVARPSL_XMLP_PKG dependencies on WMS_INSTALL

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

77: M_RETURN_STATUS VARCHAR2(1);
78: M_MSG_COUNT NUMBER;
79: M_MSG_DATA VARCHAR2(2000);
80: BEGIN
81: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
82: ,X_MSG_COUNT => M_MSG_COUNT
83: ,X_MSG_DATA => M_MSG_DATA
84: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
85: P_WMS_INSTALLED := 'TRUE';

Line 85: P_WMS_INSTALLED := 'TRUE';

81: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
82: ,X_MSG_COUNT => M_MSG_COUNT
83: ,X_MSG_DATA => M_MSG_DATA
84: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
85: P_WMS_INSTALLED := 'TRUE';
86: END IF;
87: END;
88: RETURN (TRUE);
89: END BEFOREREPORT;

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

193:
194: FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
195: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
196: BEGIN
197: IF ((P_WMS_INSTALLED = 'TRUE') AND (OUTERMOST_LPN_ID IS NOT NULL)) THEN
198: BEGIN
199: SELECT
200: LICENSE_PLATE_NUMBER
201: INTO M_OUTERMOST_LPN

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

212:
213: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
214: M_PARENT_LPN VARCHAR2(30) := NULL;
215: BEGIN
216: IF ((P_WMS_INSTALLED = 'TRUE') AND (PARENT_LPN_ID IS NOT NULL)) THEN
217: BEGIN
218: SELECT
219: LICENSE_PLATE_NUMBER
220: INTO M_PARENT_LPN

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

231:
232: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
233: M_COST_GROUP VARCHAR2(10) := NULL;
234: BEGIN
235: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
236: BEGIN
237: SELECT
238: COST_GROUP
239: INTO M_COST_GROUP