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_PRG

Line 2164: CURSOR dup_chk_ath_prg_cur(cp_person_id igs_pe_athletic_prg.person_id%TYPE,

2160: AND ai.status = '2';
2161:
2162:
2163: --Cursor to check for duplicates and provide Null handling while Updating.
2164: CURSOR dup_chk_ath_prg_cur(cp_person_id igs_pe_athletic_prg.person_id%TYPE,
2165: cp_athletic_prg_code igs_pe_athletic_prg.athletic_prg_code%TYPE,
2166: cp_start_date igs_pe_athletic_prg.start_date%TYPE) IS
2167: SELECT ROWID, ap.*
2168: FROM igs_pe_athletic_prg ap

Line 2165: cp_athletic_prg_code igs_pe_athletic_prg.athletic_prg_code%TYPE,

2161:
2162:
2163: --Cursor to check for duplicates and provide Null handling while Updating.
2164: CURSOR dup_chk_ath_prg_cur(cp_person_id igs_pe_athletic_prg.person_id%TYPE,
2165: cp_athletic_prg_code igs_pe_athletic_prg.athletic_prg_code%TYPE,
2166: cp_start_date igs_pe_athletic_prg.start_date%TYPE) IS
2167: SELECT ROWID, ap.*
2168: FROM igs_pe_athletic_prg ap
2169: WHERE person_id = cp_person_id AND

Line 2166: cp_start_date igs_pe_athletic_prg.start_date%TYPE) IS

2162:
2163: --Cursor to check for duplicates and provide Null handling while Updating.
2164: CURSOR dup_chk_ath_prg_cur(cp_person_id igs_pe_athletic_prg.person_id%TYPE,
2165: cp_athletic_prg_code igs_pe_athletic_prg.athletic_prg_code%TYPE,
2166: cp_start_date igs_pe_athletic_prg.start_date%TYPE) IS
2167: SELECT ROWID, ap.*
2168: FROM igs_pe_athletic_prg ap
2169: WHERE person_id = cp_person_id AND
2170: UPPER(athletic_prg_code) = UPPER(cp_athletic_prg_code) AND

Line 2168: FROM igs_pe_athletic_prg ap

2164: CURSOR dup_chk_ath_prg_cur(cp_person_id igs_pe_athletic_prg.person_id%TYPE,
2165: cp_athletic_prg_code igs_pe_athletic_prg.athletic_prg_code%TYPE,
2166: cp_start_date igs_pe_athletic_prg.start_date%TYPE) IS
2167: SELECT ROWID, ap.*
2168: FROM igs_pe_athletic_prg ap
2169: WHERE person_id = cp_person_id AND
2170: UPPER(athletic_prg_code) = UPPER(cp_athletic_prg_code) AND
2171: start_date = cp_start_date;
2172:

Line 2184: l_athletic_prg_id igs_pe_athletic_prg.athletic_prg_id%TYPE;

2180: p_ath_prg_rec IN ath_prg_cur%ROWTYPE
2181: )
2182: AS
2183: l_rowid VARCHAR2(25);
2184: l_athletic_prg_id igs_pe_athletic_prg.athletic_prg_id%TYPE;
2185: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2186: BEGIN
2187: -- Call Log header
2188: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 2204: igs_pe_athletic_prg_pkg.insert_row (

2200: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2201: END IF;
2202:
2203:
2204: igs_pe_athletic_prg_pkg.insert_row (
2205: x_rowid => l_rowid,
2206: x_athletic_prg_id => l_athletic_prg_id,
2207: x_person_id => p_ath_prg_rec.person_id,
2208: x_athletic_prg_code => p_ath_prg_rec.athletic_prg_code,

Line 2242: ||' Exception from igs_pe_athletic_prg_Pkg.Insert_Row '

2238:
2239: l_label := 'igs.plsql.igs_ad_imp_003.crt_apcnt_ath_dtl.exception '||l_error_code;
2240:
2241: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg.crt_apcnt_ath_prg'
2242: ||' Exception from igs_pe_athletic_prg_Pkg.Insert_Row '
2243: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2244: (p_ath_prg_rec.interface_athletic_prg_id) ||
2245: ' Status : ' || '3' || ' ErrorCode : ' || l_error_code
2246: ||' SQLERRM:' || SQLERRM;

Line 2409: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i

2405: match_ind = cst_mi_val_19
2406: WHERE ai.interface_run_id = l_interface_run_id
2407: AND ai.status = cst_stat_val_2
2408: AND EXISTS( SELECT '1'
2409: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i
2410: WHERE i.interface_id = ai.interface_id
2411: AND i.interface_run_id = l_interface_run_id
2412: AND pe.person_id = NVL(i.person_id, -99) AND
2413: pe.athletic_prg_code = UPPER(ai.athletic_prg_code) AND

Line 2448: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i

2444: WHERE ai.interface_run_id = l_interface_run_id
2445: AND ai.match_ind IS NULL
2446: AND ai.status = cst_stat_val_2
2447: AND EXISTS ( SELECT '1'
2448: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i
2449: WHERE i.interface_id = ai.interface_id
2450: AND i.interface_run_id = l_interface_run_id
2451: AND pe.person_id = NVL(i.person_id, -99) AND
2452: pe.athletic_prg_code = UPPER(ai.athletic_prg_code) AND

Line 2467: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i

2463: UPDATE igs_pe_ath_prg_int ai
2464: SET status = cst_stat_val_3,
2465: match_ind = cst_mi_val_20,
2466: dup_athletic_prg_id = (SELECT athletic_prg_id
2467: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i
2468: WHERE i.interface_id = ai.interface_id
2469: AND i.interface_run_id = l_interface_run_id
2470: AND pe.person_id = NVL(i.person_id, -99) AND
2471: pe.athletic_prg_code = UPPER(ai.athletic_prg_code) AND

Line 2477: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i

2473: WHERE ai.interface_run_id = l_interface_run_id
2474: AND ai.match_ind IS NULL
2475: AND ai.status = cst_stat_val_2
2476: AND EXISTS (SELECT '1'
2477: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i
2478: WHERE i.interface_id = ai.interface_id
2479: AND i.interface_run_id = l_interface_run_id
2480: AND pe.person_id = NVL(i.person_id, -99) AND
2481: pe.athletic_prg_code = UPPER(ai.athletic_prg_code) AND

Line 2509: igs_pe_athletic_prg_pkg.update_row (

2505: --If its a duplicate record find the source category rule for that Source Category.
2506: IF dup_chk_ath_prg_rec.athletic_prg_id IS NOT NULL THEN
2507: IF l_rule = 'I' THEN
2508: BEGIN
2509: igs_pe_athletic_prg_pkg.update_row (
2510: x_rowid => dup_chk_ath_prg_rec.rowid,
2511: x_athletic_prg_id => dup_chk_ath_prg_rec.athletic_prg_id,
2512: x_person_id => NVL(ath_prg_rec.person_id,dup_chk_ath_prg_rec.person_id),
2513: x_athletic_prg_code => ath_prg_rec.athletic_prg_code,

Line 2551: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '

2547:
2548: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.exception1 '||l_error_code;
2549:
2550: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg'
2551: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '
2552: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2553: (ath_prg_rec.interface_athletic_prg_id) ||
2554: ' Status : ' || '3' || ' ErrorCode : ' ||
2555: l_error_code||' SQLERRM:' || SQLERRM;

Line 2572: igs_pe_athletic_prg_pkg.update_row (

2568:
2569: ELSIF l_rule = 'R' THEN
2570: IF ath_prg_rec.match_ind = '21' THEN -- '21' Match reviewed and to be imported
2571: BEGIN
2572: igs_pe_athletic_prg_pkg.update_row (
2573: x_rowid => dup_chk_ath_prg_rec.rowid,
2574: x_athletic_prg_id => dup_chk_ath_prg_rec.athletic_prg_id,
2575: x_person_id => NVL(ath_prg_rec.person_id,dup_chk_ath_prg_rec.person_id),
2576: x_athletic_prg_code => ath_prg_rec.athletic_prg_code,

Line 2614: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '

2610:
2611: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_ath_prg.exception2 '||l_error_code;
2612:
2613: l_debug_str := 'igs_ad_imp_003.prc_apcnt_ath_prg'
2614: ||' Exception from igs_pe_athletic_prg_Pkg.Update_Row '
2615: || ' INTERFACE_ATHLETIC_PRG_ID : ' ||
2616: (ath_prg_rec.interface_athletic_prg_id) ||
2617: ' Status : ' || '3' || ' ErrorCode : ' ||
2618: l_error_code||' SQLERRM:' || SQLERRM;

Line 2638: END IF; -- Record existance in IGS_PE_ATHLETIC_PRG check

2634: END IF;-- l_rule check for 'I','R' or 'E'.
2635:
2636: ELSE -- If its not a duplicate record then Create a new record in OSS
2637: crt_apcnt_ath_prg (p_ath_prg_rec => ath_prg_rec);
2638: END IF; -- Record existance in IGS_PE_ATHLETIC_PRG check
2639: END IF; -- Check for Validate Record
2640:
2641: IF l_processed_records = 100 THEN
2642: COMMIT;