[Home] [Help]
PACKAGE: APPS.AHL_DI_SUBSCRIPTION_PVT
Source
1 PACKAGE AHL_DI_SUBSCRIPTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSUBS.pls 115.8 2002/12/03 12:32:29 pbarman noship $ */
3 -- Name : subscription_rec
4 -- Type : type definition, group
5 -- Description : Record to hold the attributes of the subscriptions
6
7 TYPE subscription_rec IS RECORD
8 (
9 SUBSCRIPTION_ID NUMBER ,
10 DOCUMENT_ID NUMBER ,
11 STATUS_CODE VARCHAR2(30) ,
12 REQUESTED_BY_PARTY_ID NUMBER ,
13 QUANTITY NUMBER ,
14 FREQUENCY_CODE VARCHAR2(30) ,
15 SUBSCRIBED_FRM_PARTY_ID NUMBER ,
16 START_DATE DATE ,
17 END_DATE DATE ,
18 PURCHASE_ORDER_NO VARCHAR2(20) ,
19 SUBSCRIPTION_TYPE_CODE VARCHAR2(30) ,
20 MEDIA_TYPE_CODE VARCHAR2(30) ,
21 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
22 ATTRIBUTE1 VARCHAR2(150) ,
23 ATTRIBUTE2 VARCHAR2(150) ,
24 ATTRIBUTE3 VARCHAR2(150) ,
25 ATTRIBUTE4 VARCHAR2(150) ,
26 ATTRIBUTE5 VARCHAR2(150) ,
27 ATTRIBUTE6 VARCHAR2(150) ,
28 ATTRIBUTE7 VARCHAR2(150) ,
29 ATTRIBUTE8 VARCHAR2(150) ,
30 ATTRIBUTE9 VARCHAR2(150) ,
31 ATTRIBUTE10 VARCHAR2(150) ,
32 ATTRIBUTE11 VARCHAR2(150) ,
33 ATTRIBUTE12 VARCHAR2(150) ,
34 ATTRIBUTE13 VARCHAR2(150) ,
35 ATTRIBUTE14 VARCHAR2(150) ,
36 ATTRIBUTE15 VARCHAR2(150) ,
37 LANGUAGE VARCHAR2(4) ,
38 SOURCE_LANG VARCHAR2(4) ,
39 COMMENTS VARCHAR2(2000),
40 OBJECT_VERSION_NUMBER NUMBER ,
41 DELETE_FLAG VARCHAR2(1) := 'N'
42 );
43 --Declare table type
44 TYPE subscription_tbl IS TABLE OF subscription_rec
45 INDEX BY BINARY_INTEGER;
46
47 -- Procedure to create subscription for an associated document
48 PROCEDURE CREATE_SUBSCRIPTION
49 (
50 p_api_version IN NUMBER := 1.0 ,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
54 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55 p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
56 x_return_status OUT NOCOPY VARCHAR2 ,
57 x_msg_count OUT NOCOPY NUMBER ,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60 -- Procedure to Modify subscription for an associated document
61 PROCEDURE MODIFY_SUBSCRIPTION
62 (
63 p_api_version IN NUMBER := 1.0 ,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
69 x_return_status OUT NOCOPY VARCHAR2 ,
70 x_msg_count OUT NOCOPY NUMBER ,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 -- Procedure to Delete subscription for an associated document(This is
74 -- not supported in this phase)
75 PROCEDURE DELETE_SUBSCRIPTION
76 (
77 p_api_version IN NUMBER := 1.0 ,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
80 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82 p_x_subscription_tbl IN OUT NOCOPY subscription_tbl ,
83 x_return_status OUT NOCOPY VARCHAR2 ,
84 x_msg_count OUT NOCOPY NUMBER ,
85 x_msg_data OUT NOCOPY VARCHAR2);
86
87 END AHL_DI_SUBSCRIPTION_PVT;