DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on HR_LOCATIONS

Line 19: location_code hr_locations.location_code%TYPE,

15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,

Line 20: address_line_1 hr_locations.address_line_1%TYPE,

16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,

Line 21: address_line_2 hr_locations.address_line_2%TYPE,

17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,

Line 22: address_line_3 hr_locations.address_line_3%TYPE,

18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,

Line 23: city hr_locations.town_or_city%TYPE,

19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,

Line 24: state hr_locations.region_2%TYPE,

20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,

Line 25: postal_code hr_locations.postal_code%TYPE,

21: address_line_2 hr_locations.address_line_2%TYPE,
22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,

Line 26: province hr_locations.region_1%TYPE,

22: address_line_3 hr_locations.address_line_3%TYPE,
23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,

Line 27: county hr_locations.region_1%TYPE,

23: city hr_locations.town_or_city%TYPE,
24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,

Line 28: country hr_locations.country%TYPE,

24: state hr_locations.region_2%TYPE,
25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,

Line 105: style hr_locations.style%TYPE,

101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
104: group_id ap_invoices_interface.group_id%TYPE,
105: style hr_locations.style%TYPE,
106: org_id ap_expense_report_headers_all.org_id%TYPE,
107: invoice_id ap_invoices_interface.invoice_id%TYPE,
108: invoice_type_lookup_code ap_invoices_interface.invoice_type_lookup_code%TYPE,
109: gl_date ap_invoices_interface.gl_date%TYPE,

Line 239: address_line_1 hr_locations.address_line_1%TYPE,

235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,

Line 240: address_line_2 hr_locations.address_line_2%TYPE,

236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,

Line 241: address_line_3 hr_locations.address_line_3%TYPE,

237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,

Line 242: city hr_locations.town_or_city%TYPE,

238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,

Line 243: state hr_locations.region_2%TYPE,

239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,

Line 244: postal_code hr_locations.postal_code%TYPE,

240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,
248: style hr_locations.style%TYPE);

Line 245: province hr_locations.region_1%TYPE,

241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,
248: style hr_locations.style%TYPE);
249:

Line 246: county hr_locations.region_1%TYPE,

242: city hr_locations.town_or_city%TYPE,
243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,
248: style hr_locations.style%TYPE);
249:
250: ------------------------------------------------------------------------

Line 247: country hr_locations.country%TYPE,

243: state hr_locations.region_2%TYPE,
244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,
248: style hr_locations.style%TYPE);
249:
250: ------------------------------------------------------------------------
251: PROCEDURE UpdateDistsWithReceiptInfo(p_report_header_id IN NUMBER,

Line 248: style hr_locations.style%TYPE);

244: postal_code hr_locations.postal_code%TYPE,
245: province hr_locations.region_1%TYPE,
246: county hr_locations.region_1%TYPE,
247: country hr_locations.country%TYPE,
248: style hr_locations.style%TYPE);
249:
250: ------------------------------------------------------------------------
251: PROCEDURE UpdateDistsWithReceiptInfo(p_report_header_id IN NUMBER,
252: p_debug_switch IN VARCHAR2);