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_SERVICE

Line 1250: CURSOR dup_chk_sn_service_cur(cp_disability_id igs_pe_sn_service.disability_id%TYPE,

1246:
1247: --Cursor to check whether the Record in Interface Table already exists in OSS table for Special Need Service
1248: -- kumma, changed the duplicate check criteria to include the start_dt as a part of the unique key
1249:
1250: CURSOR dup_chk_sn_service_cur(cp_disability_id igs_pe_sn_service.disability_id%TYPE,
1251: cp_special_service_cd igs_pe_sn_service.special_service_cd%TYPE,
1252: cp_start_dt igs_pe_sn_service.start_dt%TYPE) IS
1253: SELECT rowid, sn.*
1254: FROM igs_pe_sn_service sn

Line 1251: cp_special_service_cd igs_pe_sn_service.special_service_cd%TYPE,

1247: --Cursor to check whether the Record in Interface Table already exists in OSS table for Special Need Service
1248: -- kumma, changed the duplicate check criteria to include the start_dt as a part of the unique key
1249:
1250: CURSOR dup_chk_sn_service_cur(cp_disability_id igs_pe_sn_service.disability_id%TYPE,
1251: cp_special_service_cd igs_pe_sn_service.special_service_cd%TYPE,
1252: cp_start_dt igs_pe_sn_service.start_dt%TYPE) IS
1253: SELECT rowid, sn.*
1254: FROM igs_pe_sn_service sn
1255: WHERE sn.disability_id = cp_disability_id AND

Line 1252: cp_start_dt igs_pe_sn_service.start_dt%TYPE) IS

1248: -- kumma, changed the duplicate check criteria to include the start_dt as a part of the unique key
1249:
1250: CURSOR dup_chk_sn_service_cur(cp_disability_id igs_pe_sn_service.disability_id%TYPE,
1251: cp_special_service_cd igs_pe_sn_service.special_service_cd%TYPE,
1252: cp_start_dt igs_pe_sn_service.start_dt%TYPE) IS
1253: SELECT rowid, sn.*
1254: FROM igs_pe_sn_service sn
1255: WHERE sn.disability_id = cp_disability_id AND
1256: sn.special_service_cd = cp_special_service_cd AND

Line 1254: FROM igs_pe_sn_service sn

1250: CURSOR dup_chk_sn_service_cur(cp_disability_id igs_pe_sn_service.disability_id%TYPE,
1251: cp_special_service_cd igs_pe_sn_service.special_service_cd%TYPE,
1252: cp_start_dt igs_pe_sn_service.start_dt%TYPE) IS
1253: SELECT rowid, sn.*
1254: FROM igs_pe_sn_service sn
1255: WHERE sn.disability_id = cp_disability_id AND
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:

Line 1911: p_disability_id igs_pe_sn_service.disability_id%TYPE,

1907: END update_disability;
1908:
1909: --Local Procedure to create a Special Need Service Record
1910: PROCEDURE create_sn_service(p_sn_service_rec sn_service_cur%ROWTYPE,
1911: p_disability_id igs_pe_sn_service.disability_id%TYPE,
1912: p_person_id igs_ad_interface.person_id%TYPE,
1913: p_status OUT NOCOPY VARCHAR2)
1914: AS
1915: /*

Line 1931: l_sn_service_id igs_pe_sn_service.sn_service_id%TYPE;

1927: */
1928: l_rowid VARCHAR2(25);
1929: l_success VARCHAR2(1);
1930: l_error_code igs_pe_sn_srvce_int.error_code%TYPE;
1931: l_sn_service_id igs_pe_sn_service.sn_service_id%TYPE;
1932:
1933: BEGIN
1934:
1935: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1956: igs_pe_sn_service_pkg.insert_row (

1952: -- kumma, 2608360 Added two more parameters for start_dt and end_dt
1953:
1954: IF l_success = 'Y' THEN -- Successful Validation
1955:
1956: igs_pe_sn_service_pkg.insert_row (
1957: x_rowid => l_rowid ,
1958: x_sn_service_id => l_sn_service_id,
1959: x_disability_id => p_disability_id,
1960: x_special_service_cd => p_sn_service_rec.special_service_cd,

Line 1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'

1991:
1992: l_label := 'igs.plsql.igs_ad_imp_011.create_sn_service.exception'||l_error_code;
1993:
1994: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Create_SN_Service '
1995: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.insert_row'
1996: ||' for INTERFACE SN SERVICE ID :'
1997: || p_sn_service_rec.interface_sn_service_id
1998: || ' Status : 3'
1999: || ' ErrorCode :' || l_error_code

Line 2121: p_disability_id IN igs_pe_sn_service.disability_id%TYPE,

2117: END create_sn_contact;
2118:
2119:
2120: PROCEDURE process_sn_service(p_interface_disability_id IN igs_ad_disablty_int.interface_disablty_id%TYPE,
2121: p_disability_id IN igs_pe_sn_service.disability_id%TYPE,
2122: p_person_id IN igs_ad_interface.person_id%TYPE,
2123: p_status OUT NOCOPY VARCHAR2)
2124: AS
2125: --------------------------------------------------------------------------

Line 2179: FROM igs_pe_sn_service pe

2175: WHERE mi.interface_run_id = l_interface_run_id
2176: AND mi.status = cst_stat_val_2
2177: AND mi.interface_disablty_id = p_interface_disability_id
2178: AND EXISTS ( SELECT '1'
2179: FROM igs_pe_sn_service pe
2180: WHERE pe.disability_id = p_disability_id AND
2181: mi.special_service_cd = pe.special_service_cd AND
2182: NVL(TRUNC(mi.start_dt),l_default_date) = NVL(pe.start_dt,l_default_date)
2183: );

Line 2216: FROM igs_pe_sn_service pe

2212: AND mi.match_ind IS NULL
2213: AND mi.status = cst_stat_val_2
2214: AND mi.interface_disablty_id = p_interface_disability_id
2215: AND EXISTS ( SELECT '1'
2216: FROM igs_pe_sn_service pe
2217: WHERE pe.disability_id = p_disability_id AND
2218: mi.special_service_cd = pe.special_service_cd AND
2219: UPPER(mi.documented_ind) = UPPER(pe.documented_ind) AND
2220: (TRUNC(mi.start_dt) = TRUNC(pe.start_dt) OR (mi.start_dt IS NULL AND pe.start_dt IS NULL)) AND

Line 2232: FROM igs_pe_sn_service pe

2228: UPDATE igs_pe_sn_srvce_int mi
2229: SET status = cst_stat_val_3,
2230: match_ind = cst_mi_val_20,
2231: dup_sn_service_id = (SELECT sn_service_id
2232: FROM igs_pe_sn_service pe
2233: WHERE pe.disability_id = p_disability_id AND
2234: mi.special_service_cd = pe.special_service_cd AND
2235: NVL(TRUNC(mi.start_dt),l_default_date) = NVL(TRUNC(pe.start_dt),l_default_date))
2236: WHERE mi.interface_run_id = l_interface_run_id

Line 2241: FROM igs_pe_sn_service pe

2237: AND mi.match_ind IS NULL
2238: AND mi.status = cst_stat_val_2
2239: AND mi.interface_disablty_id = p_interface_disability_id
2240: AND EXISTS (SELECT '1'
2241: FROM igs_pe_sn_service pe
2242: WHERE pe.disability_id = p_disability_id AND
2243: mi.special_service_cd = pe.special_service_cd AND
2244: NVL(TRUNC(mi.start_dt),l_default_date) = NVL(TRUNC(pe.start_dt),l_default_date));
2245: END IF;

Line 2266: igs_pe_sn_service_pkg.update_row (

2262: IF l_rule = 'I' THEN
2263: BEGIN
2264: validate_sn_service(sn_service_rec, p_person_id, l_success, l_error_code);
2265: IF l_success = 'Y' THEN -- Successful Validation
2266: igs_pe_sn_service_pkg.update_row (
2267: x_rowid => dup_chk_sn_service_rec.ROWID,
2268: x_sn_service_id => dup_chk_sn_service_rec.sn_service_id,
2269: x_disability_id => dup_chk_sn_service_rec.disability_id,
2270: x_special_service_cd => sn_service_rec.special_service_cd,

Line 2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'

2301:
2302: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2303:
2304: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2305: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2306: ||' for INTERFACE SN SERVICE ID :'
2307: || sn_service_rec.interface_sn_service_id
2308: || ' Status : 3'
2309: || ' ErrorCode :' || l_error_code

Line 2330: igs_pe_sn_service_pkg.update_row (

2326:
2327: validate_sn_service(sn_service_rec, p_person_id, l_success, l_error_code);
2328:
2329: IF l_success = 'Y' THEN -- Successful Validation
2330: igs_pe_sn_service_pkg.update_row (
2331: x_rowid => dup_chk_sn_service_rec.rowid ,
2332: x_sn_service_id => dup_chk_sn_service_rec.sn_service_id,
2333: x_disability_id => p_disability_id,
2334: x_special_service_cd => sn_service_rec.special_service_cd,

Line 2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'

2366:
2367: l_label := 'igs.plsql.igs_ad_imp_011.process_sn_service.exception'||l_error_code;
2368:
2369: l_debug_str := 'Igs_Ad_Imp_011.Prc_Pe_Spl_Needs.Process_SN_Service '
2370: ||'Unhandled Exception in call to igs_pe_sn_service_pkg.update_row'
2371: ||' for INTERFACE SN SERVICE ID :'
2372: || sn_service_rec.interface_sn_service_id
2373: || ' Status : 3'
2374: || ' ErrorCode :' || l_error_code