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.WSH_CUSTOM_PUB dependencies on WSH_LOCATIONS_PKG

Line 82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,

78:
79: --Added as a part of bugfix4995478
80: -- PROCEDURE: ui_location_code
81: -- Parameters: p_location_type IN VARCHAR2,
82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

79: --Added as a part of bugfix4995478
80: -- PROCEDURE: ui_location_code
81: -- Parameters: p_location_type IN VARCHAR2,
82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

80: -- PROCEDURE: ui_location_code
81: -- Parameters: p_location_type IN VARCHAR2,
82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

81: -- Parameters: p_location_type IN VARCHAR2,
82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

82: -- p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

83: -- p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

84: -- p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

85: -- p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93: -- x_use_custom_ui_location OUT VARCHAR2,

Line 90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

86: -- p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93: -- x_use_custom_ui_location OUT VARCHAR2,
94: -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

Line 91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

87: -- p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93: -- x_use_custom_ui_location OUT VARCHAR2,
94: -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
95: -- This procedure is designed for the user to customize the location (ui_location_code)

Line 92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

88: -- p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
89: -- p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93: -- x_use_custom_ui_location OUT VARCHAR2,
94: -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
95: -- This procedure is designed for the user to customize the location (ui_location_code)
96: -- information displayed in Shipping Forms.

Line 94: -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

90: -- p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
91: -- p_party_site_numberTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
92: -- p_location_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
93: -- x_use_custom_ui_location OUT VARCHAR2,
94: -- x_custom_ui_loc_codeTbl OUT WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
95: -- This procedure is designed for the user to customize the location (ui_location_code)
96: -- information displayed in Shipping Forms.
97: -- To use this procedure user has to set the value of PL/SQL variable
98: -- x_use_custom_ui_location to 'Y' in package body.

Line 102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,

98: -- x_use_custom_ui_location to 'Y' in package body.
99: --
100: PROCEDURE ui_location_code(
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

99: --
100: PROCEDURE ui_location_code(
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

100: PROCEDURE ui_location_code(
101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

101: p_location_type IN VARCHAR2,
102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

102: p_location_idTbl IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

Line 107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

103: p_address_1Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

104: p_address_2Tbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

Line 109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

105: p_countryTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,

Line 110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,

106: p_stateTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

Line 111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

107: p_provinceTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: );

Line 112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

108: p_countyTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
109: p_cityTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: );
116:

Line 114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type

110: p_postal_codeTbl IN WSH_LOCATIONS_PKG.Address_Tbl_Type ,
111: p_party_site_numberTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
112: p_location_codeTbl IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
113: x_use_custom_ui_location OUT NOCOPY VARCHAR2,
114: x_custom_ui_loc_codeTbl OUT NOCOPY WSH_LOCATIONS_PKG.LocationCode_Tbl_Type
115: );
116:
117: PROCEDURE Shipped_Lines(
118: p_source_header_id in number,