DBA Data[Home] [Help]

APPS.INV_INVARPSL_XMLP_PKG dependencies on WMS_INSTALL

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

77: M_RETURN_STATUS VARCHAR2(1);
78: M_MSG_COUNT NUMBER;
79: M_MSG_DATA VARCHAR2(2000);
80: BEGIN
81: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
82: ,X_MSG_COUNT => M_MSG_COUNT
83: ,X_MSG_DATA => M_MSG_DATA
84: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
85: P_WMS_INSTALLED := 'TRUE';

Line 85: P_WMS_INSTALLED := 'TRUE';

81: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
82: ,X_MSG_COUNT => M_MSG_COUNT
83: ,X_MSG_DATA => M_MSG_DATA
84: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
85: P_WMS_INSTALLED := 'TRUE';
86: END IF;
87: END;
88: RETURN (TRUE);
89: END BEFOREREPORT;

Line 198: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_OUTERMOST_LPN_ID IS NOT NULL)) THEN

194: -- bug13722951 changing the function argument from OUTERMOST_LPN_ID to P_OUTERMOST_LPN_ID
195: FUNCTION CF_OUTERMOST_LPNFORMULA(P_OUTERMOST_LPN_ID IN NUMBER) RETURN CHAR IS
196: M_OUTERMOST_LPN VARCHAR2(30) := NULL;
197: BEGIN
198: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_OUTERMOST_LPN_ID IS NOT NULL)) THEN
199: BEGIN
200: SELECT
201: LICENSE_PLATE_NUMBER
202: INTO M_OUTERMOST_LPN

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

214: -- bug13722951 changing the function argument from PARENT_LPN_ID to P_PARENT_LPN_ID
215: FUNCTION CF_PARENT_LPNFORMULA(P_PARENT_LPN_ID IN NUMBER) RETURN CHAR IS
216: M_PARENT_LPN VARCHAR2(30) := NULL;
217: BEGIN
218: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_PARENT_LPN_ID IS NOT NULL)) THEN
219: BEGIN
220: SELECT
221: LICENSE_PLATE_NUMBER
222: INTO M_PARENT_LPN

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

234: -- bug13722951 changing the function argument from COST_GROUP_ID to P_COST_GROUP_ID
235: FUNCTION CF_COST_GROUPFORMULA(P_COST_GROUP_ID IN NUMBER) RETURN CHAR IS
236: M_COST_GROUP VARCHAR2(10) := NULL;
237: BEGIN
238: IF ((P_WMS_INSTALLED = 'TRUE') AND (P_COST_GROUP_ID IS NOT NULL)) THEN
239: BEGIN
240: SELECT
241: COST_GROUP
242: INTO M_COST_GROUP