DBA Data[Home] [Help]

APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIER_SITES

Line 80: CARRIER_ID WSH_CARRIER_SITES.CARRIER_ID%TYPE,

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,

Line 81: CARRIER_SITE_ID WSH_CARRIER_SITES.CARRIER_SITE_ID%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,

Line 82: EMAIL_ADDRESS WSH_CARRIER_SITES.EMAIL_ADDRESS%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,

Line 83: AUTO_ACCEPT_LOAD_TENDER WSH_CARRIER_SITES.AUTO_ACCEPT_LOAD_TENDER%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,

Line 84: TENDER_WAIT_TIME WSH_CARRIER_SITES.TENDER_WAIT_TIME%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,

Line 85: WAIT_TIME_UOM WSH_CARRIER_SITES.WAIT_TIME_UOM%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,

Line 86: WEIGHT_THRESHOLD_UPPER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_UPPER%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

Line 87: WEIGHT_THRESHOLD_LOWER WSH_CARRIER_SITES.WEIGHT_THRESHOLD_LOWER%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
91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%TYPE,

Line 88: VOLUME_THRESHOLD_UPPER WSH_CARRIER_SITES.VOLUME_THRESHOLD_UPPER%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

Line 89: VOLUME_THRESHOLD_LOWER WSH_CARRIER_SITES.VOLUME_THRESHOLD_LOWER%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

Line 91: ENABLE_AUTO_TENDER WSH_CARRIER_SITES.ENABLE_AUTO_TENDER%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
94: );
95:

Line 92: TENDER_TRANSMISSION_METHOD WSH_CARRIER_SITES.TENDER_TRANSMISSION_METHOD%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:
96: