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_011 dependencies on IGS_PE_PERS_DISABLTY

Line 1183: l_disability_id igs_pe_pers_disablty.igs_pe_pers_disablty_id%TYPE;

1179:
1180: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
1181:
1182: -- Variable to hold the Disability ID of the Parent Person Disability Record
1183: l_disability_id igs_pe_pers_disablty.igs_pe_pers_disablty_id%TYPE;
1184: l_processed_records NUMBER(5) := 0;
1185: -- Variables for logging
1186: l_prog_label VARCHAR2(4000);
1187: l_label VARCHAR2(4000);

Line 1242: FROM igs_pe_pers_disablty pd

1238:
1239: --Cursor to check whether the Record in Interface Table already exists in OSS table for Disability
1240: CURSOR dup_chk_disability_cur(cp_disability_rec disability_cur%ROWTYPE) IS
1241: SELECT rowid, pd.*
1242: FROM igs_pe_pers_disablty pd
1243: WHERE pd.disability_type = cp_disability_rec.disability_type AND
1244: pd.person_id = cp_disability_rec.person_id AND
1245: NVL(TRUNC(pd.start_date),l_default_date) = NVL(TRUNC(cp_disability_rec.start_date),l_default_date);
1246:

Line 1422: p_desc_flex_name =>'IGS_PE_PERS_DISABLTY_FLEX' ) THEN

1418: p_attribute17 =>p_disability_rec.attribute17 ,
1419: p_attribute18 =>p_disability_rec.attribute18 ,
1420: p_attribute19 =>p_disability_rec.attribute19 ,
1421: p_attribute20 =>p_disability_rec.attribute20 ,
1422: p_desc_flex_name =>'IGS_PE_PERS_DISABLTY_FLEX' ) THEN
1423:
1424: l_error_code := 'E143' ;
1425: RAISE NO_DATA_FOUND;
1426: END IF;

Line 1670: igs_pe_pers_disablty_pkg.insert_row (

1666:
1667: validate_disability(p_disability_rec, l_success, p_error_code);
1668: IF l_success = 'Y' THEN -- Successful Validation
1669:
1670: igs_pe_pers_disablty_pkg.insert_row (
1671: x_rowid => l_rowid ,
1672: X_IGS_PE_PERS_DISABLTY_ID => l_disability_id,
1673: x_person_id => p_disability_rec.person_id,
1674: x_disability_type => p_disability_rec.disability_type,

Line 1672: X_IGS_PE_PERS_DISABLTY_ID => l_disability_id,

1668: IF l_success = 'Y' THEN -- Successful Validation
1669:
1670: igs_pe_pers_disablty_pkg.insert_row (
1671: x_rowid => l_rowid ,
1672: X_IGS_PE_PERS_DISABLTY_ID => l_disability_id,
1673: x_person_id => p_disability_rec.person_id,
1674: x_disability_type => p_disability_rec.disability_type,
1675: x_contact_ind => NULL,
1676: x_special_allow_cd => p_disability_rec.special_allow_cd,

Line 1794: igs_pe_pers_disablty_pkg.update_row(

1790: l_message_name VARCHAR2(30);
1791: l_app VARCHAR2(50);
1792: l_error_code VARCHAR2(30);
1793: BEGIN
1794: igs_pe_pers_disablty_pkg.update_row(
1795: x_rowid => p_dup_chk_disability_rec.rowid,
1796: x_igs_pe_pers_disablty_id => p_dup_chk_disability_rec.igs_pe_pers_disablty_id,
1797: x_person_id => p_dup_chk_disability_rec.person_id,
1798: x_disability_type => p_dup_chk_disability_rec.disability_type,

Line 1796: x_igs_pe_pers_disablty_id => p_dup_chk_disability_rec.igs_pe_pers_disablty_id,

1792: l_error_code VARCHAR2(30);
1793: BEGIN
1794: igs_pe_pers_disablty_pkg.update_row(
1795: x_rowid => p_dup_chk_disability_rec.rowid,
1796: x_igs_pe_pers_disablty_id => p_dup_chk_disability_rec.igs_pe_pers_disablty_id,
1797: x_person_id => p_dup_chk_disability_rec.person_id,
1798: x_disability_type => p_dup_chk_disability_rec.disability_type,
1799: x_contact_ind => p_dup_chk_disability_rec.contact_ind,
1800: x_special_allow_cd => NVL( p_disability_rec.special_allow_cd, p_dup_chk_disability_rec.special_allow_cd),

Line 2739: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id

2735: --skpandey, Bug#3702774, Changed select statement for optimization
2736: UPDATE igs_ad_disablty_int_all mi
2737: SET status = cst_stat_val_1,
2738: match_ind = cst_mi_val_19,
2739: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2741: WHERE ii.interface_id = mi.interface_id AND
2742: pe.disability_type = UPPER(mi.disability_type) AND
2743: ROWNUM = 1 AND

Line 2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2736: UPDATE igs_ad_disablty_int_all mi
2737: SET status = cst_stat_val_1,
2738: match_ind = cst_mi_val_19,
2739: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2741: WHERE ii.interface_id = mi.interface_id AND
2742: pe.disability_type = UPPER(mi.disability_type) AND
2743: ROWNUM = 1 AND
2744: ii.person_id = pe.person_id AND

Line 2749: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2745: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL)))
2746: WHERE mi.interface_run_id = l_interface_run_id
2747: AND mi.status = cst_stat_val_2
2748: AND EXISTS ( SELECT '1'
2749: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2750: WHERE pe.disability_type = UPPER(mi.disability_type) AND
2751: ii.interface_id = mi.interface_id AND
2752: ii.person_id = pe.person_id AND
2753: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL))

Line 2783: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id

2779: --skpandey, Bug#3702774, Changed select statement for optimization
2780: UPDATE igs_ad_disablty_int_all mi
2781: SET status = cst_stat_val_1,
2782: match_ind = cst_mi_val_23,
2783: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2785: WHERE ii.person_id = pe.person_id
2786: AND ii.interface_id = mi.interface_id
2787: AND pe.disability_type = UPPER(mi.disability_type)

Line 2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

2780: UPDATE igs_ad_disablty_int_all mi
2781: SET status = cst_stat_val_1,
2782: match_ind = cst_mi_val_23,
2783: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii
2785: WHERE ii.person_id = pe.person_id
2786: AND ii.interface_id = mi.interface_id
2787: AND pe.disability_type = UPPER(mi.disability_type)
2788: AND ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL)))

Line 2793: FROM igs_pe_pers_disablty pe, igs_AD_interface_all ii

2789: WHERE mi.interface_run_id = l_interface_run_id
2790: AND mi.match_ind IS NULL
2791: AND mi.status = cst_stat_val_2
2792: AND EXISTS ( SELECT 1
2793: FROM igs_pe_pers_disablty pe, igs_AD_interface_all ii
2794: WHERE ii.person_id = pe.person_id
2795: AND ii.interface_id = mi.interface_id
2796: AND UPPER(mi.disability_type) = pe.disability_type
2797: AND NVL(mi.special_allow_cd, -99) = NVL(pe.special_allow_cd, -99) AND

Line 2826: FROM igs_pe_pers_disablty pe, igs_Ad_interface_all ii

2822: WHERE mi.interface_run_id = l_interface_run_id
2823: AND mi.match_ind IS NULL
2824: AND mi.status = cst_stat_val_2
2825: AND EXISTS (SELECT '1'
2826: FROM igs_pe_pers_disablty pe, igs_Ad_interface_all ii
2827: WHERE pe.disability_type = UPPER(mi.disability_type) AND
2828: ii.person_id = pe.person_id AND
2829: ii.interface_id = mi.interface_id AND
2830: ((TRUNC(mi.start_date) = pe.start_date) OR (mi.start_date IS NULL AND pe.start_date IS NULL))

Line 2850: dup_chk_disability_rec.igs_pe_pers_disablty_id := NULL;

2846: l_disability_id := NULL;
2847:
2848: -- For each record picked up do the following :
2849: -- Check to see if the record already exists.
2850: dup_chk_disability_rec.igs_pe_pers_disablty_id := NULL;
2851:
2852: OPEN dup_chk_disability_cur(disability_rec);
2853: FETCH dup_chk_disability_cur INTO dup_chk_disability_rec;
2854: CLOSE dup_chk_disability_cur;

Line 2856: IF dup_chk_disability_rec.igs_pe_pers_disablty_id IS NOT NULL THEN

2852: OPEN dup_chk_disability_cur(disability_rec);
2853: FETCH dup_chk_disability_cur INTO dup_chk_disability_rec;
2854: CLOSE dup_chk_disability_cur;
2855: --If its a duplicate record find the source category rule for that Source Category.
2856: IF dup_chk_disability_rec.igs_pe_pers_disablty_id IS NOT NULL THEN
2857: dup_chk_disability_rec.start_date := TRUNC(dup_chk_disability_rec.start_date);
2858: dup_chk_disability_rec.end_date := TRUNC(dup_chk_disability_rec.end_date);
2859:
2860: -- Assign the value to the variable l_disability_id which will be passed as a parameter to the processing

Line 2862: l_disability_id := dup_chk_disability_rec.igs_pe_pers_disablty_id ;

2858: dup_chk_disability_rec.end_date := TRUNC(dup_chk_disability_rec.end_date);
2859:
2860: -- Assign the value to the variable l_disability_id which will be passed as a parameter to the processing
2861: -- of the Child Records i.e. for the processing of Special Need Service and Contact
2862: l_disability_id := dup_chk_disability_rec.igs_pe_pers_disablty_id ;
2863: IF l_rule = 'I' THEN
2864: validate_disability(disability_rec, l_success, l_error_code);
2865: IF l_success = 'Y' THEN -- Successful Validation
2866: update_disability(disability_rec,dup_chk_disability_rec);