PACKAGE: APPS.AMS_LIST_CONT_RESTRICTIONS_PKG

Source

1 PACKAGE AMS_LIST_CONT_RESTRICTIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstascs.pls 120.0 2005/05/31 16:58:03 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_LIST_CONT_RESTRICTIONS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_list_cont_restrictions_id   IN OUT NOCOPY NUMBER,
18           p_list_header_id    NUMBER,
19           p_last_update_date    DATE,
20           p_last_updated_by    NUMBER,
21           p_creation_date    DATE,
22           p_created_by    NUMBER,
23           p_last_update_login    NUMBER,
24           px_object_version_number   IN OUT NOCOPY NUMBER,
25           p_do_not_contact_flag    VARCHAR2,
26           p_media_id    NUMBER,
27           p_list_used_by    VARCHAR2,
28           p_list_used_by_id    NUMBER
29           );
30 
31 PROCEDURE Update_Row(
32           p_list_cont_restrictions_id    NUMBER,
33           p_list_header_id    NUMBER,
34           p_last_update_date    DATE,
35           p_last_updated_by    NUMBER,
36           p_creation_date    DATE,
37           p_created_by    NUMBER,
38           p_last_update_login    NUMBER,
39           p_object_version_number    NUMBER,
40           p_do_not_contact_flag    VARCHAR2,
41           p_media_id    NUMBER,
42           p_list_used_by    VARCHAR2,
43           p_list_used_by_id    NUMBER
44           );
45 
46 PROCEDURE Delete_Row(
47     p_list_cont_restrictions_id  NUMBER);
48 PROCEDURE Lock_Row(
49           p_list_cont_restrictions_id    NUMBER,
50           p_list_header_id    NUMBER,
51           p_last_update_date    DATE,
52           p_last_updated_by    NUMBER,
53           p_creation_date    DATE,
54           p_created_by    NUMBER,
55           p_last_update_login    NUMBER,
56           p_object_version_number    NUMBER,
57           p_do_not_contact_flag    VARCHAR2,
58           p_media_id    NUMBER,
59           p_list_used_by    VARCHAR2,
60           p_list_used_by_id    NUMBER
61           );
62 
63 PROCEDURE LOAD_ROW(
64           p_owner    VARCHAR2,
65           p_list_cont_restrictions_id    NUMBER,
66           p_list_header_id    NUMBER,
67           p_last_update_date    DATE,
68           p_last_updated_by    NUMBER,
69           p_creation_date    DATE,
70           p_created_by    NUMBER,
71           p_last_update_login    NUMBER,
72           p_object_version_number    NUMBER,
73           p_do_not_contact_flag    VARCHAR2,
74           p_media_id    NUMBER,
75           p_list_used_by    VARCHAR2,
76           p_list_used_by_id    NUMBER,
77           p_custom_mode    VARCHAR2
78 
79           );
80 
81 END AMS_LIST_CONT_RESTRICTIONS_PKG;