APPS.PAY_KR_YEA_PDF_PKG dependencies on FND_GFM

Line 777: fnd_gfm.delete_lob(l_csr_file.file_id);

773: close csr_file;
774: --
775: if l_csr_file.file_id is not null then
776: --
777: fnd_gfm.delete_lob(l_csr_file.file_id);
778: --
779: if g_debug then
780: hr_utility.set_location(l_proc,20);
781: end if;

Line 897: l_file_id := fnd_gfm.file_create(

893: --
894: /* skip for multiple assignment */
895: if l_file_id is null then
896: --
897: l_file_id := fnd_gfm.file_create(
898: content_type => c_pdf_mime,
899: file_name => g_import_path||g_path_delimiter||l_file_name,
900: program_name => 'PAYKRYPIM',
901: program_tag => to_char(g_business_group_id)||':'||to_char(g_target_yyyy));

Line 903: l_file_id := fnd_gfm.file_close(l_file_id);

899: file_name => g_import_path||g_path_delimiter||l_file_name,
900: program_name => 'PAYKRYPIM',
901: program_tag => to_char(g_business_group_id)||':'||to_char(g_target_yyyy));
902: --
903: l_file_id := fnd_gfm.file_close(l_file_id);
904: --
905: if g_debug then
906: hr_utility.trace('file id : '||to_char(l_file_id));
907: hr_utility.set_location(l_proc,30);

Line 937: fnd_gfm.delete_lob(l_file_id);

933: end if;
934: --
935: if nvl(g_remove_pdf,'N') = 'Y' then
936: --
937: fnd_gfm.delete_lob(l_file_id);
938: --
939: end if;
940: --
941: l_file_id := null;

Line 1060: fnd_gfm.delete_lob(g_ass_yea_tbl(i).file_id);

1056: where assignment_yea_info_id = g_ass_yea_tbl(i).assignment_yea_info_id;
1057: --
1058: if nvl(g_remove_pdf,'N') = 'Y' then
1059: --
1060: fnd_gfm.delete_lob(g_ass_yea_tbl(i).file_id);
1061: --
1062: end if;
1063: --
1064: end loop;

Line 7124: fnd_gfm.delete_lob(l_csr_file.file_id);

7120: if not l_valid then
7121: --
7122: if nvl(g_remove_pdf,'N') = 'Y' then
7123: --
7124: fnd_gfm.delete_lob(l_csr_file.file_id);
7125: --
7126: end if;
7127: --
7128: hr_utility.trace('invalid map : '||l_csr_file.file_name);

Line 7262: fnd_gfm.delete_lob(l_csr_file.file_id);

7258: close csr_file;
7259: --
7260: if l_csr_file.file_id is not null then
7261: --
7262: fnd_gfm.delete_lob(l_csr_file.file_id);
7263: --
7264: -- leave status because status is not only about pdf
7265: update per_kr_assignment_yea_info
7266: set ayi_information14 = decode(p_with_status,'Y',null,ayi_information14),