DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_EDUCATION

Line 8823: FROM hz_education hc

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

Line 8864: FROM HZ_EDUCATION

8860: l_application_id,
8861: l_school_party_id,
8862: l_school_attended_name,
8863: l_type_of_school
8864: FROM HZ_EDUCATION
8865: WHERE ROWID = p_rowid;
8866: END IF;
8867:
8868:

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

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

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

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