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_012 dependencies on IGS_PE_ATHLETIC_DTL

Line 1633: CURSOR dup_chk_ath_dtl_cur(cp_person_id igs_pe_athletic_dtl.person_id%TYPE) IS

1629: AND ai.status = '2';
1630:
1631:
1632: --Cursor to provide Duplicate check and Null handling while Updating.
1633: CURSOR dup_chk_ath_dtl_cur(cp_person_id igs_pe_athletic_dtl.person_id%TYPE) IS
1634: SELECT ROWID, ad.*
1635: FROM igs_pe_athletic_dtl ad
1636: WHERE person_id = cp_person_id;
1637:

Line 1635: FROM igs_pe_athletic_dtl ad

1631:
1632: --Cursor to provide Duplicate check and Null handling while Updating.
1633: CURSOR dup_chk_ath_dtl_cur(cp_person_id igs_pe_athletic_dtl.person_id%TYPE) IS
1634: SELECT ROWID, ad.*
1635: FROM igs_pe_athletic_dtl ad
1636: WHERE person_id = cp_person_id;
1637:
1638: --Cursor to check for Discrepancy
1639: dup_chk_ath_dtl_rec dup_chk_ath_dtl_cur%ROWTYPE;

Line 1649: l_athletic_details_id igs_pe_athletic_dtl.athletic_details_id%TYPE;

1645: p_ath_dtl_rec IN ath_dtl_cur%ROWTYPE
1646: )
1647: AS
1648: l_rowid VARCHAR2(25);
1649: l_athletic_details_id igs_pe_athletic_dtl.athletic_details_id%TYPE;
1650: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1651: BEGIN
1652: -- Call Log header
1653: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 1668: igs_pe_athletic_dtl_pkg.insert_row (

1664: l_debug_str, NULL,
1665: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1666: END IF;
1667:
1668: igs_pe_athletic_dtl_pkg.insert_row (
1669: x_rowid => l_rowid,
1670: x_athletic_details_id => l_athletic_details_id,
1671: x_person_id => p_ath_dtl_rec.person_id,
1672: x_athletic_gpa => p_ath_dtl_rec.athletic_gpa,

Line 1705: ||' Exception from igs_pe_athletic_dtl_Pkg.Insert_Row '

1701:
1702: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_dtl.exception '||'E093';
1703:
1704: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls.crt_apcnt_ath_dtl'
1705: ||' Exception from igs_pe_athletic_dtl_Pkg.Insert_Row '
1706: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
1707: (p_ath_dtl_rec.interface_athletic_dtls_id) ||
1708: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
1709: ||' SQLERRM:' || SQLERRM;

Line 1884: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i

1880: match_ind = cst_mi_val_19
1881: WHERE ai.interface_run_id = l_interface_run_id
1882: AND ai.status = cst_stat_val_2
1883: AND EXISTS( SELECT '1'
1884: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i
1885: WHERE i.interface_id = ai.interface_id
1886: AND i.interface_run_id = l_interface_run_id
1887: AND pe.person_id = NVL(i.person_id, -99)
1888: );

Line 1920: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i

1916: WHERE mi.interface_run_id = l_interface_run_id
1917: AND mi.match_ind IS NULL
1918: AND mi.status = cst_stat_val_2
1919: AND EXISTS ( SELECT '1'
1920: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i
1921: WHERE i.interface_id = mi.interface_id
1922: AND i.interface_run_id = l_interface_run_id
1923: AND pe.person_id = NVL(i.person_id, -99) AND
1924: NVL(pe.athletic_gpa, -99) = NVL(mi.athletic_gpa,-99) AND

Line 1938: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i

1934: UPDATE igs_pe_ath_dtl_int ai
1935: SET status = cst_stat_val_3,
1936: match_ind = cst_mi_val_18,
1937: dup_athletic_details_id = (SELECT athletic_details_id
1938: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i
1939: WHERE i.interface_id = ai.interface_id
1940: AND i.interface_run_id = l_interface_run_id
1941: AND pe.person_id = NVL(i.person_id, -99))
1942: WHERE ai.interface_run_id = l_interface_run_id

Line 1946: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i

1942: WHERE ai.interface_run_id = l_interface_run_id
1943: AND ai.match_ind IS NULL
1944: AND ai.status = cst_stat_val_2
1945: AND EXISTS (SELECT '1'
1946: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i
1947: WHERE i.interface_id = ai.interface_id
1948: AND i.interface_run_id = l_interface_run_id
1949: AND pe.person_id = NVL(i.person_id, -99));
1950: END IF;

Line 1975: igs_pe_athletic_dtl_pkg.update_row (

1971:
1972: IF l_rule = 'I' THEN
1973:
1974: BEGIN
1975: igs_pe_athletic_dtl_pkg.update_row (
1976: x_rowid => dup_chk_ath_dtl_rec.rowid,
1977: x_athletic_details_id => dup_chk_ath_dtl_rec.athletic_details_id,
1978: x_person_id => NVL(ath_dtl_rec.person_id,dup_chk_ath_dtl_rec.person_id),
1979: x_athletic_gpa => NVL(ath_dtl_rec.athletic_gpa,dup_chk_ath_dtl_rec.athletic_gpa),

Line 2016: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '

2012:
2013: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.exception2 '||l_error_code;
2014:
2015: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls'
2016: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '
2017: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
2018: (ath_dtl_rec.interface_athletic_dtls_id) ||
2019: ' Status : ' || '3' || ' ErrorCode : ' ||
2020: l_error_code ||' SQLERRM:' || SQLERRM;

Line 2037: igs_pe_athletic_dtl_pkg.update_row (

2033:
2034: ELSIF l_rule = 'R' THEN
2035: IF ath_dtl_rec.match_ind = '21' THEN -- '21' Match reviewed and to be imported
2036: BEGIN
2037: igs_pe_athletic_dtl_pkg.update_row (
2038: x_rowid => dup_chk_ath_dtl_rec.rowid,
2039: x_athletic_details_id => dup_chk_ath_dtl_rec.athletic_details_id,
2040: x_person_id => NVL(ath_dtl_rec.person_id,dup_chk_ath_dtl_rec.person_id),
2041: x_athletic_gpa => NVL(ath_dtl_rec.athletic_gpa,dup_chk_ath_dtl_rec.athletic_gpa),

Line 2078: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '

2074:
2075: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_dtls.exception1 '||l_error_code;
2076:
2077: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_dtls'
2078: ||' Exception from igs_pe_athletic_dtl_Pkg.Update_Row '
2079: || ' INTERFACE_ATHLETIC_DTLS_ID : ' ||
2080: (ath_dtl_rec.interface_athletic_dtls_id) ||
2081: ' Status : ' || '3' || ' ErrorCode : ' ||
2082: l_error_code ||' SQLERRM:' || SQLERRM;

Line 2102: END IF; -- Record existance in IGS_PE_ATHLETIC_DTL check

2098:
2099: ELSE -- If its not a duplicate record then Create a new record in OSS
2100: crt_apcnt_ath_dtl (p_ath_dtl_rec => ath_dtl_rec);
2101:
2102: END IF; -- Record existance in IGS_PE_ATHLETIC_DTL check
2103: END IF; -- Check for Validate Record
2104:
2105: IF l_processed_records = 100 THEN
2106: COMMIT;