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';
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;
92: X_PARENT_LPN VARCHAR2(30) := NULL;
93: --bug14252379,added local variable
94: L_PARENT_LPN_ID NUMBER;
95: BEGIN
96: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
97: ,-99) > 0)) THEN
98: IF (PARENT_LPN_ID IS NOT NULL) THEN
99: L_PARENT_LPN_ID := PARENT_LPN_ID;
100: BEGIN
118: X_OUTERMOST_LPN VARCHAR2(30) := NULL;
119: --bug14252379,added local variable
120: L_OUTERMOST_LPN_ID NUMBER;
121: BEGIN
122: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
123: ,-99) > 0)) THEN
124: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
125: L_OUTERMOST_LPN_ID := OUTERMOST_LPN_ID;
126: BEGIN
143: M_COST_GROUP VARCHAR2(10) := NULL;
144: --bug14252379,added local variable
145: L_COST_GROUP_ID NUMBER;
146: BEGIN
147: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
148: L_COST_GROUP_ID := COST_GROUP_ID;
149: BEGIN
150: SELECT
151: COST_GROUP