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 720: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,

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

Line 721: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,

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

Line 722: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

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

Line 723: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

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

Line 724: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

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

Line 725: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

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

Line 726: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,

1303:
1304: PROCEDURE CalculateSupplierCumClient (
1305: -- Parameter definition was changed TCA obsolescence project.
1306: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

Line 1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,

1305: -- Parameter definition was changed TCA obsolescence project.
1306: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

Line 1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,

1306: x_customer_id IN HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE,
1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

Line 1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,

1307: x_customer_item_id IN RLM_CUST_ITEM_CUM_KEYS.CUSTOMER_ITEM_ID%TYPE,
1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1315: x_create_cum_key_flag IN VARCHAR2,

Line 1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,

1308: x_inventory_item_id IN OE_ORDER_LINES.INVENTORY_ITEM_ID%TYPE,
1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1315: x_create_cum_key_flag IN VARCHAR2,
1316: x_msg_data IN OUT NOCOPY VARCHAR2,

Line 1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,

1309: x_ship_from_org_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_FROM_ORG_ID%TYPE,
1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1315: x_create_cum_key_flag IN VARCHAR2,
1316: x_msg_data IN OUT NOCOPY VARCHAR2,
1317: x_record_return_status IN OUT NOCOPY BOOLEAN,

Line 1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,

1310: x_intrmd_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.INTRMD_SHIP_TO_ID%TYPE,
1311: x_ship_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.SHIP_TO_ADDRESS_ID%TYPE,
1312: x_bill_to_address_id IN RLM_CUST_ITEM_CUM_KEYS.BILL_TO_ADDRESS_ID%TYPE,
1313: x_purchase_order_number IN RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE,
1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1315: x_create_cum_key_flag IN VARCHAR2,
1316: x_msg_data IN OUT NOCOPY VARCHAR2,
1317: x_record_return_status IN OUT NOCOPY BOOLEAN,
1318: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,

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

1314: x_cust_record_year IN RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE,
1315: x_create_cum_key_flag IN VARCHAR2,
1316: x_msg_data IN OUT NOCOPY VARCHAR2,
1317: x_record_return_status IN OUT NOCOPY BOOLEAN,
1318: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
1319: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1320: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1321: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,

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

1315: x_create_cum_key_flag IN VARCHAR2,
1316: x_msg_data IN OUT NOCOPY VARCHAR2,
1317: x_record_return_status IN OUT NOCOPY BOOLEAN,
1318: x_cum_key_id IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_KEY_ID%TYPE,
1319: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1320: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1321: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,

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

1319: x_cum_start_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_START_DATE%TYPE,
1320: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1321: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,

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

1320: x_shipped_quantity IN OUT NOCOPY OE_ORDER_LINES.SHIPPED_QUANTITY%TYPE,
1321: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,

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

1321: x_actual_shipment_date IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE,
1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,

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

1322: x_cum_key_created_flag IN OUT NOCOPY BOOLEAN,
1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1330: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,

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

1323: x_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1330: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1331: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

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

1324: x_as_of_date_cum_qty IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY%TYPE,
1325: x_cum_qty_to_be_accumulated IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_TO_BE_ACCUMULATED%TYPE,
1326: x_cum_qty_after_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUM_QTY_AFTER_CUTOFF%TYPE,
1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1330: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1331: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1332: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,

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

1327: x_last_cum_qty_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_CUM_QTY_UPDATE_DATE%TYPE,
1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1330: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1331: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1332: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1333: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
1334:
1335: IS

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

1328: x_cust_uom_code IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.CUST_UOM_CODE%TYPE,
1329: x_use_ship_incl_rule_flag IN OUT NOCOPY VARCHAR2,
1330: x_shipment_rule_code IN OUT NOCOPY RLM_CUST_SHIPTO_TERMS.CUM_SHIPMENT_RULE_CODE%TYPE,
1331: x_yesterday_time_cutoff IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1332: x_last_update_date IN OUT NOCOPY RLM_CUST_ITEM_CUM_KEYS.LAST_UPDATE_DATE%TYPE,
1333: x_as_of_date_time IN OUT NOCOPY OE_ORDER_LINES.ACTUAL_SHIPMENT_DATE%TYPE)
1334:
1335: IS
1336: --

Line 2014: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL

2010:
2011: /* Update the CUM related quantity in
2012: RLM_CUS_ITEM_CUM_KEY_ALL table */
2013: --
2014: UPDATE RLM_CUST_ITEM_CUM_KEYS_ALL
2015: SET cum_qty = v_cum_record.cum_qty,
2016: cum_qty_to_be_accumulated = v_cum_record.cum_qty_to_be_accumulated,
2017: cum_qty_after_cutoff = v_cum_record.cum_qty_after_cutoff,
2018: --last_cum_qty_update_date = sysdate, --Bugfix 10053830

Line 3990: UPDATE rlm_cust_item_cum_keys

3986:
3987: v_cum_records(v_index).cum_qty :=
3988: v_cum_records(v_index).cum_qty + adj_qty;
3989: --
3990: UPDATE rlm_cust_item_cum_keys
3991: SET cum_qty = v_cum_records(v_index).cum_qty,
3992: cum_qty_to_be_accumulated =
3993: v_cum_records(v_index).cum_qty_to_be_accumulated,
3994: cum_qty_after_cutoff =

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

4703:
4704:
4705: This procedure is called by reset cum. According to the parameters and
4706: the setup terms for the cum, it gets all the cum records from
4707: rlm_cust_item_cum_keys. From the records returned, the program filters
4708: out those recors which do not have any manual adjustments within the period
4709: nor any shipments(if there is any shipment the field last_cum_qty_update_date
4710: would be within the time frame). These records would be sorted, so that all
4711: corresponding Cums are in sorted together(for example same customer items

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

4776: p_bill_to_address_id NUMBER DEFAULT NULL;
4777: p_customer_item_id NUMBER DEFAULT NULL;
4778: msg_data VARCHAR2(2500);
4779: msg_name VARCHAR2(30) DEFAULT NULL;
4780: v_new_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
4781: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE
4782: DEFAULT NULL;
4783: v_ship_from_org_name VARCHAR2(250);
4784: v_customer_name VARCHAR2(360);

Line 4781: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE

4777: p_customer_item_id NUMBER DEFAULT NULL;
4778: msg_data VARCHAR2(2500);
4779: msg_name VARCHAR2(30) DEFAULT NULL;
4780: v_new_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
4781: v_new_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE
4782: DEFAULT NULL;
4783: v_ship_from_org_name VARCHAR2(250);
4784: v_customer_name VARCHAR2(360);
4785: v_ship_to_location VARCHAR2(250);

Line 5004: FROM RLM_CUST_ITEM_CUM_KEYS

5000: --
5001: v_select := 'SELECT cum_key_id, cum_qty, cum_qty_to_be_accumulated, cum_qty_after_cutoff,
5002: last_cum_qty_update_date,cust_uom_code,cum_start_date,
5003: cust_record_year,purchase_order_number ,customer_item_id
5004: FROM RLM_CUST_ITEM_CUM_KEYS
5005: ';
5006:
5007: IF x_rlm_setup_terms_record.cum_control_code = 'CUM_BY_DATE_ONLY'
5008: OR x_rlm_setup_terms_record.cum_control_code = 'CUM_UNTIL_MANUAL_RESET'

Line 6051: UPDATE rlm_cust_item_cum_keys

6047: x_old_cum_records(cum_records_counter).cum_qty :=
6048: x_old_cum_records(cum_records_counter).cum_qty +
6049: nvl(adj_qty,0);
6050: --
6051: UPDATE rlm_cust_item_cum_keys
6052: SET cum_qty = x_old_cum_records(cum_records_counter).cum_qty,
6053: cum_qty_to_be_accumulated =
6054: x_old_cum_records(cum_records_counter).cum_qty_to_be_accumulated,
6055: cum_qty_after_cutoff =

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

6530: p_ship_to_address_id NUMBER DEFAULT NULL;
6531: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
6532: p_bill_to_address_id NUMBER DEFAULT NULL;
6533: p_customer_item_id NUMBER DEFAULT NULL;
6534: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
6535: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
6536: p_cum_start_date DATE DEFAULT NULL;
6537: E_UNEXPECTED EXCEPTION;
6538:

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

6531: p_intrmd_ship_to_address_id NUMBER DEFAULT NULL;
6532: p_bill_to_address_id NUMBER DEFAULT NULL;
6533: p_customer_item_id NUMBER DEFAULT NULL;
6534: p_purchase_order_number RLM_CUST_ITEM_CUM_KEYS.PURCHASE_ORDER_NUMBER%TYPE DEFAULT NULL;
6535: p_cust_record_year RLM_CUST_ITEM_CUM_KEYS.CUST_RECORD_YEAR%TYPE DEFAULT NULL;
6536: p_cum_start_date DATE DEFAULT NULL;
6537: E_UNEXPECTED EXCEPTION;
6538:
6539:

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

6538:
6539:
6540: /* The purpose of the following cursors is to get the cum key id,
6541: cum qty, cum start date, cust record year, po number, etc. that
6542: already exist in rlm_cust_item_cum_keys table. The cum record of
6543: interest is the one that got created last and which cum start date is
6544: no later than sysdate. */
6545:
6546: /* This cursor is used when the proc is called by to get the latest cum

Line 6561: FROM RLM_CUST_ITEM_CUM_KEYS

6557: cust_uom_code,
6558: cum_start_date,
6559: cust_record_year,
6560: purchase_order_number
6561: FROM RLM_CUST_ITEM_CUM_KEYS
6562: WHERE NVL(ship_from_org_id,0) = NVL(p_ship_from_org_id,0)
6563: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6564: AND NVL(intrmd_ship_to_id,0)=
6565: NVL(p_intrmd_ship_to_address_id,0)

Line 6593: FROM RLM_CUST_ITEM_CUM_KEYS

6589: cust_uom_code,
6590: cum_start_date,
6591: cust_record_year,
6592: purchase_order_number
6593: FROM RLM_CUST_ITEM_CUM_KEYS
6594: WHERE ship_from_org_id IS NULL
6595: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6596: AND NVL(intrmd_ship_to_id,0) =
6597: NVL(p_intrmd_ship_to_address_id,0)

Line 6625: FROM RLM_CUST_ITEM_CUM_KEYS

6621: cust_uom_code,
6622: cum_start_date,
6623: cust_record_year,
6624: purchase_order_number
6625: FROM RLM_CUST_ITEM_CUM_KEYS
6626: WHERE NVL(ship_from_org_id,0)= NVL(p_ship_from_org_id,0)
6627: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6628: AND NVL(intrmd_ship_to_id,0)
6629: = NVL(p_intrmd_ship_to_address_id,0)

Line 6660: FROM RLM_CUST_ITEM_CUM_KEYS

6656: cust_uom_code,
6657: cum_start_date,
6658: cust_record_year,
6659: purchase_order_number
6660: FROM RLM_CUST_ITEM_CUM_KEYS
6661: WHERE ship_from_org_id IS NULL
6662: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6663: AND NVL(intrmd_ship_to_id,0)
6664: = NVL(p_intrmd_ship_to_address_id,0)

Line 6695: FROM RLM_CUST_ITEM_CUM_KEYS

6691: cust_uom_code,
6692: cum_start_date,
6693: cust_record_year,
6694: purchase_order_number
6695: FROM RLM_CUST_ITEM_CUM_KEYS
6696: WHERE NVL(ship_from_org_id,0)= NVL(p_ship_from_org_id,0)
6697: AND NVL(ship_to_address_id,0)= NVL(p_ship_to_address_id,0)
6698: AND NVL(intrmd_ship_to_id,0)
6699: = NVL(p_intrmd_ship_to_address_id,0)

Line 6730: FROM RLM_CUST_ITEM_CUM_KEYS

6726: cust_uom_code,
6727: cum_start_date,
6728: cust_record_year,
6729: purchase_order_number
6730: FROM RLM_CUST_ITEM_CUM_KEYS
6731: WHERE ship_from_org_id IS NULL
6732: AND NVL(ship_to_address_id,0) = NVL(p_ship_to_address_id,0)
6733: AND NVL(intrmd_ship_to_id,0)
6734: = NVL(p_intrmd_ship_to_address_id,0)

Line 6978: FROM RLM_CUST_ITEM_CUM_KEYS

6974: x_cum_record.cum_qty_to_be_accumulated,
6975: x_cum_record.cum_qty_after_cutoff,
6976: x_cum_record.last_cum_qty_update_date,
6977: x_cum_record.cust_uom_code
6978: FROM RLM_CUST_ITEM_CUM_KEYS
6979: WHERE NVL(ship_from_org_id,0) = NVL(p_ship_from_org_id,0)
6980: AND NVL(ship_to_address_id,0)
6981: = NVL(p_ship_to_address_id,0)
6982: AND NVL(intrmd_ship_to_id,0)

Line 7011: FROM RLM_CUST_ITEM_CUM_KEYS

7007: x_cum_record.cum_qty_to_be_accumulated,
7008: x_cum_record.cum_qty_after_cutoff,
7009: x_cum_record.last_cum_qty_update_date,
7010: x_cum_record.cust_uom_code
7011: FROM RLM_CUST_ITEM_CUM_KEYS
7012: WHERE ship_from_org_id IS NULL
7013: AND NVL(ship_to_address_id, 0)
7014: = NVL(p_ship_to_address_id,0)
7015: AND NVL(intrmd_ship_to_id, 0)

Line 7154: FROM RLM_CUST_ITEM_CUM_KEYS_ALL

7150: IS
7151: --
7152: CURSOR c IS
7153: SELECT *
7154: FROM RLM_CUST_ITEM_CUM_KEYS_ALL
7155: WHERE cum_key_id = x_CumKeyId
7156: FOR UPDATE NOWAIT;
7157: --
7158:

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

7159: BEGIN
7160: --
7161: IF (l_debug <> -1) THEN
7162: rlm_core_sv.dpush(C_SDEBUG,'LockCumKey');
7163: rlm_core_sv.dlog(C_DEBUG,'Locking RLM_CUST_ITEM_CUM_KEYS_ALL');
7164: END IF;
7165: --
7166: OPEN c;
7167: CLOSE c;

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

7176: --
7177: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
7178: --
7179: IF (l_debug <> -1) THEN
7180: rlm_core_sv.dlog(C_DEBUG,'Cum Key Record in RLM_CUST_ITEM_CUM_KEYS_ALL cannot be locked');
7181: rlm_core_sv.dpop(C_SDEBUG);
7182: END IF;
7183: --
7184: RETURN(FALSE);