APPS.FND_ATTACHMENT_UTIL_PKG dependencies on FND_ATTACHMENT_FUNCTIONS

Line 38: fnd_attachment_functions af,

34: SELECT 'Y'
35: INTO l_exists
36: FROM fnd_doc_category_usages fdcu,
37: fnd_documents fd,
38: fnd_attachment_functions af,
39: fnd_attached_documents fad
40: WHERE fad.entity_name = l_entity_name
41: AND fad.pk1_value = l_pkey1
42: AND fad.pk2_value = l_pkey2

Line 52: and exists (select 'x' from fnd_attachment_functions af

48: AND fad.document_id = fd.document_id
49: AND fd.category_id = fdcu.category_id
50: AND fdcu.attachment_function_id = af.attachment_function_id
51: AND fdcu.enabled_flag = 'Y'
52: and exists (select 'x' from fnd_attachment_functions af
53: where af.function_type = l2_function_type
54: AND af.function_name = l2_function_name
55: AND fdcu.attachment_function_id = af.attachment_function_id)
56: AND ROWNUM = 1;

Line 65: fnd_attachment_functions af

61: INTO l_exists
62: FROM fnd_doc_category_usages fdcu,
63: fnd_documents fd,
64: fnd_attached_documents fad,
65: fnd_attachment_functions af
66: WHERE fad.entity_name = l_entity_name
67: AND fad.pk1_value = l_pkey1
68: AND fad.pk2_value = l_pkey2
69: AND (l_pkey3 IS NULL

Line 79: and exists (select 'x' from fnd_attachment_functions af

75: AND fad.document_id = fd.document_id
76: AND fd.category_id = fdcu.category_id
77: AND fdcu.attachment_function_id = af.attachment_function_id
78: AND fdcu.enabled_flag = 'Y'
79: and exists (select 'x' from fnd_attachment_functions af
80: where af.function_type = l2_function_type
81: AND af.function_name = l2_function_name
82: AND fdcu.attachment_function_id = af.attachment_function_id)
83: AND ROWNUM = 1;

Line 92: fnd_attachment_functions af

88: INTO l_exists
89: FROM fnd_doc_category_usages fdcu,
90: fnd_documents fd,
91: fnd_attached_documents fad,
92: fnd_attachment_functions af
93: WHERE fad.entity_name = l_entity_name
94: AND fad.pk1_value = l_pkey1
95: AND (l_pkey2 IS NULL
96: OR fad.pk2_value = l_pkey2)

Line 107: and exists (select 'x' from fnd_attachment_functions af

103: AND fad.document_id = fd.document_id
104: AND fd.category_id = fdcu.category_id
105: AND fdcu.attachment_function_id = af.attachment_function_id
106: AND fdcu.enabled_flag = 'Y'
107: and exists (select 'x' from fnd_attachment_functions af
108: where af.function_type = l2_function_type
109: AND af.function_name = l2_function_name
110: AND fdcu.attachment_function_id = af.attachment_function_id)
111: AND ROWNUM = 1;

Line 164: 'fnd_attachment_functions af,'||

160:
161: l_sql_stmt := 'SELECT ''Y'' FROM dual WHERE EXISTS ('||
162: 'SELECT 1 FROM fnd_attached_documents fad,'||
163: 'fnd_doc_category_usages fdcu,'||
164: 'fnd_attachment_functions af,'||
165: 'fnd_documents fd '||
166: 'WHERE fad.entity_name = :ename '||
167: 'AND fad.document_id = fd.document_id '||
168: 'AND fd.category_id = fdcu.category_id '||

Line 260: FROM fnd_attachment_functions

256:
257: -- get attachment definition tied to function
258: SELECT count(*)
259: INTO m_rowcount
260: FROM fnd_attachment_functions
261: WHERE function_name = l_function_name
262: AND function_type = 'F';
263:
264: IF (m_rowcount > 0) THEN

Line 278: FROM fnd_attachment_functions

274: SELECT function_name,
275: count(*)
276: INTO m_function_name,
277: m_rowcount
278: FROM fnd_attachment_functions
279: WHERE function_type = 'O'
280: AND (function_name, application_id) =
281: (SELECT distinct ff.form_name, ff.application_id
282: FROM fnd_form ff,

Line 329: FROM fnd_attachment_functions

325: BEGIN
326: -- get attachment definition tied to function
327: SELECT enabled_flag,session_context_field
328: INTO m_enabled_flag,m_session_context_field
329: FROM fnd_attachment_functions
330: WHERE function_name = l_function_name
331: AND function_type = 'F';
332:
333: IF (m_enabled_flag = 'Y') THEN

Line 364: FROM fnd_attachment_functions

360: session_context_field
361: INTO m_function_name,
362: m_enabled_flag,
363: m_session_context_field
364: FROM fnd_attachment_functions
365: WHERE function_type = 'O'
366: AND (function_name, application_id) =
367: (SELECT distinct ff.form_name, ff.application_id
368: FROM fnd_form ff,