APPS.XLE_BUSINESSINFO_GRP dependencies on HR_LOCATIONS_ALL

Line 44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

40: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

41: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

42: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

43: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

44: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

45: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
53:

Line 50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

46: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
53:
54: );

Line 51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

47: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
53:
54: );
55:

Line 52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

48: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
49: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
50: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
51: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
52: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
53:
54: );
55:
56: TYPE LE_Ledger_Rec_Type IS TABLE OF LE_Ledger_Rec INDEX BY BINARY_INTEGER;

Line 74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

70: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

71: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

72: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

73: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

74: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

75: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
83:

Line 80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

76: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
83:
84: );

Line 81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

77: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
83:
84: );
85:

Line 82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

78: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
79: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
80: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
81: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
82: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
83:
84: );
85:
86: TYPE inv_org_Rec_Type IS TABLE OF inv_org_Rec INDEX BY BINARY_INTEGER;

Line 105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

101: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

102: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

103: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

104: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

105: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

106: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
114: );

Line 111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

107: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
114: );
115:

Line 112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

108: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
114: );
115:
116: TYPE OU_LE_Tbl_Type IS TABLE OF OU_LE_Rec INDEX BY BINARY_INTEGER;

Line 113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

109: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
110: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
111: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
112: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
113: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
114: );
115:
116: TYPE OU_LE_Tbl_Type IS TABLE OF OU_LE_Rec INDEX BY BINARY_INTEGER;
117:

Line 186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

182: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

183: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

184: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

185: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

186: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

187: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

Line 192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

188: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,

Line 193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

189: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,

Line 194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

190: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,

Line 195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

191: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,

Line 196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,

192: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,

Line 197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,

193: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,

Line 198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,

194: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,

Line 199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,

195: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,

Line 200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,

196: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,

Line 201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,

197: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,

Line 202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,

198: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,

Line 203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,

199: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,

Line 204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,

200: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,

Line 205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,

201: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,

Line 206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,

202: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,

Line 207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,

203: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,

Line 208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,

204: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,

Line 209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,

205: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,

Line 210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,

206: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,

Line 211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,

207: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE

Line 212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,

208: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
216: );

Line 213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,

209: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
216: );
217:

Line 214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,

210: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
216: );
217:
218: TYPE ccid_le_Rec_Type IS TABLE OF ccid_le_Rec INDEX BY BINARY_INTEGER;

Line 215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE

211: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
212: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
213: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
214: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
215: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
216: );
217:
218: TYPE ccid_le_Rec_Type IS TABLE OF ccid_le_Rec INDEX BY BINARY_INTEGER;
219:

Line 243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

239: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

240: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

241: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

242: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

243: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

244: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
252: );

Line 249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

245: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
252: );
253:

Line 250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

246: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
252: );
253:
254: PROCEDURE Get_PurchasetoPay_Info(

Line 251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

247: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
248: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
249: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
250: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
251: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
252: );
253:
254: PROCEDURE Get_PurchasetoPay_Info(
255: x_return_status OUT NOCOPY VARCHAR2,

Line 279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,

275: REGISTRATION_NUMBER XLE_REGISTRATIONS.REGISTRATION_NUMBER%TYPE,
276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

Line 280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

276: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

277: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

278: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

279: ADDRESS_STYLE HR_LOCATIONS_ALL.STYLE%TYPE,
280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

280: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

Line 285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

281: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,

Line 286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

282: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,

Line 287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

283: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,

Line 288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,

284: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,

Line 289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,

285: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,

Line 290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,

286: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,

Line 291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,

287: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,

Line 292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,

288: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE,
289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,

Line 293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,

289: ATTRIBUTE1 HR_LOCATIONS_ALL.ATTRIBUTE1%TYPE,
290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,

Line 294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,

290: ATTRIBUTE2 HR_LOCATIONS_ALL.ATTRIBUTE2%TYPE,
291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,

Line 295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,

291: ATTRIBUTE3 HR_LOCATIONS_ALL.ATTRIBUTE3%TYPE,
292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,

Line 296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,

292: ATTRIBUTE4 HR_LOCATIONS_ALL.ATTRIBUTE4%TYPE,
293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,

Line 297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,

293: ATTRIBUTE5 HR_LOCATIONS_ALL.ATTRIBUTE5%TYPE,
294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,

Line 298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,

294: ATTRIBUTE6 HR_LOCATIONS_ALL.ATTRIBUTE6%TYPE,
295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,

Line 299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,

295: ATTRIBUTE7 HR_LOCATIONS_ALL.ATTRIBUTE7%TYPE,
296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,

Line 300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,

296: ATTRIBUTE8 HR_LOCATIONS_ALL.ATTRIBUTE8%TYPE,
297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,

Line 301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,

297: ATTRIBUTE9 HR_LOCATIONS_ALL.ATTRIBUTE9%TYPE,
298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,

Line 302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,

298: ATTRIBUTE10 HR_LOCATIONS_ALL.ATTRIBUTE10%TYPE,
299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,

Line 303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,

299: ATTRIBUTE11 HR_LOCATIONS_ALL.ATTRIBUTE11%TYPE,
300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,

Line 304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,

300: ATTRIBUTE12 HR_LOCATIONS_ALL.ATTRIBUTE12%TYPE,
301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE

Line 305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,

301: ATTRIBUTE13 HR_LOCATIONS_ALL.ATTRIBUTE13%TYPE,
302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
309: );

Line 306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,

302: ATTRIBUTE14 HR_LOCATIONS_ALL.ATTRIBUTE14%TYPE,
303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
309: );
310:

Line 307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,

303: ATTRIBUTE15 HR_LOCATIONS_ALL.ATTRIBUTE15%TYPE,
304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
309: );
310:
311: PROCEDURE Get_OrdertoCash_Info(

Line 308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE

304: ATTRIBUTE16 HR_LOCATIONS_ALL.ATTRIBUTE16%TYPE,
305: ATTRIBUTE17 HR_LOCATIONS_ALL.ATTRIBUTE17%TYPE,
306: ATTRIBUTE18 HR_LOCATIONS_ALL.ATTRIBUTE18%TYPE,
307: ATTRIBUTE19 HR_LOCATIONS_ALL.ATTRIBUTE19%TYPE,
308: ATTRIBUTE20 HR_LOCATIONS_ALL.ATTRIBUTE20%TYPE
309: );
310:
311: PROCEDURE Get_OrdertoCash_Info(
312: x_return_status OUT NOCOPY VARCHAR2,