DBA Data[Home] [Help]

APPS.INV_INVARORE_XMLP_PKG dependencies on WMS_INSTALL

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

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

Line 50: P_WMS_INSTALLED := 'TRUE';

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

Line 94: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG

90: FUNCTION CF_PARENT_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
91: ,PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
92: X_PARENT_LPN VARCHAR2(30) := NULL;
93: BEGIN
94: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
95: ,-99) > 0)) THEN
96: IF (PARENT_LPN_ID IS NOT NULL) THEN
97: BEGIN
98: SELECT

Line 117: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG

113: FUNCTION CF_OUTERMOST_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
114: ,OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
115: X_OUTERMOST_LPN VARCHAR2(30) := NULL;
116: BEGIN
117: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
118: ,-99) > 0)) THEN
119: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
120: BEGIN
121: SELECT

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

135:
136: FUNCTION CF_COST_GROUPFORMULA(COST_GROUP_ID IN NUMBER) RETURN CHAR IS
137: M_COST_GROUP VARCHAR2(10) := NULL;
138: BEGIN
139: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
140: BEGIN
141: SELECT
142: COST_GROUP
143: INTO M_COST_GROUP