PACKAGE: APPS.AMS_CONTENT_RULES_B_PKG

Source

1 PACKAGE AMS_CONTENT_RULES_B_PKG AS
2 /* $Header: amstctrs.pls 120.2 2006/05/30 11:10:43 prageorg noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_CONTENT_RULES_B_PKG
7 -- Purpose
8 --
9 -- History
10 --      28-mar-2003   soagrawa    Added add_language. Bug# 2876033
11 --      29-May-2005   prageorg    Added column delivery_mode.
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 
18 PROCEDURE Insert_Row(
19           px_content_rule_id   IN OUT NOCOPY NUMBER,
20           p_created_by    NUMBER,
21           p_creation_date    DATE,
22           p_last_updated_by    NUMBER,
23           p_last_updated_date    DATE,
24           p_last_update_login    NUMBER,
25           px_object_version_number   IN OUT NOCOPY NUMBER,
26           p_object_type    VARCHAR2,
27           p_object_id    NUMBER,
28           p_sender    VARCHAR2,
29           p_reply_to    VARCHAR2,
30           p_cover_letter_id    NUMBER,
31           p_table_of_content_flag    VARCHAR2,
32           p_trigger_code    VARCHAR2,
33           p_enabled_flag    VARCHAR2,
34 	  p_subject         VARCHAR2,
35 	  p_sender_display_name    VARCHAR2,--anchaudh
36 	  p_delivery_mode  VARCHAR2); --prageorg
37 
38 PROCEDURE Update_Row(
39           p_content_rule_id    NUMBER,
40           p_created_by    NUMBER,
41           p_creation_date    DATE,
42           p_last_updated_by    NUMBER,
43           p_last_updated_date    DATE,
44           p_last_update_login    NUMBER,
45           p_object_version_number    NUMBER,
46           p_object_type    VARCHAR2,
47           p_object_id    NUMBER,
48           p_sender    VARCHAR2,
49           p_reply_to    VARCHAR2,
50           p_cover_letter_id    NUMBER,
51           p_table_of_content_flag    VARCHAR2,
52           p_trigger_code    VARCHAR2,
53           p_enabled_flag    VARCHAR2,
54 	  p_subject         VARCHAR2,
55 	  p_sender_display_name    VARCHAR2,--anchaudh
56 	  p_delivery_mode  VARCHAR2);--prageorg
57 
58 PROCEDURE Delete_Row(
59     p_CONTENT_RULE_ID  NUMBER);
60 
61 PROCEDURE Lock_Row(
62           p_content_rule_id    NUMBER,
63           p_created_by    NUMBER,
64           p_creation_date    DATE,
65           p_last_updated_by    NUMBER,
66           p_last_updated_date    DATE,
67           p_last_update_login    NUMBER,
68           p_object_version_number    NUMBER,
69           p_object_type    VARCHAR2,
70           p_object_id    NUMBER,
71           p_sender    VARCHAR2,
72           p_reply_to    VARCHAR2,
73           p_cover_letter_id    NUMBER,
74           p_table_of_content_flag    VARCHAR2,
75           p_trigger_code    VARCHAR2,
76           p_enabled_flag    VARCHAR2,
77 	  p_subject         VARCHAR2,
78 	  p_sender_display_name    VARCHAR2,--anchaudh
79 	  p_delivery_mode  VARCHAR2);--prageorg
80 
81 PROCEDURE ADD_LANGUAGE;
82 
83 END AMS_CONTENT_RULES_B_PKG;