DBA Data[Home] [Help]

APPS.OKS_QP_INT_PVT dependencies on HZ_UTILITY_PUB

Line 1423: last_update_date = hz_utility_pub.last_update_date,

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,

Line 1424: last_updated_by = hz_utility_pub.user_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,

Line 1425: last_update_login = hz_utility_pub.last_update_login,

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

Line 1426: request_id = hz_utility_pub.request_id,

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);

Line 1427: program_application_id = hz_utility_pub.program_application_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:

Line 1428: program_id = hz_utility_pub.program_id,

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;

Line 1601: hz_utility_pub.created_by,

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

Line 1602: hz_utility_pub.creation_date,

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

Line 1603: hz_utility_pub.last_update_login,

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;

Line 1604: hz_utility_pub.last_update_date,

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:

Line 1605: hz_utility_pub.last_updated_by

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