DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on FND_ATTACHMENT_UTIL_PKG

Line 85: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

81: if p_action = 'SAVE_VERSION' then
82: --
83: -- Remove Header Level Attachment
84: --
85: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
86: l_pkey1 => p_chr_id,
87: l_pkey2 => l_minus_version) = 'Y' then
88:
89: fnd_attached_documents2_pkg.delete_attachments(

Line 101: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

97: -- Remove Line Level Attachment
98: --
99: for c_lines_rec in c_lines loop
100: --
101: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
102: l_pkey1 => c_lines_rec.id,
103: l_pkey2 => l_minus_version) = 'Y' then
104:
105: fnd_attached_documents2_pkg.delete_attachments(

Line 119: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

115: -- Creating Attachments for -1 level version of the contract
116: --
117: -- version Header Level Attachments
118: --
119: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
120: l_pkey1 => p_chr_id,
121: l_pkey2 => l_major_version) = 'Y' then
122:
123: fnd_attached_documents2_pkg.copy_attachments(

Line 136: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

132: -- Version Line Level Attachments
133: --
134: for c_lines_rec in c_lines loop
135: --
136: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
137: l_pkey1 => c_lines_rec.id,
138: l_pkey2 => l_major_version) = 'Y' then
139:
140: fnd_attached_documents2_pkg.copy_attachments(

Line 170: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

166: -- Delete Header Level Attachments with version
167: --
168: for l_ver_num in l_rest_to_major_ver..l_curr_major_ver loop
169:
170: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
171: l_pkey1 => p_chr_id,
172: l_pkey2 => l_ver_num) = 'Y' then
173:
174: fnd_attached_documents2_pkg.delete_attachments(

Line 184: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

180: end if;
181: --
182: if l_ver_num = l_rest_to_major_ver then
183: --
184: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
185: l_pkey1 => p_chr_id,
186: l_pkey2 => l_minus_version) = 'Y' then
187:
188: fnd_attached_documents2_pkg.copy_attachments(

Line 205: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

201: --
202: for c_lines_rec in c_lines loop
203: --
204: for l_ver_num in l_rest_to_major_ver..l_curr_major_ver loop
205: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
206: l_pkey1 => c_lines_rec.id,
207: l_pkey2 => l_ver_num) = 'Y' then
208:
209: fnd_attached_documents2_pkg.delete_attachments(

Line 220: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

216: --
217: --
218: if l_ver_num = l_rest_to_major_ver then
219: --
220: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
221: l_pkey1 => c_lines_rec.id,
222: l_pkey2 => l_minus_version) = 'Y' then
223:
224: fnd_attached_documents2_pkg.copy_attachments(

Line 245: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

241: --
242: --
243: -- Remove Header Level Attachment
244: --
245: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
246: l_pkey1 => p_chr_id,
247: l_pkey2 => l_minus_version) = 'Y' then
248:
249: fnd_attached_documents2_pkg.delete_attachments(

Line 261: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

257: -- Remove Line Level Attachment
258: --
259: for c_lines_rec in c_lines loop
260: --
261: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
262: l_pkey1 => c_lines_rec.id,
263: l_pkey2 => l_minus_version) = 'Y' then
264:
265: fnd_attached_documents2_pkg.delete_attachments(

Line 2374: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

2370: FROM okc_k_headers_b
2371: WHERE id = p_chr_id;
2372: BEGIN
2373: If (p_chr_id IS NOT NULL AND
2374: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL
2375: )
2376: Then
2377: open l_chr_csr;
2378: fetch l_chr_csr into l_app_id;

Line 2383: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';

2379: close l_chr_csr;
2380:
2381: -- Added for Bug 2384423
2382: If (l_app_id = 515) Then
2383: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
2384: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2385: Else
2386: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
2387: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

Line 2384: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

2380:
2381: -- Added for Bug 2384423
2382: If (l_app_id = 515) Then
2383: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
2384: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2385: Else
2386: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
2387: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2388: End If;

Line 2386: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';

2382: If (l_app_id = 515) Then
2383: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
2384: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2385: Else
2386: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
2387: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2388: End If;
2389:
2390: End If;

Line 2387: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';

2383: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKSAUDET';
2384: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2385: Else
2386: FND_ATTACHMENT_UTIL_PKG.function_name := 'OKCAUDET';
2387: FND_ATTACHMENT_UTIL_PKG.function_type := 'O';
2388: End If;
2389:
2390: End If;
2391: END;