76: -- R12 Code Changes
77: );
78:
79: TYPE Site_Rec_Type IS RECORD(
80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
77: );
78:
79: TYPE Site_Rec_Type IS RECORD(
80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
78:
79: TYPE Site_Rec_Type IS RECORD(
80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
79: TYPE Site_Rec_Type IS RECORD(
80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%TYPE,
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%TYPE,
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
92: TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%TYPE
85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%TYPE,
86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%TYPE,
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
92: TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%TYPE
93: -- R12 Code Changes
87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%TYPE,
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
92: TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%TYPE
93: -- R12 Code Changes
94: );
95:
88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%TYPE,
89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%TYPE,
90: -- R12 Code Changes
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,
92: TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%TYPE
93: -- R12 Code Changes
94: );
95:
96: