APPS.IGS_AD_TSTUH_CALL_PKG dependencies on IGS_AD_TST_UH_PKG

Line 8: l_object_name user_objects.object_name%TYPE DEFAULT 'IGS_AD_TST_UH_PKG';

4: PROCEDURE call_user_hook( p_person_id IN NUMBER,
5: p_session_id OUT NOCOPY NUMBER
6: ) IS
7:
8: l_object_name user_objects.object_name%TYPE DEFAULT 'IGS_AD_TST_UH_PKG';
9: INVALID_USER_HOOK EXCEPTION;
10:
11: CURSOR chk_uh_stat_cur IS
12: SELECT

Line 17: object_name = 'IGS_AD_TST_UH_PKG' AND

13: status
14: FROM
15: user_objects
16: WHERE
17: object_name = 'IGS_AD_TST_UH_PKG' AND
18: object_type = 'PACKAGE BODY';
19:
20: chk_uh_stat_rec chk_uh_stat_cur%ROWTYPE;
21:

Line 55: igs_ad_tst_uh_pkg.convert_test_scr_uk(

51: OPEN session_id_cur;
52: FETCH session_id_cur INTO session_id_rec;
53: CLOSE session_id_cur;
54: p_session_id := session_id_rec.session_id;
55: igs_ad_tst_uh_pkg.convert_test_scr_uk(
56: p_person_id => p_person_id,
57: p_session_id => p_session_id);
58: END IF;
59: EXCEPTION