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_SN_CONTACT

Line 1260: CURSOR dup_chk_sn_contact_cur(cp_disability_id igs_pe_sn_contact.disability_id%TYPE,

1256: sn.special_service_cd = cp_special_service_cd AND
1257: NVL(TRUNC(sn.start_dt),l_default_date) = NVL(TRUNC(cp_start_dt),l_default_date);
1258:
1259: --Cursor to check whether the Record in Interface Table already exists in OSS table for Special Need Contact
1260: CURSOR dup_chk_sn_contact_cur(cp_disability_id igs_pe_sn_contact.disability_id%TYPE,
1261: cp_contact_name igs_pe_sn_contact.contact_name%TYPE,
1262: cp_contact_date igs_pe_sn_contact.contact_date%TYPE) IS
1263: SELECT rowid, sn.*
1264: FROM igs_pe_sn_contact sn

Line 1261: cp_contact_name igs_pe_sn_contact.contact_name%TYPE,

1257: NVL(TRUNC(sn.start_dt),l_default_date) = NVL(TRUNC(cp_start_dt),l_default_date);
1258:
1259: --Cursor to check whether the Record in Interface Table already exists in OSS table for Special Need Contact
1260: CURSOR dup_chk_sn_contact_cur(cp_disability_id igs_pe_sn_contact.disability_id%TYPE,
1261: cp_contact_name igs_pe_sn_contact.contact_name%TYPE,
1262: cp_contact_date igs_pe_sn_contact.contact_date%TYPE) IS
1263: SELECT rowid, sn.*
1264: FROM igs_pe_sn_contact sn
1265: WHERE sn.disability_id = cp_disability_id AND

Line 1262: cp_contact_date igs_pe_sn_contact.contact_date%TYPE) IS

1258:
1259: --Cursor to check whether the Record in Interface Table already exists in OSS table for Special Need Contact
1260: CURSOR dup_chk_sn_contact_cur(cp_disability_id igs_pe_sn_contact.disability_id%TYPE,
1261: cp_contact_name igs_pe_sn_contact.contact_name%TYPE,
1262: cp_contact_date igs_pe_sn_contact.contact_date%TYPE) IS
1263: SELECT rowid, sn.*
1264: FROM igs_pe_sn_contact sn
1265: WHERE sn.disability_id = cp_disability_id AND
1266: NVL(sn.contact_name,'~') = NVL(cp_contact_name,'~') AND

Line 1264: FROM igs_pe_sn_contact sn

1260: CURSOR dup_chk_sn_contact_cur(cp_disability_id igs_pe_sn_contact.disability_id%TYPE,
1261: cp_contact_name igs_pe_sn_contact.contact_name%TYPE,
1262: cp_contact_date igs_pe_sn_contact.contact_date%TYPE) IS
1263: SELECT rowid, sn.*
1264: FROM igs_pe_sn_contact sn
1265: WHERE sn.disability_id = cp_disability_id AND
1266: NVL(sn.contact_name,'~') = NVL(cp_contact_name,'~') AND
1267: NVL(TRUNC(sn.contact_date),l_default_date) = NVL(TRUNC(cp_contact_date),l_default_date);
1268:

Line 2017: p_disability_id igs_pe_sn_contact.disability_id%TYPE,

2013:
2014:
2015: --Local Procedure to create a Special Need Contact Record
2016: PROCEDURE create_sn_contact(p_sn_contact_rec sn_contact_cur%ROWTYPE,
2017: p_disability_id igs_pe_sn_contact.disability_id%TYPE,
2018: p_person_id igs_ad_interface.person_id%TYPE,
2019: p_status OUT NOCOPY VARCHAR2)
2020: AS
2021: /*

Line 2036: l_sn_contact_id igs_pe_sn_contact.sn_contact_id%TYPE;

2032: */
2033: l_rowid VARCHAR2(25);
2034: l_success VARCHAR2(1);
2035: l_error_code igs_pe_sn_conct_int.error_code%TYPE;
2036: l_sn_contact_id igs_pe_sn_contact.sn_contact_id%TYPE;
2037:
2038: BEGIN
2039:
2040: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2060: igs_pe_sn_contact_pkg.insert_row (

2056: validate_sn_contact(p_sn_contact_rec, p_person_id, l_success, l_error_code);
2057:
2058: IF l_success = 'Y' THEN -- Successful Validation
2059:
2060: igs_pe_sn_contact_pkg.insert_row (
2061: x_rowid => l_rowid ,
2062: x_sn_contact_id => l_sn_contact_id,
2063: x_disability_id => p_disability_id,
2064: x_contact_name => p_sn_contact_rec.contact_name,

Line 2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'

2096:
2097: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_contact.exception'||l_error_code;
2098:
2099: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Contact '
2100: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.insert_row'
2101: ||' for INTERFACE SN CONTACT ID :'
2102: || p_sn_contact_rec.interface_sn_contact_id
2103: || 'Status : 3'
2104: || 'ErrorCode :' || l_error_code

Line 2400: p_disability_id IN igs_pe_sn_contact.disability_id%TYPE,

2396:
2397:
2398:
2399: PROCEDURE process_sn_contact(p_interface_disability_id IN igs_ad_disablty_int.interface_disablty_id%TYPE,
2400: p_disability_id IN igs_pe_sn_contact.disability_id%TYPE,
2401: p_person_id IN igs_ad_interface.person_id%TYPE,
2402: p_status OUT NOCOPY VARCHAR2)
2403: AS
2404: --------------------------------------------------------------------------

Line 2456: FROM igs_pe_sn_contact pe

2452: WHERE mi.interface_run_id = l_interface_run_id
2453: AND mi.status = cst_stat_val_2
2454: AND mi.interface_disablty_id = p_interface_disability_id
2455: AND EXISTS ( SELECT '1'
2456: FROM igs_pe_sn_contact pe
2457: WHERE pe.disability_id = p_disability_id AND
2458: NVL(UPPER(mi.contact_name),'~') = NVL(UPPER(pe.contact_name),'~') AND
2459: NVL(TRUNC(mi.contact_date),l_default_date) = NVL(TRUNC(pe.contact_date),l_default_date)
2460: );

Line 2493: FROM igs_pe_sn_contact pe

2489: AND mi.match_ind IS NULL
2490: AND mi.status = cst_stat_val_2
2491: AND mi.interface_disablty_id = p_interface_disability_id
2492: AND EXISTS ( SELECT '1'
2493: FROM igs_pe_sn_contact pe
2494: WHERE pe.disability_id = p_disability_id AND
2495: NVL(UPPER(mi.contact_name),'*') = NVL(UPPER(pe.contact_name),'*') AND
2496: NVL(TRUNC(mi.contact_date), l_default_date) = NVL(TRUNC(pe.contact_date),l_default_date) AND
2497: NVL(UPPER(mi.comments),'*') = NVL(UPPER(pe.comments), '*'));

Line 2506: FROM igs_pe_sn_contact pe

2502: UPDATE igs_pe_sn_conct_int mi
2503: SET status = cst_stat_val_3,
2504: match_ind = cst_mi_val_20,
2505: dup_sn_contact_id = (SELECT sn_contact_id
2506: FROM igs_pe_sn_contact pe
2507: WHERE pe.disability_id = p_disability_id AND
2508: NVL(UPPER(mi.contact_name),'*') = NVL(UPPER(pe.contact_name),'*') AND
2509: NVL(TRUNC(mi.contact_date), l_default_date) = NVL(TRUNC(pe.contact_date),l_default_date)
2510: )

Line 2516: FROM igs_pe_sn_contact pe

2512: AND mi.match_ind IS NULL
2513: AND mi.status = cst_stat_val_2
2514: AND mi.interface_disablty_id = p_interface_disability_id
2515: AND EXISTS (SELECT '1'
2516: FROM igs_pe_sn_contact pe
2517: WHERE pe.disability_id = p_disability_id AND
2518: NVL(UPPER(mi.contact_name),'*') = NVL(UPPER(pe.contact_name),'*') AND
2519: NVL(TRUNC(mi.contact_date), l_default_date) = NVL(TRUNC(pe.contact_date),l_default_date));
2520: END IF;

Line 2538: igs_pe_sn_contact_pkg.update_row (

2534: BEGIN
2535:
2536: validate_sn_contact(sn_contact_rec, p_person_id, l_success, l_error_code);
2537: IF l_success = 'Y' THEN -- Successful Validation
2538: igs_pe_sn_contact_pkg.update_row (
2539: x_rowid => dup_chk_sn_contact_rec.rowid ,
2540: x_sn_contact_id => dup_chk_sn_contact_rec.sn_contact_id,
2541: x_disability_id => dup_chk_sn_contact_rec.disability_id,
2542: x_contact_name => NVL(sn_contact_rec.contact_name,dup_chk_sn_contact_rec.contact_name),

Line 2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'

2572:
2573: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2574:
2575: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2576: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2577: ||' for INTERFACE SN CONTACT ID :'
2578: || sn_contact_rec.interface_sn_contact_id
2579: || ' Status : 3'
2580: || ' ErrorCode :' || l_error_code

Line 2603: igs_pe_sn_contact_pkg.update_row (

2599: validate_sn_contact(sn_contact_rec, p_person_id, l_success, l_error_code);
2600:
2601: IF l_success = 'Y' THEN -- Successful Validation
2602:
2603: igs_pe_sn_contact_pkg.update_row (
2604: x_rowid => dup_chk_sn_contact_rec.rowid ,
2605: x_sn_contact_id => dup_chk_sn_contact_rec.sn_contact_id,
2606: x_disability_id => dup_chk_sn_contact_rec.disability_id,
2607: x_contact_name => NVL(sn_contact_rec.contact_name,dup_chk_sn_contact_rec.contact_name),

Line 2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'

2638:
2639: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_contact.exception'||l_error_code;
2640:
2641: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Contact '
2642: ||'Unhandled Exception in call to igs_pe_sn_contact_pkg.update_row'
2643: ||' for INTERFACE SN CONTACT ID :'
2644: || sn_contact_rec.interface_sn_contact_id
2645: || ' Status : 3'
2646: || ' ErrorCode :' || l_error_code