PACKAGE: APPS.AMS_CTDS_PKG

Source

1 PACKAGE AMS_CTDS_PKG AS
2 /* $Header: amstctds.pls 120.1 2005/06/03 12:43:08 appldev  $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_CTDS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 
16 PROCEDURE Insert_Row(
17           px_ctd_id   IN OUT NOCOPY NUMBER,
18           p_action_id    NUMBER,
19           p_forward_url    VARCHAR2,
20           p_track_url    VARCHAR2,
21           p_activity_product_id    NUMBER,
22           p_activity_offer_id    NUMBER,
23           px_object_version_number   IN OUT NOCOPY NUMBER,
24           p_last_update_date    DATE,
25           p_last_updated_by    NUMBER,
26           p_creation_date    DATE,
27           p_created_by    NUMBER,
28           p_last_update_login    NUMBER,
29           p_security_group_id    NUMBER);
30 
31 PROCEDURE Update_Row(
32           p_ctd_id    NUMBER,
33           p_action_id    NUMBER,
34           p_forward_url    VARCHAR2,
35           p_track_url    VARCHAR2,
36           p_activity_product_id    NUMBER,
37           p_activity_offer_id    NUMBER,
38           p_object_version_number    NUMBER,
39           p_last_update_date    DATE,
40           p_last_updated_by    NUMBER,
41           p_creation_date    DATE,
42           p_created_by    NUMBER,
43           p_last_update_login    NUMBER,
44           p_security_group_id    NUMBER);
45 
46 PROCEDURE Delete_Row(
47     p_CTD_ID  NUMBER);
48 
49 PROCEDURE Lock_Row(
50           p_ctd_id    NUMBER,
51           p_action_id    NUMBER,
52           p_forward_url    VARCHAR2,
53           p_track_url    VARCHAR2,
54           p_activity_product_id    NUMBER,
55           p_activity_offer_id    NUMBER,
56           p_object_version_number    NUMBER,
57           p_last_update_date    DATE,
58           p_last_updated_by    NUMBER,
59           p_creation_date    DATE,
60           p_created_by    NUMBER,
61           p_last_update_login    NUMBER,
62           p_security_group_id    NUMBER);
63 
64 procedure LOAD_ROW(
65 	X_CTD_ID IN NUMBER,
66 	X_ACTION_ID IN NUMBER,
67 	X_FORWARD_URL IN VARCHAR2,
68 	X_TRACK_URL IN VARCHAR2,
69 	X_ACTIVITY_PRODUCT_ID IN NUMBER,
70 	X_ACTIVITY_OFFER_ID IN NUMBER,
71 	X_OWNER in  VARCHAR2,
72 	X_CUSTOM_MODE in VARCHAR2
73 );
74 
75 
76 PROCEDURE TRANSLATE_ROW (
77 	X_CTD_ID IN NUMBER,
78 	X_OWNER IN VARCHAR2,
79 	X_CUSTOM_MODE IN VARCHAR2
80 );
81 
82 END AMS_CTDS_PKG;