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

109: --bug#11709065 changing the function argument
110: FUNCTION CF_OUTERMOST_LPNFORMULA(P_OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
111: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
112: BEGIN
113: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_OUTERMOST_LPN_ID IS NOT NULL)) THEN
114: BEGIN
115: SELECT
116: LICENSE_PLATE_NUMBER
117: INTO M_OUTERMOST_LPN

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

129: --bug#11709065 changing the function argument
130: FUNCTION CF_PARENT_LPNFORMULA(P_PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
131: M_PARENT_LPN VARCHAR2(30) := NULL;
132: BEGIN
133: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_PARENT_LPN_ID IS NOT NULL)) THEN
134: BEGIN
135: SELECT
136: LICENSE_PLATE_NUMBER
137: INTO M_PARENT_LPN

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

149: --bug#11709065 changing the function argument
150: FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN CHAR IS
151: M_COST_GROUP VARCHAR2(10) := NULL;
152: BEGIN
153: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN
154: BEGIN
155: SELECT
156: COST_GROUP
157: INTO M_COST_GROUP