APPS.GHR_WGI_PKG dependencies on GHR_PROCESS_LOG

Line 2146: p_program_name IN ghr_process_log.program_name%TYPE,

2142:
2143: --
2144: --
2145: PROCEDURE create_ghr_errorlog (
2146: p_program_name IN ghr_process_log.program_name%TYPE,
2147: p_log_text IN ghr_process_log.log_text%TYPE,
2148: p_message_name IN ghr_process_log.message_name%TYPE,
2149: p_log_date IN ghr_process_log.log_date%TYPE
2150: )

Line 2147: p_log_text IN ghr_process_log.log_text%TYPE,

2143: --
2144: --
2145: PROCEDURE create_ghr_errorlog (
2146: p_program_name IN ghr_process_log.program_name%TYPE,
2147: p_log_text IN ghr_process_log.log_text%TYPE,
2148: p_message_name IN ghr_process_log.message_name%TYPE,
2149: p_log_date IN ghr_process_log.log_date%TYPE
2150: )
2151: IS

Line 2148: p_message_name IN ghr_process_log.message_name%TYPE,

2144: --
2145: PROCEDURE create_ghr_errorlog (
2146: p_program_name IN ghr_process_log.program_name%TYPE,
2147: p_log_text IN ghr_process_log.log_text%TYPE,
2148: p_message_name IN ghr_process_log.message_name%TYPE,
2149: p_log_date IN ghr_process_log.log_date%TYPE
2150: )
2151: IS
2152: --

Line 2149: p_log_date IN ghr_process_log.log_date%TYPE

2145: PROCEDURE create_ghr_errorlog (
2146: p_program_name IN ghr_process_log.program_name%TYPE,
2147: p_log_text IN ghr_process_log.log_text%TYPE,
2148: p_message_name IN ghr_process_log.message_name%TYPE,
2149: p_log_date IN ghr_process_log.log_date%TYPE
2150: )
2151: IS
2152: --
2153: l_message_name ghr_process_log.message_name%TYPE;

Line 2153: l_message_name ghr_process_log.message_name%TYPE;

2149: p_log_date IN ghr_process_log.log_date%TYPE
2150: )
2151: IS
2152: --
2153: l_message_name ghr_process_log.message_name%TYPE;
2154: BEGIN
2155: --
2156: l_message_name := NVL (p_message_name, 'Please see log text');
2157:

Line 2158: INSERT INTO ghr_process_log

2154: BEGIN
2155: --
2156: l_message_name := NVL (p_message_name, 'Please see log text');
2157:
2158: INSERT INTO ghr_process_log
2159: (process_log_id, program_name, log_text,
2160: message_name, log_date
2161: )
2162: VALUES (ghr_process_log_s.NEXTVAL, p_program_name, p_log_text,

Line 2162: VALUES (ghr_process_log_s.NEXTVAL, p_program_name, p_log_text,

2158: INSERT INTO ghr_process_log
2159: (process_log_id, program_name, log_text,
2160: message_name, log_date
2161: )
2162: VALUES (ghr_process_log_s.NEXTVAL, p_program_name, p_log_text,
2163: l_message_name, p_log_date
2164: );
2165: EXCEPTION
2166: WHEN NO_DATA_FOUND