DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_EDUCATION

Line 8820: FROM hz_education hc

8816: temp_last_date_attended DATE;
8817:
8818: CURSOR education_cur (p_education_id IN NUMBER) IS
8819: SELECT 'Y'
8820: FROM hz_education hc
8821: WHERE hc.education_id = p_education_id;
8822:
8823: BEGIN
8824:

Line 8861: FROM HZ_EDUCATION

8857: l_application_id,
8858: l_school_party_id,
8859: l_school_attended_name,
8860: l_type_of_school
8861: FROM HZ_EDUCATION
8862: WHERE ROWID = p_rowid;
8863: END IF;
8864:
8865:

Line 9013: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');

9009:
9010: EXCEPTION
9011: WHEN NO_DATA_FOUND THEN
9012: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
9013: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9014: fnd_message.set_token('PARTY_ID_COL', 'party_id');
9015: fnd_msg_pub.add;
9016: x_return_status := fnd_api.g_ret_sts_error;
9017: END;

Line 9188: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');

9184:
9185: EXCEPTION
9186: WHEN NO_DATA_FOUND THEN
9187: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_ORG');
9188: fnd_message.set_token('TABLE_NAME', 'HZ_EDUCATION');
9189: fnd_message.set_token('PARTY_ID_COL', 'school_party_id');
9190: fnd_msg_pub.add;
9191: x_return_status := fnd_api.g_ret_sts_error;
9192: END;