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 := 'N';

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 := 'N';
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 := 'N';
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 := 'N';
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 := 'N';

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 := 'N';
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 := 'N';

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 := 'N';
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 := 'N';
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 := 'N';
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 := 'N';
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 := 'N';

246: l_in_organization_flag hr_locations_all.in_organization_flag%TYPE := 'N';
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 := 'N';
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: l_in_hr_loc_hook_rec hr_location_record.location_rectype;

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 := 'N';
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: l_in_hr_loc_hook_rec hr_location_record.location_rectype;
255: l_out_hr_loc_hook_rec hr_location_record.location_rectype;

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 := 'N';
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: l_in_hr_loc_hook_rec hr_location_record.location_rectype;
255: l_out_hr_loc_hook_rec hr_location_record.location_rectype;
256:

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

918: l_api_name CONSTANT VARCHAR2(30) := 'do_update_ship_to_location';
919: l_language VARCHAR2(4);
920: EXCP_USER_DEFINED EXCEPTION;
921:
922: l_object_version_number hr_locations_all.object_version_number%TYPE := NULL;
923:
924: BEGIN
925: SAVEPOINT do_update_ship_to_location_PUB;
926:

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

1137: l_api_name CONSTANT VARCHAR2(30) := 'do_create_site_use';
1138: l_language VARCHAR2(4);
1139: EXCP_USER_DEFINED EXCEPTION;
1140:
1141: s_location_id hr_locations.location_id%TYPE := p_location_id;
1142: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1143: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1144: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;

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

2721:
2722: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;

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

2722: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;

Line 2972: t_site_loc_id hr_locations.location_id%TYPE;

2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;
2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2974: t_last_update_date DATE;
2975: t_party_site_last_update_date DATE;
2976: t_loc_last_update_date DATE;

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

3088: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
3089: attribute12, attribute13, attribute14, attribute15, attribute16, attribute17, attribute18, attribute19, attribute20, global_attribute_category,
3090: global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7,
3091: global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14,
3092: global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20 from hr_locations where location_id = l_inv_location_id;
3093:
3094: CURSOR l_identify_address_flag_csr IS
3095: select identifying_address_flag from hz_party_sites where party_id = l_party_id and identifying_address_flag = 'Y' and status = 'A';
3096:

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

3787: s_province := p_province;
3788: s_address_lines_phonetic := p_address_lines_phonetic;
3789: s_address4 := p_address_line_4;
3790: /* As part of bug fix following code is included for canadian address ,
3791: Provice is stored in region_1 not in Region_3 of hr_locations_v*/
3792: l_column_NAME := null;
3793: OPEN province_enabled;
3794: FETCH province_enabled INTO l_column_NAME;
3795: CLOSE province_enabled;

Line 4418: l_inv_loc_id hr_locations.location_id%type;

4414:
4415: l_api_version_number CONSTANT NUMBER := 1.0;
4416: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4417: EXCP_USER_DEFINED EXCEPTION;
4418: l_inv_loc_id hr_locations.location_id%type;
4419: l_object_version_number hr_locations.object_version_number%type;
4420:
4421: BEGIN
4422: SAVEPOINT site_to_invloc_linkage_PUB;

Line 4419: l_object_version_number hr_locations.object_version_number%type;

4415: l_api_version_number CONSTANT NUMBER := 1.0;
4416: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4417: EXCP_USER_DEFINED EXCEPTION;
4418: l_inv_loc_id hr_locations.location_id%type;
4419: l_object_version_number hr_locations.object_version_number%type;
4420:
4421: BEGIN
4422: SAVEPOINT site_to_invloc_linkage_PUB;
4423:

Line 4614: l_inv_loc_id hr_locations.location_id%type;

4610:
4611: l_api_version_number CONSTANT NUMBER := 1.0;
4612: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4613: EXCP_USER_DEFINED EXCEPTION;
4614: l_inv_loc_id hr_locations.location_id%type;
4615: l_object_version_number hr_locations.object_version_number%type;
4616: l_town_or_city varchar2(30);
4617: l_region_1 varchar2(120);
4618: cursor get_csp_location is

Line 4615: l_object_version_number hr_locations.object_version_number%type;

4611: l_api_version_number CONSTANT NUMBER := 1.0;
4612: l_api_name CONSTANT VARCHAR2(30) := 'site_to_invloc_linkage';
4613: EXCP_USER_DEFINED EXCEPTION;
4614: l_inv_loc_id hr_locations.location_id%type;
4615: l_object_version_number hr_locations.object_version_number%type;
4616: l_town_or_city varchar2(30);
4617: l_region_1 varchar2(120);
4618: cursor get_csp_location is
4619: select STYLE,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,TOWN_OR_CITY,COUNTRY

Line 4625: from hr_locations

4621: ,LOC_INFORMATION14,LOC_INFORMATION15,LOC_INFORMATION16,LOC_INFORMATION17,LOC_INFORMATION18,LOC_INFORMATION19
4622: ,LOC_INFORMATION20,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5
4623: ,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
4624: ,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,TAX_NAME
4625: from hr_locations
4626: where location_code like 'CSP%'
4627: and country = p_country ;
4628:
4629: cursor get_country_location is

Line 4636: from hr_locations

4632: ,LOC_INFORMATION14,LOC_INFORMATION15,LOC_INFORMATION16,LOC_INFORMATION17,LOC_INFORMATION18,LOC_INFORMATION19
4633: ,LOC_INFORMATION20,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5
4634: ,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
4635: ,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,TAX_NAME
4636: from hr_locations
4637: where country = p_country ;
4638:
4639: csp_location_rec get_csp_location%ROWTYPE;
4640: l_org_id number;

Line 6346: FROM hr_locations_all hra

6342: hra.attribute17,
6343: hra.attribute18,
6344: hra.attribute19,
6345: hra.attribute20
6346: FROM hr_locations_all hra
6347: where hra.location_id = p_location_id;
6348: BEGIN
6349: l_module_name := 'csp.plsql.csp_ship_to_address_pvt.ship_to_address_handler2';
6350: v_location_id := p_location_id;