DBA Data[Home] [Help]

PACKAGE: APPS.AMS_ACT_LISTS_PKG

Source


1 PACKAGE AMS_ACT_LISTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amstalss.pls 115.7 2003/05/08 20:55:40 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_ACT_LISTS_PKG
7 -- Purpose
8 -- History
9 -- NOTE
10 -- End of Comments
11 -- ===============================================================
12 
13 PROCEDURE Insert_Row(
14           px_act_list_header_id   IN OUT NOCOPY NUMBER,
15           p_last_update_date    DATE,
16           p_last_updated_by    NUMBER,
17           p_creation_date    DATE,
18           p_created_by    NUMBER,
19           px_object_version_number   IN OUT NOCOPY NUMBER,
20           p_last_update_login    NUMBER,
21           p_list_header_id    NUMBER,
22           p_group_code        VARCHAR2,
23           p_list_used_by_id    NUMBER,
24           p_list_used_by    VARCHAR2,
25           p_list_act_type   VARCHAR2,
26           p_list_action_type   VARCHAR2,
27   	  p_order_number   NUMBER
28           );
29 
30 PROCEDURE Update_Row(
31           p_act_list_header_id    NUMBER,
32           p_last_update_date    DATE,
33           p_last_updated_by    NUMBER,
34           p_creation_date    DATE,
35           p_created_by    NUMBER,
36           p_object_version_number    NUMBER,
37           p_last_update_login    NUMBER,
38           p_list_header_id    NUMBER,
39           p_group_code        VARCHAR2,
40           p_list_used_by_id    NUMBER,
41           p_list_used_by    VARCHAR2,
42           p_list_act_type   VARCHAR2,
43 	  p_list_action_type   VARCHAR2,
44   	  p_order_number   NUMBER
45           );
46 
47 PROCEDURE Delete_Row(
48     p_ACT_LIST_HEADER_ID  NUMBER);
49 PROCEDURE Lock_Row(
50           p_act_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_object_version_number    NUMBER,
56           p_last_update_login    NUMBER,
57           p_list_header_id    NUMBER,
58           p_group_code        VARCHAR2,
59           p_list_used_by_id    NUMBER,
60           p_list_used_by    VARCHAR2,
61           p_list_act_type   VARCHAR2,
62 	  p_list_action_type   VARCHAR2,
63 	  p_order_number   NUMBER
64           );
65 
66 END AMS_ACT_LISTS_PKG;