DBA Data[Home] [Help]

APPS.QA_TCA_PKG dependencies on HZ_UTILITY_PUB

Line 87: qr.last_update_login = hz_utility_pub.last_update_login,

83: UPDATE qa_results qr
84: SET qr.party_id = p_to_fk_id,
85: qr.last_update_date = sysdate,
86: qr.qa_last_update_date = sysdate,
87: qr.last_update_login = hz_utility_pub.last_update_login,
88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,

Line 88: qr.last_updated_by = hz_utility_pub.user_id,

84: SET qr.party_id = p_to_fk_id,
85: qr.last_update_date = sysdate,
86: qr.qa_last_update_date = sysdate,
87: qr.last_update_login = hz_utility_pub.last_update_login,
88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,
92: qr.program_id = hz_utility_pub.program_id,

Line 89: qr.qa_last_updated_by = hz_utility_pub.user_id,

85: qr.last_update_date = sysdate,
86: qr.qa_last_update_date = sysdate,
87: qr.last_update_login = hz_utility_pub.last_update_login,
88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,
92: qr.program_id = hz_utility_pub.program_id,
93: qr.program_update_date = sysdate

Line 90: qr.request_id = hz_utility_pub.request_id,

86: qr.qa_last_update_date = sysdate,
87: qr.last_update_login = hz_utility_pub.last_update_login,
88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,
92: qr.program_id = hz_utility_pub.program_id,
93: qr.program_update_date = sysdate
94: WHERE qr.party_id = p_from_fk_id;

Line 91: qr.program_application_id = hz_utility_pub.program_application_id,

87: qr.last_update_login = hz_utility_pub.last_update_login,
88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,
92: qr.program_id = hz_utility_pub.program_id,
93: qr.program_update_date = sysdate
94: WHERE qr.party_id = p_from_fk_id;
95: END IF;

Line 92: qr.program_id = hz_utility_pub.program_id,

88: qr.last_updated_by = hz_utility_pub.user_id,
89: qr.qa_last_updated_by = hz_utility_pub.user_id,
90: qr.request_id = hz_utility_pub.request_id,
91: qr.program_application_id = hz_utility_pub.program_application_id,
92: qr.program_id = hz_utility_pub.program_id,
93: qr.program_update_date = sysdate
94: WHERE qr.party_id = p_from_fk_id;
95: END IF;
96: