1441: x_return_status := okc_api.g_ret_sts_success;
1442:
1443: UPDATE oks_qualifiers
1444: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1445: last_update_date = hz_utility_pub.last_update_date,
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1442:
1443: UPDATE oks_qualifiers
1444: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1445: last_update_date = hz_utility_pub.last_update_date,
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1450: program_id = hz_utility_pub.program_id,
1443: UPDATE oks_qualifiers
1444: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1445: last_update_date = hz_utility_pub.last_update_date,
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1450: program_id = hz_utility_pub.program_id,
1451: program_update_date = SYSDATE
1444: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1445: last_update_date = hz_utility_pub.last_update_date,
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1450: program_id = hz_utility_pub.program_id,
1451: program_update_date = SYSDATE
1452: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1445: last_update_date = hz_utility_pub.last_update_date,
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1450: program_id = hz_utility_pub.program_id,
1451: program_update_date = SYSDATE
1452: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1453:
1446: last_updated_by = hz_utility_pub.user_id,
1447: last_update_login = hz_utility_pub.last_update_login,
1448: request_id = hz_utility_pub.request_id,
1449: program_application_id = hz_utility_pub.program_application_id,
1450: program_id = hz_utility_pub.program_id,
1451: program_update_date = SYSDATE
1452: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1453:
1454: l_count := SQL%ROWCOUNT;
1619: vchar_col1_orig_list (i),
1620: vchar_col1_new_list (i),
1621: 'U',
1622: req_id,
1623: hz_utility_pub.created_by,
1624: hz_utility_pub.creation_date,
1625: hz_utility_pub.last_update_login,
1626: hz_utility_pub.last_update_date,
1627: hz_utility_pub.last_updated_by
1620: vchar_col1_new_list (i),
1621: 'U',
1622: req_id,
1623: hz_utility_pub.created_by,
1624: hz_utility_pub.creation_date,
1625: hz_utility_pub.last_update_login,
1626: hz_utility_pub.last_update_date,
1627: hz_utility_pub.last_updated_by
1628: );
1621: 'U',
1622: req_id,
1623: hz_utility_pub.created_by,
1624: hz_utility_pub.creation_date,
1625: hz_utility_pub.last_update_login,
1626: hz_utility_pub.last_update_date,
1627: hz_utility_pub.last_updated_by
1628: );
1629: END IF;
1622: req_id,
1623: hz_utility_pub.created_by,
1624: hz_utility_pub.creation_date,
1625: hz_utility_pub.last_update_login,
1626: hz_utility_pub.last_update_date,
1627: hz_utility_pub.last_updated_by
1628: );
1629: END IF;
1630:
1623: hz_utility_pub.created_by,
1624: hz_utility_pub.creation_date,
1625: hz_utility_pub.last_update_login,
1626: hz_utility_pub.last_update_date,
1627: hz_utility_pub.last_updated_by
1628: );
1629: END IF;
1630:
1631: FORALL i IN 1 .. merge_header_id_list.COUNT