APPS.HR_ATTACHMENTS_LOADER dependencies on FND_ATTACHMENT_FUNCTIONS

Line 24: from fnd_attachment_functions

20: and p_function_type='F';
21: --
22: cursor att_func_exists(p_function_id NUMBER) is
23: select attachment_function_id
24: from fnd_attachment_functions
25: where function_type=p_function_type
26: and function_id=p_function_id;
27: --
28: l_function_id NUMBER;

Line 44: select fnd_attachment_functions_s.nextval

40: fetch att_func_exists into l_attachment_function_id;
41: if (att_func_exists%NOTFOUND) then
42: close att_func_exists;
43: -- if it doesn't exist then add it
44: select fnd_attachment_functions_s.nextval
45: into l_attachment_function_id
46: from sys.dual;
47: --
48: insert into fnd_attachment_functions (

Line 48: insert into fnd_attachment_functions (

44: select fnd_attachment_functions_s.nextval
45: into l_attachment_function_id
46: from sys.dual;
47: --
48: insert into fnd_attachment_functions (
49: attachment_function_id,
50: function_type,
51: function_id,
52: function_name,

Line 93: from fnd_attachment_functions

89: ,p_category_name IN VARCHAR2) is
90: --
91: cursor att_func_exists is
92: select 1
93: from fnd_attachment_functions
94: where attachment_function_id=p_attachment_function_id;
95: --
96: cursor categories is
97: select category_id

Line 183: from fnd_attachment_functions

179: ,p_attachment_blk_id OUT NUMBER) is
180: --
181: cursor att_func_exists is
182: select 1
183: from fnd_attachment_functions
184: where attachment_function_id=p_attachment_function_id;
185: --
186: cursor block_exists is
187: select attachment_blk_id