DBA Data[Home] [Help]

APPS.GHR_GEN_RPA_NPA dependencies on FND_LOBS

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

2750: l_ctr := l_ctr + 1;
2751:
2752: END Populate_NPAtags;
2753:
2754: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2755: IS
2756: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2757: SELECT FILE_DATA
2758: FROM FND_LOBS

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

2752: END Populate_NPAtags;
2753:
2754: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2755: IS
2756: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2757: SELECT FILE_DATA
2758: FROM FND_LOBS
2759: WHERE PROGRAM_NAME = c_program_name order by file_id desc;
2760: BEGIN

Line 2758: FROM FND_LOBS

2754: PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB)
2755: IS
2756: CURSOR c_get_template(c_program_name fnd_lobs.program_name%type) IS
2757: SELECT FILE_DATA
2758: FROM FND_LOBS
2759: WHERE PROGRAM_NAME = c_program_name order by file_id desc;
2760: BEGIN
2761: FOR l_get_template IN c_get_template(p_program_name) LOOP
2762: p_template := l_get_template.FILE_DATA;