eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_002 dependencies on STANDARD

Line 1084: PROCEDURE admpl_match_standard_6 (

1080: App_Exception.Raise_Exception;
1081: END admpl_match_exact_id;
1082: ---------------
1083: ---------------
1084: PROCEDURE admpl_match_standard_6 (
1085: p_convert_family_name IN IGS_PE_PERSON.surname%TYPE,
1086: p_convert_birth_dt IN IGS_PE_PERSON.birth_dt%TYPE,
1087: p_convert_first_name IN VARCHAR2,
1088: p_convert_second_name IN VARCHAR2,

Line 1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');

1132: p_number_of_matches);
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END admpl_match_standard_6;
1140: PROCEDURE admpl_match_standard (

Line 1139: END admpl_match_standard_6;

1135: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END admpl_match_standard_6;
1140: PROCEDURE admpl_match_standard (
1141: p_convert_id IN IGS_PE_PERSON.person_id%TYPE,
1142: p_convert_family_name IN IGS_PE_PERSON.surname%TYPE,
1143: p_convert_birth_dt IN IGS_PE_PERSON.birth_dt%TYPE,

Line 1140: PROCEDURE admpl_match_standard (

1136: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard_6');
1137: IGS_GE_MSG_STACK.ADD;
1138: App_Exception.Raise_Exception;
1139: END admpl_match_standard_6;
1140: PROCEDURE admpl_match_standard (
1141: p_convert_id IN IGS_PE_PERSON.person_id%TYPE,
1142: p_convert_family_name IN IGS_PE_PERSON.surname%TYPE,
1143: p_convert_birth_dt IN IGS_PE_PERSON.birth_dt%TYPE,
1144: p_convert_first_name IN VARCHAR2,

Line 1149: BEGIN -- admpl_match_standard (4)

1145: p_convert_second_name IN VARCHAR2,
1146: p_number_of_matches IN OUT NOCOPY NUMBER)
1147: IS
1148: v_number_of_matches NUMBER(4);
1149: BEGIN -- admpl_match_standard (4)
1150: -- Standard matching algorithm
1151: -- Step 1 Attempt a match using criterion 1. (11)
1152: admpl_match_criteria1(
1153: p_convert_id,

Line 1150: -- Standard matching algorithm

1146: p_number_of_matches IN OUT NOCOPY NUMBER)
1147: IS
1148: v_number_of_matches NUMBER(4);
1149: BEGIN -- admpl_match_standard (4)
1150: -- Standard matching algorithm
1151: -- Step 1 Attempt a match using criterion 1. (11)
1152: admpl_match_criteria1(
1153: p_convert_id,
1154: p_convert_family_name,

Line 1168: admpl_match_standard_6(

1164: p_convert_second_name,
1165: p_number_of_matches);
1166: IF (p_number_of_matches > 0) THEN
1167: -- Go to Step 6
1168: admpl_match_standard_6(
1169: p_convert_family_name,
1170: p_convert_birth_dt,
1171: p_convert_first_name,
1172: p_convert_second_name,

Line 1191: admpl_match_standard_6(

1187: p_convert_second_name,
1188: p_number_of_matches);
1189: IF (p_number_of_matches > 0) THEN
1190: -- Go to Step 6
1191: admpl_match_standard_6(
1192: p_convert_family_name,
1193: p_convert_birth_dt,
1194: p_convert_first_name,
1195: p_convert_second_name,

Line 1206: admpl_match_standard_6(

1202: p_convert_birth_dt,
1203: p_number_of_matches);
1204: IF (p_number_of_matches > 0) THEN
1205: -- Go to Step 6
1206: admpl_match_standard_6(
1207: p_convert_family_name,
1208: p_convert_birth_dt,
1209: p_convert_first_name,
1210: p_convert_second_name,

Line 1218: admpl_match_standard_6(

1214: -- Step 5 Attempt a match using criterion 5. (16)
1215: admpl_match_criteria5(
1216: p_convert_id,
1217: p_number_of_matches);
1218: admpl_match_standard_6(
1219: p_convert_family_name,
1220: p_convert_birth_dt,
1221: p_convert_first_name,
1222: p_convert_second_name,

Line 1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');

1223: p_number_of_matches);
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');
1228: IGS_GE_MSG_STACK.ADD;
1229: App_Exception.Raise_Exception;
1230: END admpl_match_standard;
1231: ---------------

Line 1230: END admpl_match_standard;

1226: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1227: Fnd_Message.Set_Token('NAME','IGS_AD_GEN_002.admpl_match_standard');
1228: IGS_GE_MSG_STACK.ADD;
1229: App_Exception.Raise_Exception;
1230: END admpl_match_standard;
1231: ---------------
1232: ---------------
1233: PROCEDURE admpl_write_course_header (
1234: p_course_cd IN IGS_PS_VER.course_cd%TYPE,

Line 1797: cst_standard CONSTANT VARCHAR2(10) := 'STANDARD';

1793: p_previous_name_records_cnt IN NUMBER,
1794: p_number_of_matches IN OUT NOCOPY NUMBER)
1795: RETURN BOOLEAN
1796: IS
1797: cst_standard CONSTANT VARCHAR2(10) := 'STANDARD';
1798: cst_exact_id CONSTANT VARCHAR2(10) := 'EXACT_ID';
1799: cst_any_id CONSTANT VARCHAR2(10) := 'ANY_ID';
1800: cst_exact_name CONSTANT VARCHAR2(10) := 'EXACT_NAME';
1801: cst_loose_name CONSTANT VARCHAR2(10) := 'LOOSE_NAME';

Line 1857: IF (v_matching_level = cst_standard) THEN

1853: -- Clear PLSQL table of matched ID's.
1854: t_matched_ids := t_matched_ids_clear;
1855: p_number_of_matches := 0;
1856: v_matching_level := admpl_strip_spaces(r_header_rec.matching_level);
1857: IF (v_matching_level = cst_standard) THEN
1858: -- Call match_standard
1859: admpl_match_standard(
1860: v_convert_id,
1861: v_convert_family_name,

Line 1858: -- Call match_standard

1854: t_matched_ids := t_matched_ids_clear;
1855: p_number_of_matches := 0;
1856: v_matching_level := admpl_strip_spaces(r_header_rec.matching_level);
1857: IF (v_matching_level = cst_standard) THEN
1858: -- Call match_standard
1859: admpl_match_standard(
1860: v_convert_id,
1861: v_convert_family_name,
1862: v_convert_birth_dt,

Line 1859: admpl_match_standard(

1855: p_number_of_matches := 0;
1856: v_matching_level := admpl_strip_spaces(r_header_rec.matching_level);
1857: IF (v_matching_level = cst_standard) THEN
1858: -- Call match_standard
1859: admpl_match_standard(
1860: v_convert_id,
1861: v_convert_family_name,
1862: v_convert_birth_dt,
1863: v_convert_first_name,