1 PACKAGE JTA_TASK_EXCLUSIONS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtavsems.pls 115.3 2002/05/13 10:01:28 pkm ship $ */
3 /*=======================================================================+
4 | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | jtavstms.pls |
9 | |
10 | DESCRIPTION |
11 | - This package is used to insert/update/delete sync task |
12 | mapping record. |
13 | |
14 | NOTES |
15 | |
16 | Date Developer Change |
17 | SSALLAKA 3/13/02 created
18 -- --------- ------ -------------------------------------------------*/
19
20 --
21 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
22 -- directory of SQL Navigator
23 --
24 -- Purpose: Briefly explain the functionality of the package
25 --
26 -- MODIFICATION HISTORY
27 -- Person Date Comments
28 -- SSALLAKA 03/13/2002 Created
29 -- --------- ------ ------------------------------------------
30 -- Enter package declarations as shown below
31
32 ---------------------------------------------------------------------
33 -- Start of comments
34 -- API name : Insert_Row
35 -- Type : Public
36 -- Function : Insert the Exclusion Data into Task_exclusion
37 -- table.
38 -- Pre-reqs : None.
39 --
40 -- Notes:
41 --
42 -- End of comments
43 ---------------------------------------------------------------------
44 PROCEDURE Insert_Row (
45 p_task_exclusion_id IN NUMBER,
46 p_task_id IN NUMBER,
47 p_recurrence_rule_id IN NUMBER,
48 p_exclusion_date IN DATE,
49 p_created_by IN NUMBER DEFAULT NULL,
50 p_creation_date IN DATE DEFAULT NULL,
51 p_last_updated_by IN NUMBER DEFAULT NULL,
52 p_last_update_date IN DATE DEFAULT NULL,
53 p_last_update_login IN NUMBER DEFAULT NULL,
54 p_security_group_id IN NUMBER DEFAULT NULL
55 );
56
57
58 ---------------------------------------------------------------------
59 -- Start of comments
60 -- API name : Update_Row
61 -- Type : Public
62 -- Function : Update a record with task_exclusion_id
63 -- Pre-reqs : None.
64 --
65 -- Notes:
66 --
67 -- End of comments
68 ---------------------------------------------------------------------
69 PROCEDURE Update_Row (
70 p_task_exclusion_id IN NUMBER,
71 p_task_id IN NUMBER,
72 p_recurrence_rule_id IN NUMBER,
73 p_exclusion_date IN DATE,
74 p_last_updated_by IN NUMBER DEFAULT NULL,
75 p_last_update_date IN DATE DEFAULT NULL,
76 p_last_update_login IN NUMBER DEFAULT NULL
77 );
78
79 ---------------------------------------------------------------------
80 -- Start of comments
81 -- API name : Delete_Row
82 -- Type : Public
83 -- Function : Delete a record with task_exclusion_id
84 --
85 -- Notes:
86 --
87 -- End of comments
88 ---------------------------------------------------------------------
89 PROCEDURE Delete_Row (
90 p_task_exclusion_id IN NUMBER
91 );
92
93 END JTA_TASK_EXCLUSIONS_PKG;