[Home] [Help]
PACKAGE BODY: APPS.JTA_SYNC_TASK_MAP_PKG
Source
1 PACKAGE BODY jta_sync_task_map_pkg AS
2 /* $Header: jtavstmb.pls 115.15 2002/05/13 10:01:30 pkm ship $ */
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 )
30 IS
31 l_current_date DATE := SYSDATE;
32 l_user_id NUMBER := fnd_global.user_id;
33 l_login_id NUMBER := fnd_global.login_id;
34 BEGIN
35 INSERT INTO jta_sync_task_mapping
36 (task_sync_id,
37 task_id,
38 created_by,
39 creation_date,
40 last_updated_by,
41 last_update_date,
42 last_update_login,
43 resource_id
44 )
45 VALUES
46 (p_task_sync_id,
47 p_task_id,
48 l_user_id,
49 l_current_date,
50 l_user_id,
51 l_current_date,
52 l_login_id,
53 p_resource_id
54 );
55 END insert_row;
56
57 PROCEDURE update_row (
58 p_task_sync_id IN NUMBER,
59 p_task_id IN NUMBER,
60 p_resource_id IN NUMBER
61 )
62 IS
63 l_current_date DATE := SYSDATE;
64 l_user_id NUMBER := fnd_global.user_id;
65 l_login_id NUMBER := fnd_global.login_id;
66 BEGIN
67 UPDATE jta_sync_task_mapping
68 SET resource_id = p_resource_id,
69 task_sync_id = p_task_sync_id,
70 task_id = p_task_id,
71 last_update_date = l_current_date,
72 last_updated_by = l_user_id,
73 last_update_login = l_login_id
74 WHERE task_sync_id = p_task_sync_id;
75 END update_row;
76
77 PROCEDURE delete_row (
78 p_task_sync_id IN NUMBER
79 )
80 IS
81 BEGIN
82 DELETE
83 FROM jta_sync_task_mapping
84 WHERE task_sync_id = p_task_sync_id;
85 END delete_row;
86 END jta_sync_task_map_pkg;