PACKAGE BODY: APPS.CAC_SYNC_TASK_MAP_PKG

Source

1 PACKAGE BODY cac_sync_task_map_pkg AS
2 /* $Header: cacvstmb.pls 120.1 2005/07/02 02:21:14 appldev noship $ */
3 /*=======================================================================+
4  |  Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5  |                            All rights reserved.                       |
6  +=======================================================================+
7  | FILENAME                                                              |
8  |   jtavstmb.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  | ------        ---------------  -------------------------------------- |
18  | 18-Jan-2002   gjashnan         Created.                               |
19  | 22-Feb-2002   cjang            Refactoring                            |
20  | 11-Mar-2002   cjang            Bug Fix update_row to update task_id   |
21  |                                Remove task_id = p_task_id             |
22  |                                   in update_row()                     |
23  | 09-May-2002   cjang            Removed the obsolete columns in insert_row
24  +======================================================================*/
25    PROCEDURE insert_row (
26       p_task_sync_id IN NUMBER,
27       p_task_id      IN NUMBER,
28       p_resource_id  IN NUMBER,
29       p_principal_id  IN NUMBER
30    )
31    IS
32       l_current_date DATE := SYSDATE;
33       l_user_id NUMBER := fnd_global.user_id;
34       l_login_id NUMBER := fnd_global.login_id;
35    BEGIN
36       INSERT INTO jta_sync_task_mapping
37       (task_sync_id,
38        task_id,
39        created_by,
40        creation_date,
41        last_updated_by,
42        last_update_date,
43        last_update_login,
44        resource_id,
45        principal_id
46       )
47       VALUES
48       (p_task_sync_id,
49        p_task_id,
50        l_user_id,
51        l_current_date,
52        l_user_id,
53        l_current_date,
54        l_login_id,
55        p_resource_id,
56        p_principal_id
57       );
58    END insert_row;
59 
60    PROCEDURE update_row (
61       p_task_sync_id IN NUMBER,
62       p_task_id      IN NUMBER,
63       p_resource_id  IN NUMBER,
64       p_principal_id IN NUMBER
65    )
66    IS
67       l_current_date DATE := SYSDATE;
68       l_user_id NUMBER := fnd_global.user_id;
69       l_login_id NUMBER := fnd_global.login_id;
70    BEGIN
71       UPDATE jta_sync_task_mapping
72          SET resource_id       = p_resource_id,
73              task_sync_id      = p_task_sync_id,
74              task_id           = p_task_id,
75              last_update_date  = l_current_date,
76              last_updated_by   = l_user_id,
77              last_update_login = l_login_id,
78              principal_id    = p_principal_id
79        WHERE task_sync_id = p_task_sync_id;
80    END update_row;
81 
82    PROCEDURE delete_row (
83       p_task_sync_id IN NUMBER
84    )
85    IS
86    BEGIN
87       DELETE
88         FROM jta_sync_task_mapping
89        WHERE task_sync_id = p_task_sync_id;
90    END delete_row;
91 END cac_sync_task_map_pkg;