DBA Data[Home] [Help]

APPS.IGS_AD_TSTUH_CALL_PKG dependencies on USER_OBJECTS

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 15: user_objects

11: CURSOR chk_uh_stat_cur IS
12: SELECT
13: status
14: FROM
15: user_objects
16: WHERE
17: object_name = 'IGS_AD_TST_UH_PKG' AND
18: object_type = 'PACKAGE BODY';
19: