DBA Data[Home] [Help]

APPS.IGF_AW_GEN dependencies on FND_CONCURRENT_PROGRAMS_TL

Line 2163: FUNCTION get_concurrent_prog_name (p_program_id IN fnd_concurrent_programs_tl.concurrent_program_id%TYPE) RETURN VARCHAR2 IS

2159: || Change History :
2160: || Who When What
2161: || (reverse chronological order - newest change first)
2162: */
2163: FUNCTION get_concurrent_prog_name (p_program_id IN fnd_concurrent_programs_tl.concurrent_program_id%TYPE) RETURN VARCHAR2 IS
2164: CURSOR c_cp_name IS
2165: SELECT
2166: user_concurrent_program_name
2167: FROM

Line 2168: FND_CONCURRENT_PROGRAMS_TL

2164: CURSOR c_cp_name IS
2165: SELECT
2166: user_concurrent_program_name
2167: FROM
2168: FND_CONCURRENT_PROGRAMS_TL
2169: WHERE
2170: APPLICATION_ID = 8406 AND
2171: CONCURRENT_PROGRAM_ID = p_program_id AND
2172: LANGUAGE = userenv('LANG');

Line 2173: l_user_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;

2169: WHERE
2170: APPLICATION_ID = 8406 AND
2171: CONCURRENT_PROGRAM_ID = p_program_id AND
2172: LANGUAGE = userenv('LANG');
2173: l_user_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
2174: BEGIN
2175: OPEN c_cp_name;
2176: FETCH c_cp_name INTO l_user_concurrent_program_name;
2177: CLOSE c_cp_name;