[Home] [Help]
PACKAGE: APPS.AMS_SCHEDULER_B_PKG
Source
1 PACKAGE AMS_SCHEDULER_B_PKG AUTHID CURRENT_USER 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;