APPS.IGS_PE_LANGUAGES_PKG dependencies on HZ_PERSON_LANGUAGE

Line 39: lv_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;

35: lv_per_language_rec_type HZ_PERSON_INFO_V2PUB.person_language_rec_type;
36:
37: lv_last_update_date DATE := p_last_update_date;
38:
39: lv_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;
40:
41: tmp_var VARCHAR2(2000);
42: tmp_var1 VARCHAR2(2000);
43: l_action VARCHAR2(30);

Line 45: CURSOR dup_lang_cur (cp_language_name hz_person_language.language_name%TYPE,

41: tmp_var VARCHAR2(2000);
42: tmp_var1 VARCHAR2(2000);
43: l_action VARCHAR2(30);
44:
45: CURSOR dup_lang_cur (cp_language_name hz_person_language.language_name%TYPE,
46: cp_status hz_person_language.status%TYPE,
47: cp_party_id hz_person_language.party_id%TYPE) IS
48: SELECT language_use_reference_id, object_version_number
49: FROM hz_person_language

Line 46: cp_status hz_person_language.status%TYPE,

42: tmp_var1 VARCHAR2(2000);
43: l_action VARCHAR2(30);
44:
45: CURSOR dup_lang_cur (cp_language_name hz_person_language.language_name%TYPE,
46: cp_status hz_person_language.status%TYPE,
47: cp_party_id hz_person_language.party_id%TYPE) IS
48: SELECT language_use_reference_id, object_version_number
49: FROM hz_person_language
50: WHERE language_name = cp_language_name AND

Line 47: cp_party_id hz_person_language.party_id%TYPE) IS

43: l_action VARCHAR2(30);
44:
45: CURSOR dup_lang_cur (cp_language_name hz_person_language.language_name%TYPE,
46: cp_status hz_person_language.status%TYPE,
47: cp_party_id hz_person_language.party_id%TYPE) IS
48: SELECT language_use_reference_id, object_version_number
49: FROM hz_person_language
50: WHERE language_name = cp_language_name AND
51: status = cp_status AND

Line 49: FROM hz_person_language

45: CURSOR dup_lang_cur (cp_language_name hz_person_language.language_name%TYPE,
46: cp_status hz_person_language.status%TYPE,
47: cp_party_id hz_person_language.party_id%TYPE) IS
48: SELECT language_use_reference_id, object_version_number
49: FROM hz_person_language
50: WHERE language_name = cp_language_name AND
51: status = cp_status AND
52: party_id = cp_party_id;
53: