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_CUM_SV dependencies on RLM_CUST_ITEM_CUM_KEYS

Line 36: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;

32: p_ship_to_address_id NUMBER DEFAULT NULL;
33: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
34: p_bill_to_address_id NUMBER DEFAULT NULL;
35: p_customer_item_id NUMBER DEFAULT NULL;
36: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
37: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
38: p_cum_start_date DATE DEFAULT NULL;
39: E_UNEXPECTED EXCEPTION;
40: v_ship_from_org_name VARCHAR2(250) DEFAULT NULL;

Line 37: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;

33: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
34: p_bill_to_address_id NUMBER DEFAULT NULL;
35: p_customer_item_id NUMBER DEFAULT NULL;
36: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
37: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
38: p_cum_start_date DATE DEFAULT NULL;
39: E_UNEXPECTED EXCEPTION;
40: v_ship_from_org_name VARCHAR2(250) DEFAULT NULL;
41: v_customer_name VARCHAR2(360) DEFAULT NULL;

Line 451: FROM RLM_CUST_ITEM_CUM_KEYS

447: x_cum_record.cum_qty_to_be_accumulated,
448: x_cum_record.cum_qty_after_cutoff,
449: x_cum_record.last_cum_qty_update_date,
450: x_cum_record.cust_uom_code
451: FROM RLM_CUST_ITEM_CUM_KEYS
452: WHERE NVL(ship_from_org_id,0) = NVL(p_ship_from_org_id,0)
453: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
454: AND NVL(intrmd_ship_to_id,0) = NVL(p_intrmd_ship_to_address_id,0)
455: AND NVL(bill_to_address_id,0) = NVL(p_bill_to_address_id,0)

Line 478: FROM RLM_CUST_ITEM_CUM_KEYS

474: x_cum_record.cum_qty_to_be_accumulated,
475: x_cum_record.cum_qty_after_cutoff,
476: x_cum_record.last_cum_qty_update_date,
477: x_cum_record.cust_uom_code
478: FROM RLM_CUST_ITEM_CUM_KEYS
479: WHERE ship_from_org_id IS NULL
480: AND NVL(ship_to_address_id, 0) = NVL(p_ship_to_address_id,0)
481: AND NVL(intrmd_ship_to_id, 0) = NVL(p_intrmd_ship_to_address_id,0)
482: AND NVL(bill_to_address_id, 0) = NVL(p_bill_to_address_id,0)

Line 573: INSERT INTO rlm_cust_item_cum_keys_all(

569: x_cum_record.cum_qty := 0;
570: x_cum_record.cum_qty_to_be_accumulated := 0;
571: x_cum_record.cum_qty_after_cutoff := 0;
572: --
573: INSERT INTO rlm_cust_item_cum_keys_all(
574: cum_key_id,
575: cum_qty,
576: cum_qty_to_be_accumulated,
577: cum_qty_after_cutoff,

Line 594: rlm_cust_item_cum_keys_s.nextval,

590: last_update_date,
591: cust_uom_code,
592: org_id)
593: VALUES(
594: rlm_cust_item_cum_keys_s.nextval,
595: x_cum_record.cum_qty,
596: x_cum_record.cum_qty_to_be_accumulated,
597: x_cum_record.cum_qty_after_cutoff,
598: p_customer_item_id,

Line 614: SELECT rlm_cust_item_cum_keys_s.currval

610: sysdate,
611: x_cum_record.cust_uom_code,
612: v_OrgId);
613: --
614: SELECT rlm_cust_item_cum_keys_s.currval
615: INTO x_cum_record.cum_key_id
616: FROM DUAL;
617: --
618: x_cum_record.cum_start_date := p_cum_start_date;

Line 719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,

715:
716: PROCEDURE CalculateCumKeyClient (
717: -- Parameter definition was changed TCA obsolescence project.
718: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

Line 720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,

716: PROCEDURE CalculateCumKeyClient (
717: -- Parameter definition was changed TCA obsolescence project.
718: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

Line 721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

717: -- Parameter definition was changed TCA obsolescence project.
718: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

Line 722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

718: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
726: x_create_cum_key_flag IN VARCHAR2,

Line 723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

719: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
726: x_create_cum_key_flag IN VARCHAR2,
727: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

720: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
726: x_create_cum_key_flag IN VARCHAR2,
727: x_msg_data IN OUT NOCOPY VARCHAR2,
728: x_record_return_status IN OUT NOCOPY BOOLEAN,

Line 725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

721: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
722: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
723: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
724: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
726: x_create_cum_key_flag IN VARCHAR2,
727: x_msg_data IN OUT NOCOPY VARCHAR2,
728: x_record_return_status IN OUT NOCOPY BOOLEAN,
729: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,

Line 729: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,

725: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
726: x_create_cum_key_flag IN VARCHAR2,
727: x_msg_data IN OUT NOCOPY VARCHAR2,
728: x_record_return_status IN OUT NOCOPY BOOLEAN,
729: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
730: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
731: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
732: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,

Line 730: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,

726: x_create_cum_key_flag IN VARCHAR2,
727: x_msg_data IN OUT NOCOPY VARCHAR2,
728: x_record_return_status IN OUT NOCOPY BOOLEAN,
729: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
730: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
731: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
732: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

Line 734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

730: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
731: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
732: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,

Line 735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

731: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
732: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,

Line 736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,

732: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,

Line 737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,

733: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
741: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,

Line 738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,

734: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
741: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
742: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

Line 739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,

735: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
736: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
737: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
741: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
742: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
743: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

Line 742: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

738: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
741: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
742: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
743: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
744: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
745: --
746: IS

Line 743: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

739: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
740: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
741: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
742: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
743: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
744: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
745: --
746: IS
747: --

Line 1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,

1294:
1295: PROCEDURE CalculateSupplierCumClient (
1296: -- Parameter definition was changed TCA obsolescence project.
1297: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

Line 1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,

1296: -- Parameter definition was changed TCA obsolescence project.
1297: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

Line 1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

1297: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

Line 1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

1298: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1306: x_create_cum_key_flag IN VARCHAR2,

Line 1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

1299: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1306: x_create_cum_key_flag IN VARCHAR2,
1307: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

1300: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1306: x_create_cum_key_flag IN VARCHAR2,
1307: x_msg_data IN OUT NOCOPY VARCHAR2,
1308: x_record_return_status IN OUT NOCOPY BOOLEAN,

Line 1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

1301: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1302: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1303: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1304: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1306: x_create_cum_key_flag IN VARCHAR2,
1307: x_msg_data IN OUT NOCOPY VARCHAR2,
1308: x_record_return_status IN OUT NOCOPY BOOLEAN,
1309: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,

Line 1309: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,

1305: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1306: x_create_cum_key_flag IN VARCHAR2,
1307: x_msg_data IN OUT NOCOPY VARCHAR2,
1308: x_record_return_status IN OUT NOCOPY BOOLEAN,
1309: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
1310: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1311: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1312: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,

Line 1310: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,

1306: x_create_cum_key_flag IN VARCHAR2,
1307: x_msg_data IN OUT NOCOPY VARCHAR2,
1308: x_record_return_status IN OUT NOCOPY BOOLEAN,
1309: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
1310: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1311: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1312: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

Line 1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

1310: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1311: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1312: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,

Line 1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

1311: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1312: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,

Line 1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,

1312: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,

Line 1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,

1313: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1321: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,

Line 1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,

1314: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1321: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1322: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

Line 1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,

1315: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1316: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1317: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1321: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1322: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1323: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

Line 1322: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

1318: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1321: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1322: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1323: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1324: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
1325:
1326: IS

Line 1323: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

1319: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1320: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1321: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1322: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1323: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1324: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
1325:
1326: IS
1327: --

Line 2005: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL

2001:
2002: /* Update the CUM related quantity in
2003: RLM_CUS_ITEM_CUM_KEY_ALL table */
2004: --
2005: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL
2006: SET cum_qty = v_cum_record.cum_qty,
2007: cum_qty_to_be_accumulated = v_cum_record.cum_qty_to_be_accumulated,
2008: cum_qty_after_cutoff = v_cum_record.cum_qty_after_cutoff,
2009: last_cum_qty_update_date = sysdate,

Line 3980: UPDATE rlm_cust_item_cum_keys

3976:
3977: v_cum_records(v_index).cum_qty :=
3978: v_cum_records(v_index).cum_qty + adj_qty;
3979: --
3980: UPDATE rlm_cust_item_cum_keys
3981: SET cum_qty = v_cum_records(v_index).cum_qty,
3982: cum_qty_to_be_accumulated =
3983: v_cum_records(v_index).cum_qty_to_be_accumulated,
3984: cum_qty_after_cutoff =

Line 4697: rlm_cust_item_cum_keys. From the records returned, the program filters

4693:
4694:
4695: This procedure is called by reset cum. According to the parameters and
4696: the setup terms for the cum, it gets all the cum records from
4697: rlm_cust_item_cum_keys. From the records returned, the program filters
4698: out those recors which do not have any manual adjustments within the period
4699: nor any shipments(if there is any shipment the field last_cum_qty_update_date
4700: would be within the time frame). These records would be sorted, so that all
4701: corresponding Cums are in sorted together(for example same customer items

Line 4770: v_new_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;

4766: p_bill_to_address_id NUMBER DEFAULT NULL;
4767: p_customer_item_id NUMBER DEFAULT NULL;
4768: msg_data VARCHAR2(2500);
4769: msg_name VARCHAR2(30) DEFAULT NULL;
4770: v_new_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
4771: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE
4772: DEFAULT NULL;
4773: v_ship_from_org_name VARCHAR2(250);
4774: v_customer_name VARCHAR2(360);

Line 4771: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE

4767: p_customer_item_id NUMBER DEFAULT NULL;
4768: msg_data VARCHAR2(2500);
4769: msg_name VARCHAR2(30) DEFAULT NULL;
4770: v_new_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
4771: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE
4772: DEFAULT NULL;
4773: v_ship_from_org_name VARCHAR2(250);
4774: v_customer_name VARCHAR2(360);
4775: v_ship_to_location VARCHAR2(250);

Line 4994: FROM RLM_CUST_ITEM_CUM_KEYS

4990: --
4991: v_select := 'SELECT cum_key_id, cum_qty, cum_qty_to_be_accumulated, cum_qty_after_cutoff,
4992: last_cum_qty_update_date,cust_uom_code,cum_start_date,
4993: cust_record_year,purchase_order_number ,customer_item_id
4994: FROM RLM_CUST_ITEM_CUM_KEYS
4995: ';
4996:
4997: IF x_rlm_setup_terms_record.cum_control_code = 'CUM_BY_DATE_ONLY'
4998: OR x_rlm_setup_terms_record.cum_control_code = 'CUM_UNTIL_MANUAL_RESET'

Line 6041: UPDATE rlm_cust_item_cum_keys

6037: x_old_cum_records(cum_records_counter).cum_qty :=
6038: x_old_cum_records(cum_records_counter).cum_qty +
6039: nvl(adj_qty,0);
6040: --
6041: UPDATE rlm_cust_item_cum_keys
6042: SET cum_qty = x_old_cum_records(cum_records_counter).cum_qty,
6043: cum_qty_to_be_accumulated =
6044: x_old_cum_records(cum_records_counter).cum_qty_to_be_accumulated,
6045: cum_qty_after_cutoff =

Line 6524: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;

6520: p_ship_to_address_id NUMBER DEFAULT NULL;
6521: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
6522: p_bill_to_address_id NUMBER DEFAULT NULL;
6523: p_customer_item_id NUMBER DEFAULT NULL;
6524: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
6525: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
6526: p_cum_start_date DATE DEFAULT NULL;
6527: E_UNEXPECTED EXCEPTION;
6528:

Line 6525: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;

6521: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
6522: p_bill_to_address_id NUMBER DEFAULT NULL;
6523: p_customer_item_id NUMBER DEFAULT NULL;
6524: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
6525: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
6526: p_cum_start_date DATE DEFAULT NULL;
6527: E_UNEXPECTED EXCEPTION;
6528:
6529:

Line 6532: already exist in rlm_cust_item_cum_keys table. The cum record of

6528:
6529:
6530: /* The purpose of the following cursors is to get the cum key id,
6531: cum qty, cum start date, cust record year, po number, etc. that
6532: already exist in rlm_cust_item_cum_keys table. The cum record of
6533: interest is the one that got created last and which cum start date is
6534: no later than sysdate. */
6535:
6536: /* This cursor is used when the proc is called by to get the latest cum

Line 6551: FROM RLM_CUST_ITEM_CUM_KEYS

6547: cust_uom_code,
6548: cum_start_date,
6549: cust_record_year,
6550: purchase_order_number
6551: FROM RLM_CUST_ITEM_CUM_KEYS
6552: WHERE NVL(ship_from_org_id,0) = NVL(p_ship_from_org_id,0)
6553: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6554: AND NVL(intrmd_ship_to_id,0)=
6555: NVL(p_intrmd_ship_to_address_id,0)

Line 6582: FROM RLM_CUST_ITEM_CUM_KEYS

6578: cust_uom_code,
6579: cum_start_date,
6580: cust_record_year,
6581: purchase_order_number
6582: FROM RLM_CUST_ITEM_CUM_KEYS
6583: WHERE ship_from_org_id IS NULL
6584: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6585: AND NVL(intrmd_ship_to_id,0) =
6586: NVL(p_intrmd_ship_to_address_id,0)

Line 6613: FROM RLM_CUST_ITEM_CUM_KEYS

6609: cust_uom_code,
6610: cum_start_date,
6611: cust_record_year,
6612: purchase_order_number
6613: FROM RLM_CUST_ITEM_CUM_KEYS
6614: WHERE NVL(ship_from_org_id,0)= NVL(p_ship_from_org_id,0)
6615: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6616: AND NVL(intrmd_ship_to_id,0)
6617: = NVL(p_intrmd_ship_to_address_id,0)

Line 6647: FROM RLM_CUST_ITEM_CUM_KEYS

6643: cust_uom_code,
6644: cum_start_date,
6645: cust_record_year,
6646: purchase_order_number
6647: FROM RLM_CUST_ITEM_CUM_KEYS
6648: WHERE ship_from_org_id IS NULL
6649: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6650: AND NVL(intrmd_ship_to_id,0)
6651: = NVL(p_intrmd_ship_to_address_id,0)

Line 6681: FROM RLM_CUST_ITEM_CUM_KEYS

6677: cust_uom_code,
6678: cum_start_date,
6679: cust_record_year,
6680: purchase_order_number
6681: FROM RLM_CUST_ITEM_CUM_KEYS
6682: WHERE NVL(ship_from_org_id,0)= NVL(p_ship_from_org_id,0)
6683: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6684: AND NVL(intrmd_ship_to_id,0)
6685: = NVL(p_intrmd_ship_to_address_id,0)

Line 6715: FROM RLM_CUST_ITEM_CUM_KEYS

6711: cust_uom_code,
6712: cum_start_date,
6713: cust_record_year,
6714: purchase_order_number
6715: FROM RLM_CUST_ITEM_CUM_KEYS
6716: WHERE ship_from_org_id IS NULL
6717: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6718: AND NVL(intrmd_ship_to_id,0)
6719: = NVL(p_intrmd_ship_to_address_id,0)

Line 6962: FROM RLM_CUST_ITEM_CUM_KEYS

6958: x_cum_record.cum_qty_to_be_accumulated,
6959: x_cum_record.cum_qty_after_cutoff,
6960: x_cum_record.last_cum_qty_update_date,
6961: x_cum_record.cust_uom_code
6962: FROM RLM_CUST_ITEM_CUM_KEYS
6963: WHERE NVL(ship_from_org_id,0) = NVL(p_ship_from_org_id,0)
6964: AND NVL(ship_to_address_id,0)
6965: = NVL(p_ship_to_address_id,0)
6966: AND NVL(intrmd_ship_to_id,0)

Line 6995: FROM RLM_CUST_ITEM_CUM_KEYS

6991: x_cum_record.cum_qty_to_be_accumulated,
6992: x_cum_record.cum_qty_after_cutoff,
6993: x_cum_record.last_cum_qty_update_date,
6994: x_cum_record.cust_uom_code
6995: FROM RLM_CUST_ITEM_CUM_KEYS
6996: WHERE ship_from_org_id IS NULL
6997: AND NVL(ship_to_address_id, 0)
6998: = NVL(p_ship_to_address_id,0)
6999: AND NVL(intrmd_ship_to_id, 0)

Line 7138: FROM RLM_CUST_ITEM_CUM_KEYS_ALL

7134: IS
7135: --
7136: CURSOR c IS
7137: SELECT *
7138: FROM RLM_CUST_ITEM_CUM_KEYS_ALL
7139: WHERE cum_key_id = x_CumKeyId
7140: FOR UPDATE NOWAIT;
7141: --
7142:

Line 7147: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');

7143: BEGIN
7144: --
7145: IF (l_debug <> -1) THEN
7146: rlm_core_sv.dpush(C_SDEBUG,'LockCumKey');
7147: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');
7148: END IF;
7149: --
7150: OPEN c;
7151: CLOSE c;

Line 7164: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');

7160: --
7161: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
7162: --
7163: IF (l_debug <> -1) THEN
7164: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');
7165: rlm_core_sv.dpop(C_SDEBUG);
7166: END IF;
7167: --
7168: RETURN(FALSE);