APPS.OZF_PARTY_MERGE_PVT dependencies on OZF_RESALE_LINES_INT_ALL

Line 1111: UPDATE ozf_resale_lines_int_all

1107: IF p_from_fk_id <> p_to_fk_id THEN
1108: BEGIN
1109: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1110:
1111: UPDATE ozf_resale_lines_int_all
1112: SET ship_from_contact_party_id = p_to_fk_id,
1113: last_update_date = hz_utility_pub.last_update_date,
1114: last_updated_by = hz_utility_pub.user_id,
1115: last_update_login = hz_utility_pub.last_update_login,

Line 1180: UPDATE ozf_resale_lines_int_all

1176: IF p_from_fk_id <> p_to_fk_id THEN
1177: BEGIN
1178: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1179:
1180: UPDATE ozf_resale_lines_int_all
1181: SET sold_from_contact_party_id = p_to_fk_id,
1182: last_update_date = hz_utility_pub.last_update_date,
1183: last_updated_by = hz_utility_pub.user_id,
1184: last_update_login = hz_utility_pub.last_update_login,

Line 1250: UPDATE ozf_resale_lines_int_all

1246: IF p_from_fk_id <> p_to_fk_id THEN
1247: BEGIN
1248: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1249:
1250: UPDATE ozf_resale_lines_int_all
1251: SET bill_to_party_id = p_to_fk_id,
1252: last_update_date = hz_utility_pub.last_update_date,
1253: last_updated_by = hz_utility_pub.user_id,
1254: last_update_login = hz_utility_pub.last_update_login,

Line 1320: UPDATE ozf_resale_lines_int_all

1316: IF p_from_fk_id <> p_to_fk_id THEN
1317: BEGIN
1318: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1319:
1320: UPDATE ozf_resale_lines_int_all
1321: SET bill_to_contact_party_id = p_to_fk_id,
1322: last_update_date = hz_utility_pub.last_update_date,
1323: last_updated_by = hz_utility_pub.user_id,
1324: last_update_login = hz_utility_pub.last_update_login,

Line 1389: UPDATE ozf_resale_lines_int_all

1385: IF p_from_fk_id <> p_to_fk_id THEN
1386: BEGIN
1387: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1388:
1389: UPDATE ozf_resale_lines_int_all
1390: SET ship_to_party_id = p_to_fk_id,
1391: last_update_date = hz_utility_pub.last_update_date,
1392: last_updated_by = hz_utility_pub.user_id,
1393: last_update_login = hz_utility_pub.last_update_login,

Line 1459: UPDATE ozf_resale_lines_int_all

1455: IF p_from_fk_id <> p_to_fk_id THEN
1456: BEGIN
1457: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1458:
1459: UPDATE ozf_resale_lines_int_all
1460: SET ship_to_contact_party_id = p_to_fk_id,
1461: last_update_date = hz_utility_pub.last_update_date,
1462: last_updated_by = hz_utility_pub.user_id,
1463: last_update_login = hz_utility_pub.last_update_login,

Line 1528: UPDATE ozf_resale_lines_int_all

1524: IF p_from_fk_id <> p_to_fk_id THEN
1525: BEGIN
1526: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1527:
1528: UPDATE ozf_resale_lines_int_all
1529: SET end_cust_party_id = p_to_fk_id,
1530: last_update_date = hz_utility_pub.last_update_date,
1531: last_updated_by = hz_utility_pub.user_id,
1532: last_update_login = hz_utility_pub.last_update_login,

Line 1597: UPDATE ozf_resale_lines_int_all

1593: IF p_from_fk_id <> p_to_fk_id THEN
1594: BEGIN
1595: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
1596:
1597: UPDATE ozf_resale_lines_int_all
1598: SET end_cust_contact_party_id = p_to_fk_id,
1599: last_update_date = hz_utility_pub.last_update_date,
1600: last_updated_by = hz_utility_pub.user_id,
1601: last_update_login = hz_utility_pub.last_update_login,