PACKAGE: APPS.AMS_SCHEDULER_B_PKG

Source

1 PACKAGE AMS_SCHEDULER_B_PKG as
2 /* $Header: amstrpts.pls 120.0 2005/07/01 03:53:02 appldev noship $ */
3 
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 --          AMS_SCHEDULER_B_PKG
8 --
9 -- Purpose
10 --          Private api created to Update/insert/Delete the repeating schedule details.
11 --
12 -- History
13 --    05-may-2005    anchaudh    Created.
14 --
15 --
16 -- NOTE
17 --
18 -- End of Comments
19 -- ===============================================================
20 
21 
22 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_SCHEDULER_B_PKG';
23 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstrpts.pls';
24 
25 
26 
27 --  ========================================================
28 --
29 --  NAME
30 --     Insert_Row
31 --
32 --  HISTORY
33 --     05-may-2005    anchaudh    Created.
34 --  ========================================================
35 PROCEDURE Insert_Row(
36           px_scheduler_id   IN OUT NOCOPY NUMBER,
37           p_created_by    NUMBER,
38           p_creation_date    DATE,
39           p_last_updated_by    NUMBER,
40           p_last_update_date    DATE,
41           p_last_update_login    NUMBER,
42           px_object_version_number   IN OUT NOCOPY NUMBER,
43           p_object_type    VARCHAR2,
44           p_object_id    NUMBER,
45           p_frequency    NUMBER,
46           p_frequency_type    VARCHAR2);
47 
48 --  ========================================================
49 --
50 --  NAME
51 --     Update_Row
52 --
53 --  HISTORY
54 --    05-may-2005    anchaudh    Created.
55 --  ========================================================
56 
57 
58 PROCEDURE Update_Row(
59           p_scheduler_id  NUMBER,
60           p_created_by    NUMBER,
61           p_creation_date    DATE,
62           p_last_updated_by    NUMBER,
63           p_last_update_date    DATE,
64           p_last_update_login    NUMBER,
65           p_object_version_number  NUMBER,
66           p_object_type    VARCHAR2,
67           p_object_id    NUMBER,
68           p_frequency    NUMBER,
69           p_frequency_type    VARCHAR2);
70 --  ========================================================
71 --
72 --  NAME
73 --     Delete_Row
74 --
75 --  HISTORY
76 --     05-may-2005    anchaudh    Created.
77 --  ========================================================
78 
79 
80 PROCEDURE Delete_Row(
81     p_scheduler_id  NUMBER);
82 
83 --  ========================================================
84 --
85 --  NAME
86 --     Lock_Row
87 --
88 --  HISTORY
89 --     05-may-2005    anchaudh    Created.
90 --  ========================================================
91 
92 
93 PROCEDURE Lock_Row(
94           p_scheduler_id  NUMBER);
95 
96 
97 END AMS_SCHEDULER_B_PKG;