DBA Data[Home] [Help]

APPS.INV_INVARCTA_XMLP_PKG dependencies on WMS_INSTALL

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

120: M_RETURN_STATUS VARCHAR2(1);
121: M_MSG_COUNT NUMBER;
122: M_MSG_DATA VARCHAR2(2000);
123: BEGIN
124: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
125: ,X_MSG_COUNT => M_MSG_COUNT
126: ,X_MSG_DATA => M_MSG_DATA
127: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
128: P_WMS_INSTALLED := 'TRUE';

Line 128: P_WMS_INSTALLED := 'TRUE';

124: IF (WMS_INSTALL.CHECK_INSTALL(X_RETURN_STATUS => M_RETURN_STATUS
125: ,X_MSG_COUNT => M_MSG_COUNT
126: ,X_MSG_DATA => M_MSG_DATA
127: ,P_ORGANIZATION_ID => P_ORG_ID)) THEN
128: P_WMS_INSTALLED := 'TRUE';
129: END IF;
130: END;
131: RETURN (TRUE);
132: END BEFOREREPORT;

Line 406: IF (P_WMS_INSTALLED = 'TRUE') THEN

402: X_OUTERMOST_LPN VARCHAR2(30) := NULL;
403: --bug14252379,added local variable
404: L_OUTERMOST_LPN_ID NUMBER;
405: BEGIN
406: IF (P_WMS_INSTALLED = 'TRUE') THEN
407: IF (OUTERMOST_LPN_ID IS NOT NULL) THEN
408: L_OUTERMOST_LPN_ID := OUTERMOST_LPN_ID;
409: BEGIN
410: SELECT

Line 430: IF (P_WMS_INSTALLED = 'TRUE') THEN

426: X_PARENT_LPN VARCHAR2(30) := NULL;
427: --bug14252379,added local variable
428: L_PARENT_LPN_ID NUMBER;
429: BEGIN
430: IF (P_WMS_INSTALLED = 'TRUE') THEN
431: IF (PARENT_LPN_ID IS NOT NULL) THEN
432: L_PARENT_LPN_ID := PARENT_LPN_ID;
433: BEGIN
434: SELECT

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

450: M_COST_GROUP VARCHAR2(10) := NULL;
451: --bug14252379,added local variable
452: L_COST_GROUP_ID NUMBER;
453: BEGIN
454: IF ((P_WMS_INSTALLED = 'TRUE') AND (COST_GROUP_ID IS NOT NULL)) THEN
455: L_COST_GROUP_ID := COST_GROUP_ID;
456: BEGIN
457: SELECT
458: COST_GROUP