[Home] [Help]
PACKAGE: APPS.AML_MONITOR_CONDITIONS_PUB
Source
1 PACKAGE AML_MONITOR_CONDITIONS_PUB AUTHID CURRENT_USER as
2 /* $Header: amlplmcs.pls 115.1 2002/12/06 04:56:21 ajchatto noship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEADS_PUB
5 -- Purpose : Sales Leads Monitor
6 -- NOTE :
7 -- History :
8 -- 11/23/2002 AJCHATTO Created.
9 -- End of Comments
10
11 TYPE CONDITION_Rec_Type IS RECORD
12 (
13 MONITOR_CONDITION_ID NUMBER := FND_API.G_MISS_NUM
14 , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15 , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16 , CREATION_DATE DATE := FND_API.G_MISS_DATE
17 , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18 , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19 , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20 , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21 , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22 , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23 , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24 , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25 , MONITOR_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
26 , TIME_LAG_NUM NUMBER := FND_API.G_MISS_NUM
27 , TIME_LAG_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
28 , TIME_LAG_FROM_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
29 , TIME_LAG_TO_STAGE VARCHAR2(100) := FND_API.G_MISS_CHAR
30 , Expiration_Relative varchar2(1) := FND_API.G_MISS_CHAR
31 , Reminder_Defined varchar2(1) := FND_API.G_MISS_CHAR
32 , Total_Reminders number := FND_API.G_MISS_NUM
33 , Reminder_Frequency number := FND_API.G_MISS_NUM
34 , Reminder_Freq_uom_code varchar2(30) := FND_API.G_MISS_CHAR
35 , Timeout_Defined varchar2(10) := FND_API.G_MISS_CHAR
36 , Timeout_Duration number := FND_API.G_MISS_NUM
37 , Timeout_uom_code varchar2(30) := FND_API.G_MISS_CHAR
38 , Notify_Owner VARCHAR2(1) := FND_API.G_MISS_CHAR
39 , Notify_Owner_Manager VARCHAR2(1) := FND_API.G_MISS_CHAR
40 , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
41 , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
42 , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
43 , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
44 , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
45 , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
46 , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
47 , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
48 , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
49 , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
50 , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
51 , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
52 , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
53 , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
54 , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
55 , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
56 );
57
58 G_MISS_CONDITION_REC CONDITION_Rec_Type;
59
60 -- *******************************************************
61 -- Start of Comments
62 -- *******************************************************
63 -- API Name: Create_monitor_condition
64 -- Type : Private
65 -- Pre-Req :
66 -- Parameters:
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
73 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
74 -- p_admin_group_id IN NUMBER Required
75 -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
76 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
77 --
78 -- OUT:
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 2.0
83 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
84 -- and basic operation, developer must manually add parameters and business logic as necessary.
85 --
86 -- End of Comments
87 --
88 PROCEDURE Create_monitor_condition(
89 P_Api_Version_Number IN NUMBER,
90 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 P_Identity_Resource_Id IN NUMBER,
94 P_CONDITION_Rec IN CONDITION_Rec_Type := G_MISS_CONDITION_REC,
95 X_MONITOR_CONDITION_ID OUT NOCOPY NUMBER,
96 X_Return_Status OUT NOCOPY VARCHAR2,
97 X_Msg_Count OUT NOCOPY NUMBER,
98 X_Msg_Data OUT NOCOPY VARCHAR2
99 );
100
101 -- *******************************************************
102 -- Start of Comments
103 -- *******************************************************
104 -- API Name: Update_monitor_condition
105 -- Type : Private
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_admin_group_id IN NUMBER Required
116 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117 -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
118 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
119 --
120 -- OUT:
121 -- x_return_status OUT VARCHAR2
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2
124 -- Version : Current version 2.0
125 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
126 -- and basic operation, developer must manually add parameters and business logic as necessary.
127 --
128 -- End of Comments
129 --
130 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
131 PROCEDURE Update_monitor_condition(
132 P_Api_Version_Number IN NUMBER,
133 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136 p_identity_salesforce_id IN NUMBER,
137 P_CONDITION_Rec IN CONDITION_Rec_Type,
138 X_Return_Status OUT NOCOPY VARCHAR2,
139 X_Msg_Count OUT NOCOPY NUMBER,
140 X_Msg_Data OUT NOCOPY VARCHAR2
141 );
142
143 -- *******************************************************
144 -- Start of Comments
145 -- *******************************************************
146 -- API Name: Delete_monitor_condition
147 -- Type : Private
148 -- Pre-Req :
149 -- Parameters:
150 -- IN
151 -- p_api_version_number IN NUMBER Required
152 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
153 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
154 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
155 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
157 -- p_admin_group_id IN NUMBER Required
158 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
159 -- P_CONDITION_Rec IN CONDITION_Rec_Type Required
160 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
161 --
162 -- OUT:
163 -- x_return_status OUT VARCHAR2
164 -- x_msg_count OUT NUMBER
165 -- x_msg_data OUT VARCHAR2
166 -- Version : Current version 2.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 --
172 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
173 -- The Master delete procedure may not be needed depends on different business requirements.
174 PROCEDURE Delete_monitor_condition(
175 P_Api_Version_Number IN NUMBER,
176 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
177 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 p_identity_salesforce_id IN NUMBER,
180 P_CONDITION_Rec IN CONDITION_Rec_Type,
181 X_Return_Status OUT NOCOPY VARCHAR2,
182 X_Msg_Count OUT NOCOPY NUMBER,
183 X_Msg_Data OUT NOCOPY VARCHAR2
184 );
185
186
187 End AML_MONITOR_CONDITIONS_PUB;