1 PACKAGE fnd_attached_documents2_pkg AUTHID CURRENT_USER as
2 /* $Header: AFAKATDS.pls 120.2 2011/11/16 20:56:19 ctilley ship $ */
3
4
5 -- API to delete attachments for a given entity
6 PROCEDURE delete_attachments(X_entity_name IN VARCHAR2,
7 X_pk1_value IN VARCHAR2,
8 X_pk2_value IN VARCHAR2 DEFAULT NULL,
9 X_pk3_value IN VARCHAR2 DEFAULT NULL,
10 X_pk4_value IN VARCHAR2 DEFAULT NULL,
11 X_pk5_value IN VARCHAR2 DEFAULT NULL,
12 X_delete_document_flag IN VARCHAR2 DEFAULT 'N',
13 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL);
14
15
16
17 -- API to copy attachments from one record to another
18 -- BUG#2790775
19 -- Added the default parameters X_from_category_id and X_to_category_id
20 PROCEDURE copy_attachments(X_from_entity_name IN VARCHAR2,
21 X_from_pk1_value IN VARCHAR2,
22 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
23 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
24 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
25 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
26 X_to_entity_name IN VARCHAR2,
27 X_to_pk1_value IN VARCHAR2,
28 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
29 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
30 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
31 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
32 X_created_by IN NUMBER DEFAULT NULL,
33 X_last_update_login IN NUMBER DEFAULT NULL,
34 X_program_application_id IN NUMBER DEFAULT NULL,
35 X_program_id IN NUMBER DEFAULT NULL,
36 X_request_id IN NUMBER DEFAULT NULL,
37 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
38 X_from_category_id IN NUMBER DEFAULT NULL,
39 X_to_category_id IN NUMBER DEFAULT NULL);
40
41 -- API to copy attachments from one record to another and store the originating
42 -- document_id and attached_document_id.
43 -- bug 12910292 - added x_orig_doc_id
44 PROCEDURE copy_attachments(X_from_entity_name IN VARCHAR2,
45 X_from_pk1_value IN VARCHAR2,
46 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
47 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
48 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
49 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
50 X_to_entity_name IN VARCHAR2,
51 X_to_pk1_value IN VARCHAR2,
52 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
53 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
54 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
55 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
56 X_created_by IN NUMBER DEFAULT NULL,
57 X_last_update_login IN NUMBER DEFAULT NULL,
58 X_program_application_id IN NUMBER DEFAULT NULL,
59 X_program_id IN NUMBER DEFAULT NULL,
60 X_request_id IN NUMBER DEFAULT NULL,
61 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
62 X_from_category_id IN NUMBER DEFAULT NULL,
63 X_to_category_id IN NUMBER DEFAULT NULL,
64 X_orig_attach_doc_id IN NUMBER);
65
66
67 END fnd_attached_documents2_pkg;