APPS.OZF_PARTY_MERGE_PVT dependencies on OZF_RESALE_LINES_ALL

Line 1942: UPDATE ozf_resale_lines_all

1938: IF p_from_fk_id <> p_to_fk_id THEN
1939: BEGIN
1940: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1941:
1942: UPDATE ozf_resale_lines_all
1943: SET ship_from_contact_party_id = p_to_fk_id,
1944: last_update_date = hz_utility_pub.last_update_date,
1945: last_updated_by = hz_utility_pub.user_id,
1946: last_update_login = hz_utility_pub.last_update_login,

Line 2011: UPDATE ozf_resale_lines_all

2007: IF p_from_fk_id <> p_to_fk_id THEN
2008: BEGIN
2009: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2010:
2011: UPDATE ozf_resale_lines_all
2012: SET sold_from_contact_party_id = p_to_fk_id,
2013: last_update_date = hz_utility_pub.last_update_date,
2014: last_updated_by = hz_utility_pub.user_id,
2015: last_update_login = hz_utility_pub.last_update_login,

Line 2080: UPDATE ozf_resale_lines_all

2076: IF p_from_fk_id <> p_to_fk_id THEN
2077: BEGIN
2078: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2079:
2080: UPDATE ozf_resale_lines_all
2081: SET bill_to_party_id = p_to_fk_id,
2082: last_update_date = hz_utility_pub.last_update_date,
2083: last_updated_by = hz_utility_pub.user_id,
2084: last_update_login = hz_utility_pub.last_update_login,

Line 2150: UPDATE ozf_resale_lines_all

2146: IF p_from_fk_id <> p_to_fk_id THEN
2147: BEGIN
2148: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2149:
2150: UPDATE ozf_resale_lines_all
2151: SET bill_to_contact_party_id = p_to_fk_id,
2152: last_update_date = hz_utility_pub.last_update_date,
2153: last_updated_by = hz_utility_pub.user_id,
2154: last_update_login = hz_utility_pub.last_update_login,

Line 2220: UPDATE ozf_resale_lines_all

2216: IF p_from_fk_id <> p_to_fk_id THEN
2217: BEGIN
2218: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2219:
2220: UPDATE ozf_resale_lines_all
2221: SET ship_to_party_id = p_to_fk_id,
2222: last_update_date = hz_utility_pub.last_update_date,
2223: last_updated_by = hz_utility_pub.user_id,
2224: last_update_login = hz_utility_pub.last_update_login,

Line 2290: UPDATE ozf_resale_lines_all

2286: IF p_from_fk_id <> p_to_fk_id THEN
2287: BEGIN
2288: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2289:
2290: UPDATE ozf_resale_lines_all
2291: SET ship_to_contact_party_id = p_to_fk_id,
2292: last_update_date = hz_utility_pub.last_update_date,
2293: last_updated_by = hz_utility_pub.user_id,
2294: last_update_login = hz_utility_pub.last_update_login,

Line 2359: UPDATE ozf_resale_lines_all

2355: IF p_from_fk_id <> p_to_fk_id THEN
2356: BEGIN
2357: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2358:
2359: UPDATE ozf_resale_lines_all
2360: SET end_cust_party_id = p_to_fk_id,
2361: last_update_date = hz_utility_pub.last_update_date,
2362: last_updated_by = hz_utility_pub.user_id,
2363: last_update_login = hz_utility_pub.last_update_login,

Line 2427: UPDATE ozf_resale_lines_all

2423: IF p_from_fk_id <> p_to_fk_id THEN
2424: BEGIN
2425: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2426:
2427: UPDATE ozf_resale_lines_all
2428: SET end_cust_contact_party_id = p_to_fk_id,
2429: last_update_date = hz_utility_pub.last_update_date,
2430: last_updated_by = hz_utility_pub.user_id,
2431: last_update_login = hz_utility_pub.last_update_login,