1 PACKAGE per_fnd_attachment_pkg AUTHID CURRENT_USER AS
2 /* $Header: pefdlpkg.pkh 120.2.12020000.1 2013/02/01 11:31:06 lbodired noship $ */
3 ------------------------------------------------------------------------------
4 -- |------------------------< upload_attachment >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of Comments}
7 -- Description:
8 -- This procedure is used to upload text or document into FND attachments table.
9 --
10 -- Prerequisites:
11 --
12 -- In Parameters:
13 -- Primary Key
14 --
15 -- Post Success:
16 --
17 -- Post Failure:
18 --
19 -- Developer Implementation Notes:
20 -- None.
21 --
22 -- Access Status:
23 -- Internal Development Use Only.
24 --
25 -- {End of Comments}
26 PROCEDURE upload_attachment(
27 p_person_id IN NUMBER,
28 p_fnd_doc_id OUT NOCOPY NUMBER,
29 p_datatype_id IN NUMBER,
30 p_category_id IN NUMBER,
31 p_title IN VARCHAR2,
32 p_description IN VARCHAR2,
33 p_file_name IN VARCHAR2,
34 p_file_content_type IN VARCHAR2,
35 p_function_name IN VARCHAR2,
36 p_entity_name IN VARCHAR2,
37 p_text IN VARCHAR2,
38 p_url IN VARCHAR2,
39 p_file_data IN BLOB,
40 p_pk1_value IN VARCHAR2,
41 p_pk2_value IN VARCHAR2,
42 p_pk3_value IN VARCHAR2,
43 p_pk4_value IN VARCHAR2,
44 p_pk5_value IN VARCHAR2,
45 p_usage_type IN VARCHAR2 DEFAULT 'O',
46 p_error_msg OUT NOCOPY VARCHAR2,
47 x_return_status IN OUT NOCOPY VARCHAR2);
48 ------------------------------------------------------------------------------
49 -- |------------------------< delete_attachment >----------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start of Comments}
52 -- Description:
53 -- This procedure is used to delete text or document into FND attachments table.
54 --
55 -- Prerequisites:
56 --
57 -- In Parameters:
58 -- Primary Key
59 --
60 -- Post Success:
61 --
62 -- Post Failure:
63 --
64 -- Developer Implementation Notes:
65 -- None.
66 --
67 -- Access Status:
68 -- Internal Development Use Only.
69 --
70 -- {End of Comments}
71 PROCEDURE delete_attachment(
72 p_fnd_doc_attachment_id IN NUMBER,
73 p_datatype_id IN NUMBER,
74 p_delete_document_flag in varchar2);
75 ------------------------------------------------------------------------------
76 -- |------------------------< upload_irec_docs >----------------------------|
77 -- ----------------------------------------------------------------------------
78 -- {Start of Comments}
79 -- Description:
80 -- This function is used to upload all the iRecruitment documents for a person
81 -- into FND attachments table. It also inserts the linking information for
82 -- iRecruitment document and FND attachments.
83 --
84 -- Prerequisites:
85 --
86 -- In Parameters:
87 -- Primary Key
88 --
89 -- Post Success:
90 --
91 -- Post Failure:
92 --
93 -- Developer Implementation Notes:
94 -- None.
95 --
96 -- Access Status:
97 -- Internal Development Use Only.
98 --
99 -- {End of Comments}
100 PROCEDURE upload_irec_docs(
101 p_person_id IN NUMBER,
102 p_assignment_id IN NUMBER default null,
103 p_application_id IN NUMBER default null,
104 p_hire_date IN DATE,
105 p_transaction_type IN VARCHAR2,
106 p_transaction_status IN VARCHAR2,
107 p_status IN VARCHAR2);
108 ------------------------------------------------------------------------------
109 -- |------------------------< adjust_irec_docs >----------------------------|
110 -- ----------------------------------------------------------------------------
111 -- {Start of Comments}
112 -- Description:
113 -- This procedure is used to adjust the linking of the iRecruitment document
114 -- and FND attachments in table PER_FND_DOC_LINKS. Basically this function
115 -- is used in ?Enter and Maintain? form to adjust the linking information.
116 --
117 -- Prerequisites:
118 --
119 -- In Parameters:
120 -- Primary Key
121 --
122 -- Post Success:
123 --
124 -- Post Failure:
125 --
126 -- Developer Implementation Notes:
127 -- None.
128 --
129 -- Access Status:
130 -- Internal Development Use Only.
131 --
132 -- {End of Comments}
133 PROCEDURE adjust_irec_docs(
134 p_person_id IN NUMBER,
135 p_assignment_id IN NUMBER default null,
136 p_application_id IN NUMBER default null,
137 p_old_hire_date IN DATE default null,
138 p_hire_date IN DATE,
139 p_transaction_type IN VARCHAR2 default null,
140 p_transaction_status IN VARCHAR2 default null,
141 p_status IN VARCHAR2 default 'I',
142 p_adjustment_type IN varchar2);
143 --
144 -- ----------------------------------------------------------------------------
145 -- |---------------------------< is_irec_doc_exist >----------------------------|
146 -- ----------------------------------------------------------------------------
147 -- {Start Of Comments}
148 --
149 -- Description:
150 -- This procedure controls the execution of all delete business rules
151 -- validation.
152 --
153 -- Prerequisites:
154 -- This private procedure is called from del procedure.
155 --
156 -- In Parameters:
157 -- A Pl/Sql record structure.
158 --
159 -- Post Success:
160 -- Processing continues.
161 --
162 Function is_iRec_doc_exist
163 (p_person_id number
164 ,p_irc_document_id number) return boolean;
165
166 procedure dml_on_link_table
167 (p_entity_name in varchar2
168 ,p_sub_entity_name in varchar2
169 ,p_person_id in number
170 ,p_doc_upload_date in date
171 ,p_transaction_type in varchar2
172 ,p_transaction_status in varchar2
173 ,p_status in varchar2 default 'I'
174 ,p_entity_doc_id in number
175 ,p_fnd_doc_id in number
176 ,p_assignment_id in number default null
177 ,p_application_id in number default null
178 ,p_fdl_information_category in varchar2 default null
179 ,p_fdl_information1 in varchar2 default null
180 ,p_fdl_information2 in varchar2 default null
181 ,p_fdl_information3 in varchar2 default null
182 ,p_fdl_information4 in varchar2 default null
183 ,p_fdl_information5 in varchar2 default null
184 ,p_fdl_information6 in varchar2 default null
185 ,p_fdl_information7 in varchar2 default null
186 ,p_fdl_information8 in varchar2 default null
187 ,p_fdl_information9 in varchar2 default null
188 ,p_fdl_information10 in varchar2 default null
189 ,p_fnd_doc_link_id out nocopy number
190 ,p_object_version_number out nocopy number
191 ,p_mode in varchar2
192 );
193
194 PROCEDURE update_on_link_table(
195 p_irc_doc_id IN varchar2,
196 p_person_id IN varchar2,
197 attached_documents_rec IN fnd_attached_documents%rowtype
198 );
199
200 END per_fnd_attachment_pkg;