DBA Data[Home] [Help]

APPS.OKS_QP_INT_PVT dependencies on HZ_UTILITY_PUB

Line 1445: last_update_date = hz_utility_pub.last_update_date,

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,

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

Line 1447: last_update_login = hz_utility_pub.last_update_login,

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

Line 1448: request_id = hz_utility_pub.request_id,

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

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

Line 1450: program_id = hz_utility_pub.program_id,

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;

Line 1623: hz_utility_pub.created_by,

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

Line 1624: hz_utility_pub.creation_date,

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

Line 1625: hz_utility_pub.last_update_login,

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;

Line 1626: hz_utility_pub.last_update_date,

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:

Line 1627: hz_utility_pub.last_updated_by

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