APPS.PAY_KR_YEA_PDF_PKG dependencies on FND_LOBS

Line 26: file_name fnd_lobs.file_name%type,

22: --
23: type t_ass_yea_rec is record(
24: assignment_yea_info_id number,
25: file_id number,
26: file_name fnd_lobs.file_name%type,
27: assignment_id number,
28: emp_num varchar2(30),
29: emp_name varchar2(300),
30: status varchar2(1));

Line 291: fnd_lobs fl

287: from per_kr_assignment_yea_info pkayi,
288: per_all_assignments_f pa,
289: per_periods_of_service ppos,
290: per_people_f pp,
291: fnd_lobs fl
292: where pkayi.assignment_yea_info_id = nvl(p_assignment_yea_info_id,pkayi.assignment_yea_info_id)
293: and pkayi.information_type = 'KR_YEA_ENTRY_STATUS'
294: and pkayi.ayi_information_category = 'KR_YEA_ENTRY_STATUS'
295: and pkayi.target_year = p_target_year

Line 733: from fnd_lobs

729: cursor csr_file(
730: p_file_id in number)
731: is
732: select file_id
733: from fnd_lobs
734: where file_id = p_file_id;
735: --
736: l_csr_kr_ass_yea csr_kr_ass_yea%rowtype;
737: l_csr_file csr_file%rowtype;

Line 852: l_file_name fnd_lobs.file_name%type;

848: --
849: l_proc varchar2(80) := c_package||'import_file';
850: --
851: l_file_id number;
852: l_file_name fnd_lobs.file_name%type;
853: l_ass_yea_info_id number;
854: --
855: l_csr_map_name csr_map_name%rowtype;
856: --

Line 1193: l_file_name fnd_lobs.file_name%type;

1189: is
1190: --
1191: l_proc varchar2(80) := c_package||'load_map_file';
1192: --
1193: l_file_name fnd_lobs.file_name%type;
1194: --
1195: l_csr_map_name csr_map_name%rowtype;
1196: --
1197: begin

Line 6987: l_file_name fnd_lobs.file_name%type;

6983: l_target_eoy date;
6984: --
6985: l_valid boolean := false;
6986: l_ass_yea_info_id number;
6987: l_file_name fnd_lobs.file_name%type;
6988: --
6989: cursor csr_file
6990: is
6991: select file_id,

Line 6993: from fnd_lobs

6989: cursor csr_file
6990: is
6991: select file_id,
6992: file_name
6993: from fnd_lobs
6994: where file_id = p_file_id;
6995: --
6996: /* same condition with EmpSearchVO.xml */
6997: /* no need primary flag check for rehire */

Line 7171: from fnd_lobs fl

7167: --
7168: cursor csr_mass_new_file
7169: is
7170: select fl.file_id
7171: from fnd_lobs fl
7172: where fl.program_name = 'PAYKRYPIM'
7173: and fl.program_tag = to_char(p_business_group_id)||':'||to_char(p_target_year)
7174: and not exists(
7175: select null

Line 7245: from fnd_lobs

7241: cursor csr_file
7242: is
7243: select file_id,
7244: to_number(substrb(program_tag,instrb(program_tag,':',-1)+1)) target_year
7245: from fnd_lobs
7246: where file_id = p_file_id;
7247: --
7248: l_csr_file csr_file%rowtype;
7249: --

Line 7299: from fnd_lobs

7295: -- this should include file which does not have map into per_kr_assignment_yea_info
7296: cursor csr_mass_file
7297: is
7298: select file_id
7299: from fnd_lobs
7300: where program_name = 'PAYKRYPIM'
7301: and to_number(substrb(program_tag,0,instrb(program_tag,':')-1)) = p_business_group_id
7302: and substrb(program_tag,instrb(program_tag,':',-1)+1) = to_char(p_target_year);
7303: --