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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HR_LOCATIONS

Line 237: l_location_id hr_locations_all.location_id%TYPE;

233: EXCP_USER_DEFINED EXCEPTION;
234:
235: l_validate BOOLEAN := false;
236: l_effective_date DATE := sysdate;
237: l_location_id hr_locations_all.location_id%TYPE;
238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';

Line 238: l_language hr_locations_all_tl.language%TYPE;

234:
235: l_validate BOOLEAN := false;
236: l_effective_date DATE := sysdate;
237: l_location_id hr_locations_all.location_id%TYPE;
238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';

Line 239: l_location_code hr_locations_all.location_code%TYPE := NULL;

235: l_validate BOOLEAN := false;
236: l_effective_date DATE := sysdate;
237: l_location_id hr_locations_all.location_id%TYPE;
238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;

Line 240: l_description hr_locations_all.description%TYPE := NULL;

236: l_effective_date DATE := sysdate;
237: l_location_id hr_locations_all.location_id%TYPE;
238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;

Line 241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';

237: l_location_id hr_locations_all.location_id%TYPE;
238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;

Line 242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';

238: l_language hr_locations_all_tl.language%TYPE;
239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';

Line 243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;

239: l_location_code hr_locations_all.location_code%TYPE := NULL;
240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;

Line 244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;

240: l_description hr_locations_all.description%TYPE := NULL;
241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;

Line 245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;

241: l_bill_to_site_flag hr_locations_all.bill_to_site_flag%TYPE := 'Y';
242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;

Line 246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';

242: l_ship_to_site_flag hr_locations_all.ship_to_site_flag%TYPE := 'Y';
243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';

Line 247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;

243: l_tp_header_id hr_locations_all.tp_header_id%TYPE := NULL;
244: l_ece_tp_location_code hr_locations_all.ece_tp_location_code%TYPE := NULL;
245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';
251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';

Line 249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;

245: l_designated_receiver_id hr_locations_all.designated_receiver_id%TYPE := NULL;
246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';
251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';
252: l_ship_to_location_id hr_locations_all.ship_to_location_id%TYPE := NULL;
253:

Line 250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';

246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'Y';
247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';
251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';
252: l_ship_to_location_id hr_locations_all.ship_to_location_id%TYPE := NULL;
253:
254: BEGIN

Line 251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';

247: l_inactive_date hr_locations_all.inactive_date%TYPE := NULL;
248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';
251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';
252: l_ship_to_location_id hr_locations_all.ship_to_location_id%TYPE := NULL;
253:
254: BEGIN
255: SAVEPOINT do_create_ship_to_location_PUB;

Line 252: l_ship_to_location_id hr_locations_all.ship_to_location_id%TYPE := NULL;

248: l_operating_unit_id NUMBER := NULL;
249: l_inventory_organization_id hr_locations_all.inventory_organization_id%TYPE := NULL;
250: l_office_site_flag hr_locations_all.office_site_flag%TYPE := 'Y';
251: l_receiving_site_flag hr_locations_all.receiving_site_flag%TYPE := 'Y';
252: l_ship_to_location_id hr_locations_all.ship_to_location_id%TYPE := NULL;
253:
254: BEGIN
255: SAVEPOINT do_create_ship_to_location_PUB;
256:

Line 442: l_object_version_number hr_locations_all.object_version_number%TYPE := NULL;

438: l_api_name CONSTANT VARCHAR2(30) := 'do_update_ship_to_location';
439: l_language VARCHAR2(4);
440: EXCP_USER_DEFINED EXCEPTION;
441:
442: l_object_version_number hr_locations_all.object_version_number%TYPE := NULL;
443:
444: BEGIN
445: SAVEPOINT do_update_ship_to_location_PUB;
446:

Line 660: s_location_id hr_locations.location_id%TYPE := p_location_id;

656: l_api_name CONSTANT VARCHAR2(30) := 'do_create_site_use';
657: l_language VARCHAR2(4);
658: EXCP_USER_DEFINED EXCEPTION;
659:
660: s_location_id hr_locations.location_id%TYPE := p_location_id;
661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
664: s_status hz_cust_site_uses_all.status%TYPE := NULL;

Line 2219: l_location_id hr_locations_all.location_id%TYPE := NULL;

2215:
2216: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;

Line 2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;

2216: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;

Line 2466: t_site_loc_id hr_locations.location_id%TYPE;

2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;
2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2468: t_last_update_date DATE;
2469: t_party_site_last_update_date DATE;
2470: t_loc_last_update_date DATE;

Line 2584: global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20 from hr_locations where location_id = l_inv_location_id;

2580: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
2581: attribute12, attribute13, attribute14, attribute15, attribute16, attribute17, attribute18, attribute19, attribute20, global_attribute_category,
2582: global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7,
2583: global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14,
2584: global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20 from hr_locations where location_id = l_inv_location_id;
2585:
2586: CURSOR l_identify_address_flag_csr IS
2587: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';
2588:

Line 3233: Provice is stored in region_1 not in Region_3 of hr_locations_v*/

3229: RAISE EXCP_USER_DEFINED;
3230: END IF;
3231: CLOSE l_inv_loc_csr;
3232: /* As part of bug fix following code is included for canadian address ,
3233: Provice is stored in region_1 not in Region_3 of hr_locations_v*/
3234: l_column_NAME := null;
3235: OPEN province_enabled;
3236: FETCH province_enabled INTO l_column_NAME;
3237: CLOSE province_enabled;

Line 3836: l_inv_loc_id hr_locations.location_id%type;

3832:
3833: l_api_version_number CONSTANT NUMBER := 1.0;
3834: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
3835: EXCP_USER_DEFINED EXCEPTION;
3836: l_inv_loc_id hr_locations.location_id%type;
3837: l_object_version_number hr_locations.object_version_number%type;
3838:
3839: BEGIN
3840: SAVEPOINT site_to_invloc_linkage_PUB;

Line 3837: l_object_version_number hr_locations.object_version_number%type;

3833: l_api_version_number CONSTANT NUMBER := 1.0;
3834: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
3835: EXCP_USER_DEFINED EXCEPTION;
3836: l_inv_loc_id hr_locations.location_id%type;
3837: l_object_version_number hr_locations.object_version_number%type;
3838:
3839: BEGIN
3840: SAVEPOINT site_to_invloc_linkage_PUB;
3841:

Line 4032: l_inv_loc_id hr_locations.location_id%type;

4028:
4029: l_api_version_number CONSTANT NUMBER := 1.0;
4030: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4031: EXCP_USER_DEFINED EXCEPTION;
4032: l_inv_loc_id hr_locations.location_id%type;
4033: l_object_version_number hr_locations.object_version_number%type;
4034: l_town_or_city varchar2(30);
4035: l_region_1 varchar2(120);
4036: cursor get_csp_location is

Line 4033: l_object_version_number hr_locations.object_version_number%type;

4029: l_api_version_number CONSTANT NUMBER := 1.0;
4030: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4031: EXCP_USER_DEFINED EXCEPTION;
4032: l_inv_loc_id hr_locations.location_id%type;
4033: l_object_version_number hr_locations.object_version_number%type;
4034: l_town_or_city varchar2(30);
4035: l_region_1 varchar2(120);
4036: cursor get_csp_location is
4037: select STYLE,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,TOWN_OR_CITY,COUNTRY

Line 4043: from hr_locations

4039: ,LOC_INFORMATION14,LOC_INFORMATION15,LOC_INFORMATION16,LOC_INFORMATION17,LOC_INFORMATION18,LOC_INFORMATION19
4040: ,LOC_INFORMATION20,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5
4041: ,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
4042: ,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,TAX_NAME
4043: from hr_locations
4044: where location_code like 'CSP%'
4045: and country = p_country ;
4046:
4047: cursor get_country_location is

Line 4054: from hr_locations

4050: ,LOC_INFORMATION14,LOC_INFORMATION15,LOC_INFORMATION16,LOC_INFORMATION17,LOC_INFORMATION18,LOC_INFORMATION19
4051: ,LOC_INFORMATION20,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5
4052: ,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
4053: ,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,TAX_NAME
4054: from hr_locations
4055: where country = p_country ;
4056:
4057: csp_location_rec get_csp_location%ROWTYPE;
4058: BEGIN