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