DBA Data[Home] [Help]

PACKAGE: APPS.AMS_ATTACHMENT_PVT_W

Source


1 package ams_attachment_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswatcs.pls 115.4 2003/05/06 12:47:34 mayjain ship $ */
3   procedure create_fnd_attachment(p_api_version_number  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status out nocopy  VARCHAR2
8     , x_msg_count out nocopy  NUMBER
9     , x_msg_data out nocopy  VARCHAR2
10     , x_document_id out nocopy  NUMBER
11     , x_attached_document_id out nocopy  NUMBER
12     , p7_a0  VARCHAR2 := fnd_api.g_miss_char
13     , p7_a1  NUMBER := 0-1962.0724
14     , p7_a2  NUMBER := 0-1962.0724
15     , p7_a3  NUMBER := 0-1962.0724
16     , p7_a4  NUMBER := 0-1962.0724
17     , p7_a5  VARCHAR := fnd_api.g_miss_char
18     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
19     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
20     , p7_a8  NUMBER := 0-1962.0724
21     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a10  NUMBER := 0-1962.0724
23     , p7_a11  NUMBER := 0-1962.0724
24     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
25     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
26     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
27     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
28     , p7_a16  DATE := fnd_api.g_miss_date
29     , p7_a17  NUMBER := 0-1962.0724
30     , p7_a18  DATE := fnd_api.g_miss_date
31     , p7_a19  NUMBER := 0-1962.0724
32     , p7_a20  NUMBER := 0-1962.0724
33     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
34     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
35     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
36     , p7_a24  DATE := fnd_api.g_miss_date
37   );
38   procedure update_fnd_attachment(p_api_version_number  NUMBER
39     , p_init_msg_list  VARCHAR2
40     , p_commit  VARCHAR2
41     , p_validation_level  NUMBER
42     , x_return_status out nocopy  VARCHAR2
43     , x_msg_count out nocopy  NUMBER
44     , x_msg_data out nocopy  VARCHAR2
45     , p7_a0  VARCHAR2 := fnd_api.g_miss_char
46     , p7_a1  NUMBER := 0-1962.0724
47     , p7_a2  NUMBER := 0-1962.0724
48     , p7_a3  NUMBER := 0-1962.0724
49     , p7_a4  NUMBER := 0-1962.0724
50     , p7_a5  VARCHAR := fnd_api.g_miss_char
51     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
52     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
53     , p7_a8  NUMBER := 0-1962.0724
54     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
55     , p7_a10  NUMBER := 0-1962.0724
56     , p7_a11  NUMBER := 0-1962.0724
57     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
58     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
59     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
60     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
61     , p7_a16  DATE := fnd_api.g_miss_date
62     , p7_a17  NUMBER := 0-1962.0724
63     , p7_a18  DATE := fnd_api.g_miss_date
64     , p7_a19  NUMBER := 0-1962.0724
65     , p7_a20  NUMBER := 0-1962.0724
66     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
68     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a24  DATE := fnd_api.g_miss_date
70   );
71 end ams_attachment_pvt_w;