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 97: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG

93: FUNCTION CF_OUTERMOST_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
94: ,OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
95: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
96: BEGIN
97: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
98: ,-99) > 0)) THEN
99: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
100: BEGIN
101: SELECT

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

116: FUNCTION CF_PARENT_LPNFORMULA(CONTAINER_ENABLED_FLAG IN NUMBER
117: ,PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
118: M_PARENT_LPN VARCHAR2(30) := NULL;
119: BEGIN
120: IF ((P_WMS_INSTALLED = 'TRUE') AND (NVL(CONTAINER_ENABLED_FLAG
121: ,-99) > 0)) THEN
122: IF (PARENT_LPN_ID IS NOT NULL) THEN
123: BEGIN
124: SELECT

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

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