61: -- ER 3992531: Added min_start_date_time to the following record structure.
62:
63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
62:
63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
63: TYPE t_Group_rec IS RECORD(
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
64: customer_id rlm_interface_headers.customer_id%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
65: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
66: ship_to_address_id rlm_interface_lines.ship_to_address_id%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
67: ship_to_site_use_id rlm_interface_lines.ship_to_site_use_id%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
68: ship_to_org_id rlm_interface_lines.ship_to_org_id%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
69: customer_item_id rlm_interface_lines.customer_item_id%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
70: inventory_item_id rlm_interface_lines.inventory_item_id%TYPE,
71: schedule_item_num rlm_interface_lines.schedule_item_num%TYPE,
72: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
73: order_header_id rlm_interface_lines.order_header_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
74: --cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
75: schedule_type_one rlm_interface_headers.schedule_type%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,
76: schedule_type_two rlm_interface_headers.schedule_type%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,
83: match_within_rec rlm_core_sv.t_Match_rec,
84: match_across rlm_cust_shipto_terms.match_across_key%TYPE,
77: schedule_type_three rlm_interface_headers.schedule_type%TYPE,
78: deliver_to_org_id rlm_interface_lines.deliver_to_org_id%TYPE,
79: --need for forecast module
80: bill_to_site_use_id rlm_interface_lines.bill_to_site_use_id%TYPE,
81: bill_to_address_id rlm_interface_lines.bill_to_address_id%TYPE,
82: match_within rlm_cust_shipto_terms.match_within_key%TYPE,
83: match_within_rec rlm_core_sv.t_Match_rec,
84: match_across rlm_cust_shipto_terms.match_across_key%TYPE,
85: match_across_rec rlm_core_sv.t_Match_rec,
89: frozen_days NUMBER,
90: isSourced BOOLEAN,
91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
90: isSourced BOOLEAN,
91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;
91: roll_forward_frozen_flag VARCHAR2(1),
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;
99: g_mf_total NUMBER:=0;
92: blanket_number rlm_cust_shipto_terms.blanket_number%TYPE,
93: min_start_date_time rlm_interface_lines.start_date_time%TYPE,
94: intmed_ship_to_org_id rlm_interface_lines.intmed_ship_to_org_id%TYPE,--Bugfix 5911991
95: intrmd_ship_to_id rlm_interface_lines.intrmd_ship_to_id%TYPE, --Bugfix 5911991
96: ship_to_customer_id rlm_interface_lines.ship_to_customer_id%TYPE
97: );
98: g_md_total NUMBER:=0;
99: g_mf_total NUMBER:=0;
100: g_rd_total NUMBER:=0;