PACKAGE: APPS.FND_ATTACHMENT_UTIL_PKG

Source

1 PACKAGE fnd_attachment_util_pkg AUTHID CURRENT_USER as
2 /* $Header: AFAKUTLS.pls 115.8 2004/02/16 23:34:11 blash ship $ */
3 
4 
5   FUNCTION get_atchmt_exists(l_entity_name VARCHAR2,
6                              l_pkey1 VARCHAR2,
7                              l_pkey2 VARCHAR2 DEFAULT NULL,
8                              l_pkey3 VARCHAR2 DEFAULT NULL,
9                              l_pkey4 VARCHAR2 DEFAULT NULL,
10                              l_pkey5 VARCHAR2 DEFAULT NULL,
11 			     l_function_name VARCHAR2 DEFAULT NULL,
12 			     l_function_type VARCHAR2 DEFAULT NULL)
13  RETURN VARCHAR2;
14   PRAGMA RESTRICT_REFERENCES (get_atchmt_exists, WNDS, WNPS);
15 
16   FUNCTION get_atchmt_exists_sql(l_entity_name VARCHAR2,
17                              l_pkey1 VARCHAR2,
18                              l_pkey2 VARCHAR2 DEFAULT NULL,
19                              l_pkey3 VARCHAR2 DEFAULT NULL,
20                              l_pkey4 VARCHAR2 DEFAULT NULL,
21                              l_pkey5 VARCHAR2 DEFAULT NULL,
22 			     l_sqlstmt VARCHAR2 DEFAULT NULL,
23 			     l_function_name VARCHAR2 DEFAULT NULL,
24 			     l_function_type VARCHAR2 DEFAULT NULL)
25   RETURN VARCHAR2;
26 
27 
28 PROCEDURE init_atchmt(l_function_name IN OUT NOCOPY VARCHAR2,
29 	       attachments_defined_flag OUT NOCOPY BOOLEAN,
30 		l_function_type IN OUT NOCOPY VARCHAR2);
31 
32 PROCEDURE init_atchmt(l_function_name IN OUT NOCOPY VARCHAR2,
33 	       attachments_defined_flag OUT NOCOPY BOOLEAN,
34 		l_enabled_flag OUT NOCOPY VARCHAR2,
35 		l_session_context_field OUT NOCOPY VARCHAR2,
36 		l_function_type OUT NOCOPY VARCHAR2);
37 
38 PROCEDURE init_form(X_entity_name IN VARCHAR2,
39 		    X_user_entity_name OUT NOCOPY VARCHAR2,
40 		    X_doc_type_meaning OUT NOCOPY VARCHAR2);
41 
42 PROCEDURE init_doc_form(X_category_name IN VARCHAR2 DEFAULT NULL,
43 			X_category_id OUT NOCOPY NUMBER,
44 			X_category_desc OUT NOCOPY VARCHAR2,
45 			X_security_type IN NUMBER DEFAULT NULL,
46 			X_security_id IN NUMBER DEFAULT NULL,
47 			X_security_desc OUT NOCOPY VARCHAR2);
48 
49 FUNCTION get_atchmt_function_name RETURN VARCHAR2;
50 
51 PROCEDURE update_file_metadata ( X_file_id IN NUMBER DEFAULT NULL );
52 
53 ----------------------------------------------------------------------------
54 -- MergeAttachments (PUBLIC)
55 --   This is the procedure being called during the Party Merge.
56 --   FND_ATTACHMENT_UTIL_PKG.MergeAttachments() has been registered
57 --   in Party Merge Data Dict.
58 --   The input/output arguments format matches the document PartyMergeDD.doc.
59 --
60 -- Usage example in pl/sql
61 --   This procedure should only be called from the PartyMerge utility.
62 --
63 procedure MergeAttachments(p_entity_name in varchar2,
64                         p_from_id in number,
65                         p_to_id in out nocopy number,
66                         p_from_fk_id in varchar2,
67                         p_to_fk_id in varchar2,
68                         p_parent_entity_name in varchar2,
69                         p_batch_id in number,
70                         p_batch_party_id in number,
71 			p_return_status in out nocopy varchar2);
72 
73 FUNCTION get_user_function_name(X_function_type IN VARCHAR2,
74 			        X_application_id IN NUMBER,
75 				X_function_name IN VARCHAR2)
76 	RETURN VARCHAR2;
77   PRAGMA RESTRICT_REFERENCES (get_user_function_name, WNDS, WNPS, RNPS);
78 
79 
80   --  package globals
81   function_name VARCHAR2(30) DEFAULT NULL;
82   function_type VARCHAR2(1) DEFAULT NULL;
83 
84 
85 
86 END fnd_attachment_util_pkg;