DBA Data[Home] [Help]

PACKAGE: APPS.ASO_ATTACHMENT_INT

Source


1 PACKAGE ASO_ATTACHMENT_INT AS
2 /* $Header: asoiatms.pls 120.1 2005/06/29 12:32:35 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_ATTACHMENT_INT
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Add_Attachment(
11   p_api_version_number    IN  NUMBER
12   ,p_init_msg_list        IN  VARCHAR2 := FND_API.G_FALSE
13   ,p_commit               IN  VARCHAR2 := FND_API.G_FALSE
14   ,p_seq_num              IN  VARCHAR2
15   ,p_category_id          IN  VARCHAR2
16   ,p_document_description IN  VARCHAR2
17   ,p_datatype_id          IN  VARCHAR2
18   ,p_text		  IN  LONG
19   ,p_file_name		  IN  VARCHAR2
20   ,p_url	          IN  VARCHAR2
21   ,p_function_name	  IN  VARCHAR2 := null
22   ,p_quote_header_id      IN  NUMBER
23   ,p_media_id		  IN  NUMBER
24   ,x_return_status        OUT NOCOPY /* file.sql.39 change */  VARCHAR2
25   ,x_msg_count            OUT NOCOPY /* file.sql.39 change */  NUMBER
26   ,x_msg_data             OUT NOCOPY /* file.sql.39 change */  VARCHAR2
27 );
28 
29 
30 PROCEDURE copy_attachments_to_order(
31    p_api_version_number   IN  NUMBER
32    ,p_init_msg_list       IN  VARCHAR2 := FND_API.g_false
33    ,p_commit              IN  VARCHAR2 := FND_API.g_false
34    ,p_quote_header_id     IN  number
35    ,p_order_id            IN  number
36    ,p_order_line_tbl      IN  ASO_ORDER_INT.Order_Line_Tbl_Type
37    ,x_return_status       OUT NOCOPY /* file.sql.39 change */  VARCHAR2
38    ,x_msg_count           OUT NOCOPY /* file.sql.39 change */  NUMBER
39    ,x_msg_data            OUT NOCOPY /* file.sql.39 change */  VARCHAR2
40 );
41 
42 
43 PROCEDURE delete_attachments(
44    p_api_version_number     IN  NUMBER
45    ,p_init_msg_list         IN  VARCHAR2 := FND_API.g_false
46    ,p_commit                IN  VARCHAR2 := FND_API.g_false
47    ,p_quote_header_id       IN  NUMBER
48    ,p_quote_attachment_ids  IN  JTF_VARCHAR2_TABLE_100
49    ,x_return_status         OUT NOCOPY /* file.sql.39 change */  VARCHAR2
50    ,x_msg_count             OUT NOCOPY /* file.sql.39 change */  NUMBER
51    ,x_msg_data              OUT NOCOPY /* file.sql.39 change */  VARCHAR2
52 );
53 
54 PROCEDURE Copy_Attachments
55 (
56    p_api_version         IN  NUMBER                     ,
57    p_init_msg_list       IN  VARCHAR2 := FND_API.G_TRUE ,
58    p_commit              IN  VARCHAR2 := FND_API.G_FALSE,
59    p_old_object_code     IN  VARCHAR2                   ,
60    p_new_object_code     IN  VARCHAR2                   ,
61    p_old_object_id       IN  NUMBER                     ,
62    p_new_object_id       IN  NUMBER                     ,
63    x_return_status       OUT NOCOPY /* file.sql.39 change */  VARCHAR2            ,
64    x_msg_count           OUT NOCOPY /* file.sql.39 change */  NUMBER              ,
65    x_msg_data            OUT NOCOPY /* file.sql.39 change */  VARCHAR2
66 );
67 
68 END ASO_ATTACHMENT_INT;