APPS.AMS_WFCMPAPR_PVT dependencies on STANDARD

Line 138: -- Standard Start of API savepoint

134: FROM DUAL;
135:
136: BEGIN
137:
138: -- Standard Start of API savepoint
139: SAVEPOINT Create_wfreq_PVT;
140:
141: IF (AMS_DEBUG_HIGH_ON) THEN
142:

Line 184: -- standard who columns

180:
181: INSERT INTO ams_act_wf_requests
182: (activity_wf_request_id
183:
184: -- standard who columns
185: ,last_update_date
186: ,last_updated_by
187: ,creation_date
188: ,created_by

Line 209: -- standard who columns

205: VALUES
206: (
207: l_wf_request_id
208:
209: -- standard who columns
210: ,sysdate
211: ,FND_GLOBAL.User_Id
212: ,sysdate
213: ,FND_GLOBAL.User_Id

Line 237: -- Standard call to get message count AND IF count is 1, get message info.

233: --
234:
235:
236: --
237: -- Standard call to get message count AND IF count is 1, get message info.
238: --
239: FND_MSG_PUB.Count_AND_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data,

Line 2933: l_priority := 'STANDARD' ;

2929: OPEN c_camp_priority ;
2930: FETCH c_camp_priority INTO l_priority ;
2931: CLOSE c_camp_priority ;
2932: ELSIF p_obj_type = 'DELV' THEN
2933: l_priority := 'STANDARD' ;
2934: ELSIF p_obj_type = 'EVEH' THEN
2935: OPEN c_eveh_priority ;
2936: FETCH c_eveh_priority INTO l_priority ;
2937: CLOSE c_eveh_priority ;

Line 2957: ELSIF l_priority = 'STANDARD' THEN

2953: l_prio := 99 ;
2954: ELSIF l_priority = 'MEDIUM' THEN
2955: l_timeout := l_timeout_rec.timeout_days_medium_prio ;
2956: l_prio := 50 ;
2957: ELSIF l_priority = 'STANDARD' THEN
2958: l_timeout := l_timeout_rec.timeout_days_std_prio ;
2959: l_prio := 50 ;
2960: ELSE
2961: l_timeout := l_timeout_rec.timeout_days_std_prio ;

Line 2967: -- x_priority := NVL(l_priority,'STANDARD') ;

2963: END IF;
2964:
2965:
2966: x_timeout_days := l_timeout ;
2967: -- x_priority := NVL(l_priority,'STANDARD') ;
2968: x_priority := l_prio ;
2969:
2970: END Find_Priority ;
2971: