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_ALL

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 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 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;