eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_RLMNETCH_XMLP_PKG dependencies on RLM_CUST_ITEM_CUM_KEYS

Line 633: P_CUM_KEY_ID RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE := NULL;

629: ,BILL_TO_ADDRESS_ID IN NUMBER
630: ,CUST_PO_NUMBER IN VARCHAR2
631: ,CUST_RECORD_YEAR IN VARCHAR2
632: ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER IS
633: P_CUM_KEY_ID RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE := NULL;
634: P_CUM_START_DATE RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE;
635: P_SHIPPED_QUANTITY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE := NULL;
636: P_ACTUAL_SHIPMENT_DATE OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE := NULL;
637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;

Line 634: P_CUM_START_DATE RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE;

630: ,CUST_PO_NUMBER IN VARCHAR2
631: ,CUST_RECORD_YEAR IN VARCHAR2
632: ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER IS
633: P_CUM_KEY_ID RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE := NULL;
634: P_CUM_START_DATE RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE;
635: P_SHIPPED_QUANTITY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE := NULL;
636: P_ACTUAL_SHIPMENT_DATE OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE := NULL;
637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;
638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;

Line 638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;

634: P_CUM_START_DATE RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE;
635: P_SHIPPED_QUANTITY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE := NULL;
636: P_ACTUAL_SHIPMENT_DATE OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE := NULL;
637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;
638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;

Line 639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;

635: P_SHIPPED_QUANTITY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE := NULL;
636: P_ACTUAL_SHIPMENT_DATE OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE := NULL;
637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;
638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;

Line 640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;

636: P_ACTUAL_SHIPMENT_DATE OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE := NULL;
637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;
638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';

Line 641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;

637: P_CUM_KEY_CREATED_FLAG BOOLEAN := FALSE;
638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';
645: P_SHIPMENT_RULE_CODE RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE := NULL;

Line 642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;

638: P_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';
645: P_SHIPMENT_RULE_CODE RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE := NULL;
646: P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

Line 643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;

639: P_AS_OF_DATE_CUM_QTY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE := NULL;
640: P_CUM_QTY_TO_BE_ACCUMULATED RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE := NULL;
641: P_CUM_QTY_AFTER_CUTOFF RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE := NULL;
642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';
645: P_SHIPMENT_RULE_CODE RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE := NULL;
646: P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;
647: P_LAST_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

Line 646: P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

642: P_LAST_CUM_QTY_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE := NULL;
643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';
645: P_SHIPMENT_RULE_CODE RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE := NULL;
646: P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;
647: P_LAST_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;
648: P_AS_OF_DATE_TIME OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE;
649: P_MESG_DATA VARCHAR2(32767) := NULL;
650: P_RECORD_RETURN_STATUS BOOLEAN := FALSE;

Line 647: P_LAST_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;

643: P_CUST_UOM_CODE RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE := NULL;
644: P_USE_SHIP_INCL_RULE_FLAG VARCHAR2(1) := 'N';
645: P_SHIPMENT_RULE_CODE RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE := NULL;
646: P_YESTERDAY_TIME_CUTOFF RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;
647: P_LAST_UPDATE_DATE RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE := NULL;
648: P_AS_OF_DATE_TIME OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE;
649: P_MESG_DATA VARCHAR2(32767) := NULL;
650: P_RECORD_RETURN_STATUS BOOLEAN := FALSE;
651: V_TMP_CUST_RECORD_YEAR VARCHAR2(240);