[Home] [Help]
PACKAGE: APPS.AMS_SCHEDULER_PVT
Source
1 PACKAGE AMS_Scheduler_PVT AS
2 /* $Header: amsvrpts.pls 120.0 2005/06/01 03:39:23 appldev noship $ */
3
4 --========================================================================
5 -- PROCEDURE
6 -- WRITE_LOG
7 -- Purpose
8 -- This method will be used to write logs for this api
9 -- HISTORY
10 -- 10-Oct-2000 dbiswas Created.
11 --
12 --========================================================================
13 PROCEDURE WRITE_LOG ( p_api_name IN VARCHAR2,
14 p_log_message IN VARCHAR2 );
15
16 --========================================================================
17 -- PROCEDURE
18 -- Schedule_repeat
19 -- Purpose
20 -- Created to get the schedule next run
21 -- HISTORY
22 -- 10-Oct-2000 dbiswas Created.
23 --
24 --========================================================================
25 PROCEDURE Schedule_Repeat ( p_last_run_date IN DATE,
26 p_frequency IN NUMBER,
27 p_frequency_type IN VARCHAR2,
28 x_next_run_date OUT NOCOPY DATE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2);
32
33
34
35 --========================================================================
36 --PROCEDURE
37 -- Create_Next_Schedule
38 -- Purpose
39 -- This package creates the next schedule to be used by the workflow
40 -- HISTORY
41 -- 10-Oct-2000 dbiswas Created.
42 --
43 --========================================================================
44
45 PROCEDURE Create_Next_Schedule ( p_parent_sched_id IN NUMBER,
46 p_child_sched_st_date IN DATE,
47 p_child_sched_en_date IN DATE,
48 x_child_sched_id OUT NOCOPY NUMBER,
49 -- soagrawa added on 18-feb-2004 for bug# 3452264
50 p_orig_sch_name IN VARCHAR2 DEFAULT NULL,
51 p_trig_repeat_flag IN VARCHAR2 DEFAULT 'N',
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 --========================================================================
58 --PROCEDURE
59 -- Create_Scheduler
60 -- Purpose
61 -- This procedure creates a row in the ams_scheduler table using the table handler package
62 -- HISTORY
63 -- 04-may-2005 soagrawa Created.
64 --
65 --========================================================================
66
67 PROCEDURE Create_Scheduler ( p_obj_type VARCHAR2,
68 p_obj_id NUMBER,
69 p_freq NUMBER,
70 p_freq_type VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_scheduler_id OUT NOCOPY NUMBER
75 );
76
77
78 END AMS_Scheduler_PVT ;