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.GHR_GEN_RPA_NPA dependencies on FND_LOBS

Line 2414: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)

2410: l_ctr := l_ctr + 1;
2411:
2412: END Populate_NPAtags;
2413:
2414: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2415: IS
2416: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2417: SELECT FILE_DATA
2418: FROM FND_LOBS

Line 2416: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS

2412: END Populate_NPAtags;
2413:
2414: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2415: IS
2416: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2417: SELECT FILE_DATA
2418: FROM FND_LOBS
2419: WHERE PROGRAM_NAME = c_program_name;
2420: BEGIN

Line 2418: FROM FND_LOBS

2414: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2415: IS
2416: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2417: SELECT FILE_DATA
2418: FROM FND_LOBS
2419: WHERE PROGRAM_NAME = c_program_name;
2420: BEGIN
2421: FOR l_get_template IN c_get_template(p_program_name) LOOP
2422: p_template := l_get_template.FILE_DATA;