1419: x_return_status := okc_api.g_ret_sts_success;
1420:
1421: UPDATE oks_qualifiers
1422: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1423: last_update_date = hz_utility_pub.last_update_date,
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1420:
1421: UPDATE oks_qualifiers
1422: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1423: last_update_date = hz_utility_pub.last_update_date,
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1428: program_id = hz_utility_pub.program_id,
1421: UPDATE oks_qualifiers
1422: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1423: last_update_date = hz_utility_pub.last_update_date,
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1428: program_id = hz_utility_pub.program_id,
1429: program_update_date = SYSDATE
1422: SET qualifier_attr_value = TO_CHAR (p_to_fk_id),
1423: last_update_date = hz_utility_pub.last_update_date,
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1428: program_id = hz_utility_pub.program_id,
1429: program_update_date = SYSDATE
1430: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1423: last_update_date = hz_utility_pub.last_update_date,
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1428: program_id = hz_utility_pub.program_id,
1429: program_update_date = SYSDATE
1430: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1431:
1424: last_updated_by = hz_utility_pub.user_id,
1425: last_update_login = hz_utility_pub.last_update_login,
1426: request_id = hz_utility_pub.request_id,
1427: program_application_id = hz_utility_pub.program_application_id,
1428: program_id = hz_utility_pub.program_id,
1429: program_update_date = SYSDATE
1430: WHERE qualifier_attr_value = TO_CHAR (p_from_fk_id);
1431:
1432: l_count := SQL%ROWCOUNT;
1597: vchar_col1_orig_list (i),
1598: vchar_col1_new_list (i),
1599: 'U',
1600: req_id,
1601: hz_utility_pub.created_by,
1602: hz_utility_pub.creation_date,
1603: hz_utility_pub.last_update_login,
1604: hz_utility_pub.last_update_date,
1605: hz_utility_pub.last_updated_by
1598: vchar_col1_new_list (i),
1599: 'U',
1600: req_id,
1601: hz_utility_pub.created_by,
1602: hz_utility_pub.creation_date,
1603: hz_utility_pub.last_update_login,
1604: hz_utility_pub.last_update_date,
1605: hz_utility_pub.last_updated_by
1606: );
1599: 'U',
1600: req_id,
1601: hz_utility_pub.created_by,
1602: hz_utility_pub.creation_date,
1603: hz_utility_pub.last_update_login,
1604: hz_utility_pub.last_update_date,
1605: hz_utility_pub.last_updated_by
1606: );
1607: END IF;
1600: req_id,
1601: hz_utility_pub.created_by,
1602: hz_utility_pub.creation_date,
1603: hz_utility_pub.last_update_login,
1604: hz_utility_pub.last_update_date,
1605: hz_utility_pub.last_updated_by
1606: );
1607: END IF;
1608:
1601: hz_utility_pub.created_by,
1602: hz_utility_pub.creation_date,
1603: hz_utility_pub.last_update_login,
1604: hz_utility_pub.last_update_date,
1605: hz_utility_pub.last_updated_by
1606: );
1607: END IF;
1608:
1609: FORALL i IN 1 .. merge_header_id_list.COUNT