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_IMP_002 dependencies on IGS_AD_IMP_023

Line 3209: l_attribute_action := Igs_Ad_Imp_023.find_attribute_rule(

3205:
3206: l_lvcAction := Igs_Ad_Imp_001.FIND_SOURCE_CAT_RULE(p_d_source_type_id,'PERSON');
3207: IF l_lvcAction = 'D' THEN
3208: -- Get the attribute level discrepancy rule.
3209: l_attribute_action := Igs_Ad_Imp_023.find_attribute_rule(
3210: p_source_type_id => p_d_source_type_id,
3211: p_category => 'PERSON');
3212: END IF;
3213:

Line 3370: person_rec.SURNAME := Igs_Ad_Imp_023.get_discrepancy_result(

3366: -- Few of the columns are marked for Import and nothing is marked for Review.
3367: -- Process the record by evaluating only 'Keep' and 'Import' Discrepancy Rules.
3368: -- Evaluate the Discrepancy Rules for each column and re-prepare the person_rec.
3369: --
3370: person_rec.SURNAME := Igs_Ad_Imp_023.get_discrepancy_result(
3371: p_attribute_name => 'SURNAME',
3372: p_ad_col_value => c_null_hdlg_per_rec.SURNAME,
3373: p_int_col_value => person_rec.SURNAME,
3374: p_source_type_id => p_d_source_type_id,

Line 3378: person_rec.MIDDLE_NAME := Igs_Ad_Imp_023.get_discrepancy_result(

3374: p_source_type_id => p_d_source_type_id,
3375: p_category => 'PERSON'
3376: );
3377:
3378: person_rec.MIDDLE_NAME := Igs_Ad_Imp_023.get_discrepancy_result(
3379: p_attribute_name => 'MIDDLE_NAME',
3380: p_ad_col_value => c_null_hdlg_per_rec.MIDDLE_NAME,
3381: p_int_col_value => person_rec.MIDDLE_NAME,
3382: p_source_type_id => p_d_source_type_id,

Line 3386: person_rec.GIVEN_NAMES := Igs_Ad_Imp_023.get_discrepancy_result(

3382: p_source_type_id => p_d_source_type_id,
3383: p_category => 'PERSON'
3384: );
3385:
3386: person_rec.GIVEN_NAMES := Igs_Ad_Imp_023.get_discrepancy_result(
3387: p_attribute_name => 'GIVEN_NAMES',
3388: p_ad_col_value => c_null_hdlg_per_rec.GIVEN_NAMES,
3389: p_int_col_value => person_rec.GIVEN_NAMES,
3390: p_source_type_id => p_d_source_type_id,

Line 3394: person_rec.PREFERRED_GIVEN_NAME := Igs_Ad_Imp_023.get_discrepancy_result(

3390: p_source_type_id => p_d_source_type_id,
3391: p_category => 'PERSON'
3392: );
3393:
3394: person_rec.PREFERRED_GIVEN_NAME := Igs_Ad_Imp_023.get_discrepancy_result(
3395: p_attribute_name => 'PREFERRED_GIVEN_NAME',
3396: p_ad_col_value => c_null_hdlg_per_rec.PREFERRED_GIVEN_NAME,
3397: p_int_col_value => person_rec.PREFERRED_GIVEN_NAME,
3398: p_source_type_id => p_d_source_type_id,

Line 3402: person_rec.SEX := Igs_Ad_Imp_023.get_discrepancy_result(

3398: p_source_type_id => p_d_source_type_id,
3399: p_category => 'PERSON'
3400: );
3401:
3402: person_rec.SEX := Igs_Ad_Imp_023.get_discrepancy_result(
3403: p_attribute_name => 'SEX',
3404: p_ad_col_value => c_null_hdlg_per_rec.SEX,
3405: p_int_col_value => person_rec.SEX,
3406: p_source_type_id => p_d_source_type_id,

Line 3410: person_rec.BIRTH_DT := Igs_Ad_Imp_023.get_discrepancy_result(

3406: p_source_type_id => p_d_source_type_id,
3407: p_category => 'PERSON'
3408: );
3409:
3410: person_rec.BIRTH_DT := Igs_Ad_Imp_023.get_discrepancy_result(
3411: p_attribute_name => 'BIRTH_DT',
3412: p_ad_col_value => c_null_hdlg_per_rec.BIRTH_DT,
3413: p_int_col_value => person_rec.BIRTH_DT,
3414: p_source_type_id => p_d_source_type_id,

Line 3418: person_rec.TITLE := Igs_Ad_Imp_023.get_discrepancy_result(

3414: p_source_type_id => p_d_source_type_id,
3415: p_category => 'PERSON'
3416: );
3417:
3418: person_rec.TITLE := Igs_Ad_Imp_023.get_discrepancy_result(
3419: p_attribute_name => 'TITLE',
3420: p_ad_col_value => c_null_hdlg_per_rec.TITLE,
3421: p_int_col_value => person_rec.TITLE,
3422: p_source_type_id => p_d_source_type_id,

Line 3426: person_rec.SUFFIX := Igs_Ad_Imp_023.get_discrepancy_result(

3422: p_source_type_id => p_d_source_type_id,
3423: p_category => 'PERSON'
3424: );
3425:
3426: person_rec.SUFFIX := Igs_Ad_Imp_023.get_discrepancy_result(
3427: p_attribute_name => 'SUFFIX',
3428: p_ad_col_value => c_null_hdlg_per_rec.SUFFIX,
3429: p_int_col_value => person_rec.SUFFIX,
3430: p_source_type_id => p_d_source_type_id,

Line 3434: person_rec.PRE_NAME_ADJUNCT := Igs_Ad_Imp_023.get_discrepancy_result(

3430: p_source_type_id => p_d_source_type_id,
3431: p_category => 'PERSON'
3432: );
3433:
3434: person_rec.PRE_NAME_ADJUNCT := Igs_Ad_Imp_023.get_discrepancy_result(
3435: p_attribute_name => 'PRE_NAME_ADJUNCT',
3436: p_ad_col_value => c_null_hdlg_per_rec.PRE_NAME_ADJUNCT,
3437: p_int_col_value => person_rec.PRE_NAME_ADJUNCT,
3438: p_source_type_id => p_d_source_type_id,

Line 3442: person_rec.LEVEL_OF_QUAL_ID := Igs_Ad_Imp_023.get_discrepancy_result(

3438: p_source_type_id => p_d_source_type_id,
3439: p_category => 'PERSON'
3440: );
3441:
3442: person_rec.LEVEL_OF_QUAL_ID := Igs_Ad_Imp_023.get_discrepancy_result(
3443: p_attribute_name => 'LEVEL_OF_QUAL_ID',
3444: p_ad_col_value => c_null_hdlg_per_rec.LEVEL_OF_QUAL_ID,
3445: p_int_col_value => person_rec.LEVEL_OF_QUAL_ID,
3446: p_source_type_id => p_d_source_type_id,

Line 3499: l_discrepancy_exists := Igs_Ad_Imp_023.find_detail_discrepancy_rule(p_source_type_id => p_d_source_type_id,

3495: --23 - Match to be reviewed, but there was no discrepancy
3496: -- and so retaining the existing values
3497: -- Then check to see if discrepancy exists at detail level.
3498: --gmaheswa: modified to Fix literals issue.
3499: l_discrepancy_exists := Igs_Ad_Imp_023.find_detail_discrepancy_rule(p_source_type_id => p_d_source_type_id,
3500: p_category => 'PERSON',
3501: p_int_pk_col_name => 'INTERFACE_ID',
3502: p_int_pk_col_val => person_rec.interface_id,
3503: p_ad_pk_col_name => 'PERSON_ID',