1 PACKAGE fnd_attached_documents2_pkg AUTHID CURRENT_USER as
2 /* $Header: AFAKATDS.pls 115.9 2003/12/17 18:29:46 blash 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
42 END fnd_attached_documents2_pkg;
[Home] [Help]