APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on RLM_CUST_SHIPTO_TERMS

Line 56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,

52: ATPItemFlag BOOLEAN,
53: --
54: PrimaryQuantity NUMBER,
55: EndDateTime DATE,
56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,

Line 57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,

53: --
54: PrimaryQuantity NUMBER,
55: EndDateTime DATE,
56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,

Line 58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,

54: PrimaryQuantity NUMBER,
55: EndDateTime DATE,
56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,

Line 59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,

55: EndDateTime DATE,
56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,
63: sched_horizon_start_date rlm_interface_headers.sched_horizon_start_date%TYPE,

Line 60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,

56: use_edi_sdp_code_flag rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,
63: sched_horizon_start_date rlm_interface_headers.sched_horizon_start_date%TYPE,
64: exclude_non_workdays_flag rlm_cust_shipto_terms.exclude_non_workdays_flag%TYPE,

Line 61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,

57: DefaultSDP rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,
63: sched_horizon_start_date rlm_interface_headers.sched_horizon_start_date%TYPE,
64: exclude_non_workdays_flag rlm_cust_shipto_terms.exclude_non_workdays_flag%TYPE,
65: ShiptoCustomerId rlm_interface_lines.ship_to_customer_id%TYPE);

Line 62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,

58: ship_method rlm_cust_shipto_terms.ship_method%TYPE,
59: intransit_time rlm_cust_shipto_terms.intransit_time%TYPE,
60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,
63: sched_horizon_start_date rlm_interface_headers.sched_horizon_start_date%TYPE,
64: exclude_non_workdays_flag rlm_cust_shipto_terms.exclude_non_workdays_flag%TYPE,
65: ShiptoCustomerId rlm_interface_lines.ship_to_customer_id%TYPE);
66:

Line 64: exclude_non_workdays_flag rlm_cust_shipto_terms.exclude_non_workdays_flag%TYPE,

60: time_uom_code rlm_cust_shipto_terms.time_uom_code%TYPE,
61: customer_rcv_calendar_cd rlm_cust_shipto_terms.customer_rcv_calendar_cd%TYPE,
62: supplier_shp_calendar_cd rlm_cust_shipto_terms.supplier_shp_calendar_cd%TYPE,
63: sched_horizon_start_date rlm_interface_headers.sched_horizon_start_date%TYPE,
64: exclude_non_workdays_flag rlm_cust_shipto_terms.exclude_non_workdays_flag%TYPE,
65: ShiptoCustomerId rlm_interface_lines.ship_to_customer_id%TYPE);
66:
67: TYPE t_BucketRec IS RECORD (
68: ShipDeliveryRuleName VARCHAR2(30),

Line 185: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,

181: bsadri 11/2/00 added parameters
182: ===========================================================================*/
183:
184: PROCEDURE determine_sdp_code( ShipDeliveryRuleName IN VARCHAR2,
185: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
186: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
187: x_customer_id IN NUMBER,
188: x_shipFromOrg IN NUMBER,
189: x_shipTo IN NUMBER,

Line 186: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,

182: ===========================================================================*/
183:
184: PROCEDURE determine_sdp_code( ShipDeliveryRuleName IN VARCHAR2,
185: use_edi_sdp_code_flag IN rlm_cust_shipto_terms.use_edi_sdp_code_flag%TYPE,
186: DefaultSDP IN rlm_cust_shipto_terms.ship_delivery_rule_name%TYPE,
187: x_customer_id IN NUMBER,
188: x_shipFromOrg IN NUMBER,
189: x_shipTo IN NUMBER,
190: x_ReturnMessage IN OUT NOCOPY t_ErrorMsgTable,