APPS.PER_RI_CONFIG_TECH_SUMMARY dependencies on PER_RI_CONFIG_LOCATIONS

Line 254: ,location_code per_ri_config_locations.description%type -- fix for 4457389

250: (effective_date date
251: ,date_from date
252: ,business_grp_name per_business_groups.name%type
253: ,name per_business_groups.name%type
254: ,location_code per_ri_config_locations.description%type -- fix for 4457389
255: ,internal_external_flag hr_all_organization_units.internal_external_flag%type);
256:
257: -- Enterprise Table
258: TYPE org_ent_tab IS TABLE OF

Line 327: (location_code per_ri_config_locations.description%type --fix for 4457389

323: INDEX BY BINARY_INTEGER;
324:
325:
326: TYPE location_rec IS RECORD
327: (location_code per_ri_config_locations.description%type --fix for 4457389
328: ,description per_ri_config_locations.description%type
329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type

Line 328: ,description per_ri_config_locations.description%type

324:
325:
326: TYPE location_rec IS RECORD
327: (location_code per_ri_config_locations.description%type --fix for 4457389
328: ,description per_ri_config_locations.description%type
329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type

Line 329: ,address_line_1 per_ri_config_locations.address_line_1%type

325:
326: TYPE location_rec IS RECORD
327: (location_code per_ri_config_locations.description%type --fix for 4457389
328: ,description per_ri_config_locations.description%type
329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333: ,country per_ri_config_locations.country%type

Line 330: ,address_line_2 per_ri_config_locations.address_line_2%type

326: TYPE location_rec IS RECORD
327: (location_code per_ri_config_locations.description%type --fix for 4457389
328: ,description per_ri_config_locations.description%type
329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333: ,country per_ri_config_locations.country%type
334: ,in_organization_flag hr_locations_all.in_organization_flag%type

Line 331: ,address_line_3 per_ri_config_locations.address_line_3%type

327: (location_code per_ri_config_locations.description%type --fix for 4457389
328: ,description per_ri_config_locations.description%type
329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333: ,country per_ri_config_locations.country%type
334: ,in_organization_flag hr_locations_all.in_organization_flag%type
335: ,postal_code per_ri_config_locations.postal_code%type

Line 333: ,country per_ri_config_locations.country%type

329: ,address_line_1 per_ri_config_locations.address_line_1%type
330: ,address_line_2 per_ri_config_locations.address_line_2%type
331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333: ,country per_ri_config_locations.country%type
334: ,in_organization_flag hr_locations_all.in_organization_flag%type
335: ,postal_code per_ri_config_locations.postal_code%type
336: ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337: ,region_1 per_ri_config_locations.region_1%type

Line 335: ,postal_code per_ri_config_locations.postal_code%type

331: ,address_line_3 per_ri_config_locations.address_line_3%type
332: ,bill_to_site_flag hr_locations_all.bill_to_site_flag%type
333: ,country per_ri_config_locations.country%type
334: ,in_organization_flag hr_locations_all.in_organization_flag%type
335: ,postal_code per_ri_config_locations.postal_code%type
336: ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337: ,region_1 per_ri_config_locations.region_1%type
338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type

Line 337: ,region_1 per_ri_config_locations.region_1%type

333: ,country per_ri_config_locations.country%type
334: ,in_organization_flag hr_locations_all.in_organization_flag%type
335: ,postal_code per_ri_config_locations.postal_code%type
336: ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337: ,region_1 per_ri_config_locations.region_1%type
338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type

Line 338: ,region_2 per_ri_config_locations.region_2%type

334: ,in_organization_flag hr_locations_all.in_organization_flag%type
335: ,postal_code per_ri_config_locations.postal_code%type
336: ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337: ,region_1 per_ri_config_locations.region_1%type
338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type

Line 339: ,region_3 per_ri_config_locations.region_3%type

335: ,postal_code per_ri_config_locations.postal_code%type
336: ,receiving_site_flag hr_locations_all.receiving_site_flag%type
337: ,region_1 per_ri_config_locations.region_1%type
338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type

Line 341: ,style per_ri_config_locations.style%type

337: ,region_1 per_ri_config_locations.region_1%type
338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type

Line 342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type

338: ,region_2 per_ri_config_locations.region_2%type
339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type

Line 343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type

339: ,region_3 per_ri_config_locations.region_3%type
340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type

Line 344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type

340: ,ship_to_site_flag hr_locations_all.ship_to_site_flag%type
341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type

Line 345: ,town_or_city per_ri_config_locations.town_or_city%type

341: ,style per_ri_config_locations.style%type
342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type

Line 346: ,loc_information13 per_ri_config_locations.loc_information13%type

342: ,telephone_number_1 per_ri_config_locations.telephone_number_1%type
343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type

Line 347: ,loc_information14 per_ri_config_locations.loc_information14%type

343: ,telephone_number_2 per_ri_config_locations.telephone_number_2%type
344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type

Line 348: ,loc_information15 per_ri_config_locations.loc_information15%type

344: ,telephone_number_3 per_ri_config_locations.telephone_number_3%type
345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type

Line 349: ,loc_information16 per_ri_config_locations.loc_information16%type

345: ,town_or_city per_ri_config_locations.town_or_city%type
346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type

Line 350: ,loc_information17 per_ri_config_locations.loc_information17%type

346: ,loc_information13 per_ri_config_locations.loc_information13%type
347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type
354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389

Line 351: ,loc_information18 per_ri_config_locations.loc_information18%type

347: ,loc_information14 per_ri_config_locations.loc_information14%type
348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type
354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389
355:

Line 352: ,loc_information19 per_ri_config_locations.loc_information19%type

348: ,loc_information15 per_ri_config_locations.loc_information15%type
349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type
354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389
355:
356: TYPE location_tab IS TABLE OF

Line 353: ,loc_information20 per_ri_config_locations.loc_information20%type

349: ,loc_information16 per_ri_config_locations.loc_information16%type
350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type
354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389
355:
356: TYPE location_tab IS TABLE OF
357: location_rec

Line 354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389

350: ,loc_information17 per_ri_config_locations.loc_information17%type
351: ,loc_information18 per_ri_config_locations.loc_information18%type
352: ,loc_information19 per_ri_config_locations.loc_information19%type
353: ,loc_information20 per_ri_config_locations.loc_information20%type
354: ,ship_to_location_code per_ri_config_locations.description%type); -- fix for 4457389
355:
356: TYPE location_tab IS TABLE OF
357: location_rec
358: INDEX BY BINARY_INTEGER;