APPS.PAY_CORE_FILES dependencies on PAY_FILE_DETAILS

Line 7: (file_detail_id pay_file_details.file_detail_id%type,

3: --
4: -- Setup Datatypes
5: --
6: type t_file_list_rec is record
7: (file_detail_id pay_file_details.file_detail_id%type,
8: file_type pay_file_details.file_type%type,
9: int_file_name varchar2(30),
10: position number,
11: nxtptr number,

Line 8: file_type pay_file_details.file_type%type,

4: -- Setup Datatypes
5: --
6: type t_file_list_rec is record
7: (file_detail_id pay_file_details.file_detail_id%type,
8: file_type pay_file_details.file_type%type,
9: int_file_name varchar2(30),
10: position number,
11: nxtptr number,
12: prvptr number,

Line 74: from pay_file_details

70: g_char_set := hr_mx_utility.get_IANA_charset;
71:
72: select file_detail_id
73: into file_id
74: from pay_file_details
75: where source_id=p_source_id
76: and source_type=p_source_type
77: and internal_file_name=p_int_file_name
78: and sequence=p_sequence;

Line 84: from pay_file_details

80: g_file_list(file_id).file_detail_id := file_id;
81:
82: select blob_file_fragment
83: into g_file_list(file_id).file_locator
84: from pay_file_details
85: where file_detail_id=file_id
86: for update of blob_file_fragment;
87:
88:

Line 98: select pay_file_details_s.nextval

94: end if;
95:
96: exception
97: when no_data_found then
98: select pay_file_details_s.nextval
99: into file_id
100: from dual;
101: --
102: g_file_list(file_id).file_detail_id := file_id;

Line 108: insert into pay_file_details

104: g_file_list(file_id).file_type := p_file_type;
105: g_file_list(file_id).int_file_name := p_int_file_name;
106: g_file_list(file_id).sequence := p_sequence;
107: --
108: insert into pay_file_details
109: (file_detail_id,
110: source_id,
111: source_type,
112: file_location,

Line 131: from pay_file_details

127: );
128:
129: select blob_file_fragment
130: into g_file_list(file_id).file_locator
131: from pay_file_details
132: where file_detail_id = file_id
133: for update of blob_file_fragment;
134:
135: dbms_lob.open(g_file_list(file_id).file_locator, DBMS_LOB.LOB_READWRITE);

Line 287: from pay_file_details

283: begin
284: --
285: select file_fragment
286: into g_tmp_clob
287: from pay_file_details
288: where file_detail_id = p_file_id;
289: --
290: dbms_lob.open(g_tmp_clob, DBMS_LOB.LOB_READONLY);
291: --

Line 300: from pay_file_details

296: begin
297: --
298: select blob_file_fragment
299: into g_tmp_blob
300: from pay_file_details
301: where file_detail_id = p_file_id;
302: --
303: dbms_lob.open(g_tmp_blob, DBMS_LOB.LOB_READONLY);
304:

Line 408: l_file_type pay_file_details.file_type%type;

404: p_text out nocopy varchar2
405: )
406: is
407: l_size number;
408: l_file_type pay_file_details.file_type%type;
409: begin
410: --
411:
412: if (g_tmp_blob is null) then

Line 479: l_file_type pay_file_details.file_type%type;

475: p_text out nocopy raw
476: )
477: is
478: l_size number;
479: l_file_type pay_file_details.file_type%type;
480: raw_data raw(8000);
481: begin
482: --
483: if (g_tmp_blob is null) then

Line 678: from pay_file_details

674: begin
675: --
676: select file_fragment
677: into l_clob
678: from pay_file_details
679: where file_detail_id = p_file_id;
680: --
681: if l_clob is null then
682: p_size := 0;

Line 724: from pay_file_details

720: begin
721: --
722: select file_fragment
723: into l_clob
724: from pay_file_details
725: where file_detail_id = p_file_id;
726: --
727: if l_clob is null then
728: return null;

Line 753: from pay_file_details

749: begin
750: --
751: select blob_file_fragment
752: into l_blob
753: from pay_file_details
754: where file_detail_id = p_file_id;
755: --
756: if l_blob is null then
757: return null;