DBA Data[Home] [Help]

APPS.INV_INVARPMT_XMLP_PKG dependencies on WMS_INSTALL

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

43: M_RETURN_STATUS VARCHAR2(1);
44: M_MSG_COUNT NUMBER;
45: M_MSG_DATA VARCHAR2(2000);
46: BEGIN
47: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
48: ,X_MSG_COUNT => M_MSG_COUNT
49: ,X_MSG_DATA => M_MSG_DATA
50: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
51: P_WMS_INSTALLED := 'TRUE';

Line 51: P_WMS_INSTALLED := 'TRUE';

47: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
48: ,X_MSG_COUNT => M_MSG_COUNT
49: ,X_MSG_DATA => M_MSG_DATA
50: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
51: P_WMS_INSTALLED := 'TRUE';
52: END IF;
53: END;
54: RETURN (TRUE);
55: END BEFOREREPORT;

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

108:
109: FUNCTION CF_OUTERMOST_LPNFORMULA(OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
110: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
111: BEGIN
112: IF ((P_WMS_INSTALLED = 'TRUE') AND (OUTERMOST_LPN_ID IS NOT NULL)) THEN
113: BEGIN
114: SELECT
115: LICENSE_PLATE_NUMBER
116: INTO M_OUTERMOST_LPN

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

127:
128: FUNCTION CF_PARENT_LPNFORMULA(PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
129: M_PARENT_LPN VARCHAR2(30) := NULL;
130: BEGIN
131: IF ((P_WMS_INSTALLED = 'TRUE') AND (PARENT_LPN_ID IS NOT NULL)) THEN
132: BEGIN
133: SELECT
134: LICENSE_PLATE_NUMBER
135: INTO M_PARENT_LPN

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

146:
147: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
148: M_COST_GROUP VARCHAR2(10) := NULL;
149: BEGIN
150: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
151: BEGIN
152: SELECT
153: COST_GROUP
154: INTO M_COST_GROUP