PACKAGE BODY: APPS.CN_COLUMN_MAPS_V_PKG

Source

1 PACKAGE BODY cn_column_maps_v_pkg AS
2 -- $Header: cncocmvb.pls 120.1 2005/06/27 19:26:42 appldev ship $
3 
4 
5 --
6 -- Public Procedures
7 --
8 
9   --+
10   -- Procedure Name
11   --   insert_row
12   -- History
13   --                    Tony Lower              Created
14   -- 11-28-95           Amy Erickson            Updated
15 
16   PROCEDURE insert_row (
17         x_column_map_id            Number,
18         x_source_column_id         Number,
19         x_dest_column_id           Number,
20         x_table_map_id             Number,
21         x_foreign_key_mapping_id   Number,
22         x_expression               varchar2,
23         x_creation_date            date,
24         x_created_by               number) IS
25 
26   BEGIN
27 
28     INSERT INTO cn_column_maps(
29         column_map_id,
30         source_column_id,
31         destination_column_id,
32         table_map_id,
33         driving_column_id,
34         expression,
35         creation_date,
36         created_by)
37     VALUES(
38         x_column_map_id,
39         x_source_column_id,
40         x_dest_column_id,
41         x_table_map_id,
42         x_foreign_key_mapping_id,
43         x_expression,
44         x_creation_date,
45         x_created_by);
46 
47   END insert_row;
48 
49 
50   --+
51   -- Procedure Name
52   --   update_row
53   -- History
54   --                    Tony Lower              Created
55   -- 11-28-95           Amy Erickson            Updated
56 
57   PROCEDURE update_row(
58         x_column_map_id                 Number,
59         x_source_column_id              Number,
60         x_dest_column_id                Number,
61         x_table_map_id                  Number,
62         x_foreign_key_mapping_id        Number,
63         x_expression                    varchar2,
64         x_last_update_date              date,
65         x_last_update_login             number,
66         x_last_updated_by               number) IS
67 
68   BEGIN
69 
70     UPDATE cn_column_maps SET
71         source_column_id = x_source_column_id,
72         destination_column_id = x_dest_column_id,
73         table_map_id = x_table_map_id,
74         driving_column_id = x_foreign_key_mapping_id,
75         expression = x_expression,
76         last_update_date  = x_last_update_date,
77         last_update_login = x_last_update_login,
78         last_updated_by   = x_last_updated_by
79     WHERE column_map_id = X_column_map_id;
80 
81   END update_row;
82 
83   --+
84   -- Procedure Name
85   --   lock_row
86   -- History
87   --                    Tony Lower              Created
88   -- 07-16-95           Amy Erickson            Updated
89 
90   PROCEDURE lock_row (x_column_map_id  IN   NUMBER) IS
91         temp Number;
92   BEGIN
93     temp := NULL;
94 
95         SELECT column_map_id
96           INTO temp
97           FROM cn_column_maps
98          WHERE column_map_id = x_column_map_id
99            FOR UPDATE ;
100 
101   END lock_row;
102 
103   --+
104   -- Procedure Name
105   --   delete_row
106   -- History
107   -- 07-16-95           Amy Erickson            Created
108 
109   PROCEDURE delete_row (x_column_map_id  IN   NUMBER) IS
110   BEGIN
111 
112         DELETE cn_column_maps
113          WHERE column_map_id = x_column_map_id ;
114 
115   END delete_row;
116 
117   --+
118   -- Procedure Name
119   --   Default_Row
120   -- History
121   -- 07-16-95           Amy Erickson            Created
122 
123   PROCEDURE Default_Row (x_column_map_id  IN OUT NOCOPY number) IS
124     BEGIN
125 
126       IF x_column_map_id IS NULL THEN
127         SELECT cn_column_maps_s.nextval
128           INTO x_column_map_id
129           FROM sys.dual ;
130       END IF;
131 
132     END Default_Row;
133 
134 END cn_column_maps_v_pkg;