DBA Data[Home] [Help]

APPS.INV_INVARCPA_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 => ORGANIZATION_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 => ORGANIZATION_ID)) THEN
51: P_WMS_INSTALLED := 'TRUE';
52: END IF;
53: END;
54: RETURN (TRUE);
55: END BEFOREREPORT;

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

95: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
96: --bug14252379,added local variable
97: L_OUTERMOST_LPN_ID NUMBER;
98: BEGIN
99: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
100: ,-99) > 0)) THEN
101: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
102: L_OUTERMOST_LPN_ID := OUTERMOST_LPN_ID;
103: BEGIN

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

121: M_PARENT_LPN VARCHAR2(30) := NULL;
122: --bug14252379,added local variable
123: L_PARENT_LPN_ID NUMBER;
124: BEGIN
125: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
126: ,-99) > 0)) THEN
127: IF (PARENT_LPN_ID IS NOT NULL) THEN
128: L_PARENT_LPN_ID := PARENT_LPN_ID ;
129: BEGIN

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

146: M_COST_GROUP VARCHAR2(10) := NULL;
147: --bug14252379,added local variable
148: L_COST_GROUP_ID NUMBER;
149: BEGIN
150: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
151: L_COST_GROUP_ID := COST_GROUP_ID;
152: BEGIN
153: SELECT
154: COST_GROUP