[Home] [Help]
PACKAGE: APPS.CN_COLUMN_MAPS_PKG
Source
1 PACKAGE CN_COLUMN_MAPS_PKG AUTHID CURRENT_USER AS
2 -- $Header: cncocms.pls 120.5 2005/09/20 05:10:54 vensrini noship $
3 --
4 -- Public Procedures
5 --
6 -- Procedure Name
7 -- insert_row
8 -- Purpose
9 -- Insert a new record in the table.
10 -- History
11 -- 15-FEB-94 Devesh Khatu Created
12 -- 09-MAR-00 Dave Maskell Table redesign
13
14
15 PROCEDURE insert_row (
16 X_rowid OUT NOCOPY ROWID,
17 X_column_map_id IN OUT NOCOPY cn_column_maps.column_map_id%TYPE,
18 X_destination_column_id cn_column_maps.destination_column_id%TYPE,
19 X_table_map_id cn_column_maps.table_map_id%TYPE,
20 X_expression cn_column_maps.expression%TYPE,
21 X_editable cn_column_maps.editable%TYPE,
22 X_modified cn_column_maps.modified%TYPE,
23 X_update_clause cn_column_maps.update_clause%TYPE,
24 X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
25 X_creation_date cn_column_maps.creation_date%TYPE,
26 X_created_by cn_column_maps.created_by%TYPE,
27 X_org_id cn_column_maps.org_id%TYPE);
28
29 --
30 -- Procedure Name
31 -- select_row
32 -- Purpose
33 -- Select a row from the table, given the primary key
34 -- History
35 --
36 /*
37 PROCEDURE select_row (
38 x_recinfo IN OUT NOCOPY cn_column_maps%ROWTYPE);
39
40 --
41 -- 09-MAR-00 Dave Maskell Added new procedures
42 --
43 PROCEDURE lock_row (
44 X_column_map_id cn_column_maps.column_map_id%TYPE,
45 X_destination_column_id cn_column_maps.destination_column_id%TYPE,
46 X_table_map_id cn_column_maps.table_map_id%TYPE,
47 X_expression cn_column_maps.expression%TYPE,
48 X_editable cn_column_maps.editable%TYPE,
49 X_modified cn_column_maps.modified%TYPE,
50 X_update_clause cn_column_maps.update_clause%TYPE,
51 X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE);
52 */
53 PROCEDURE update_row (
54 X_column_map_id cn_column_maps.column_map_id%TYPE,
55 X_destination_column_id cn_column_maps.destination_column_id%TYPE,
56 X_table_map_id cn_column_maps.table_map_id%TYPE,
57 X_expression cn_column_maps.expression%TYPE,
58 X_editable cn_column_maps.editable%TYPE,
59 X_modified cn_column_maps.modified%TYPE,
60 X_update_clause cn_column_maps.update_clause%TYPE,
61 X_calc_ext_table_id cn_column_maps.calc_ext_table_id%TYPE,
62 X_last_update_date cn_column_maps.last_update_date%TYPE,
63 X_last_updated_by cn_column_maps.last_updated_by%TYPE,
64 X_last_update_login cn_column_maps.last_update_login%TYPE,
65 x_object_version_number IN OUT NOCOPY NUMBER,
66 x_org_id IN NUMBER);
67
68 PROCEDURE delete_row (
69 X_column_map_id in NUMBER,
70 x_org_id IN NUMBER);
71
72 PROCEDURE load_row(x_COLUMN_MAP_ID in varchar2,
73 x_DESTINATION_COLUMN_ID in varchar2,
74 x_TABLE_MAP_ID in varchar2,
75 x_LAST_UPDATE_DATE in varchar2,
76 x_LAST_UPDATED_BY in varchar2,
77 x_CREATION_DATE in varchar2,
78 x_CREATED_BY in varchar2,
79 x_LAST_UPDATE_LOGIN in varchar2,
80 x_SOURCE_COLUMN_ID in varchar2,
81 x_DRIVING_COLUMN_ID in varchar2,
82 x_EXPRESSION in varchar2,
83 x_AGGREGATE_FUNCTION in varchar2,
84 x_SEED_COLUMN_MAP_ID in varchar2,
85 x_GROUP_BY_FLAG in varchar2,
86 x_UNIQUE_FLAG in varchar2,
87 x_ORG_ID in varchar2,
88 x_UPDATE_CLAUSE in varchar2,
89 x_MODIFIED in varchar2,
90 x_EDITABLE in varchar2,
91 x_CALC_EXT_TABLE_ID in varchar2,
92 x_OBJECT_VERSION_NUMBER in varchar2,
93 x_SECURITY_GROUP_ID in varchar2,
94 x_APPLICATION_SHORT_NAME in varchar2,
95 x_OWNER in varchar2);
96
97 PROCEDURE load_seed_row(x_UPLOAD_MODE in varchar2,
98 x_COLUMN_MAP_ID in varchar2,
99 x_DESTINATION_COLUMN_ID in varchar2,
100 x_TABLE_MAP_ID in varchar2,
101 x_LAST_UPDATE_DATE in varchar2,
102 x_LAST_UPDATED_BY in varchar2,
103 x_CREATION_DATE in varchar2,
104 x_CREATED_BY in varchar2,
105 x_LAST_UPDATE_LOGIN in varchar2,
106 x_SOURCE_COLUMN_ID in varchar2,
107 x_DRIVING_COLUMN_ID in varchar2,
108 x_EXPRESSION in varchar2,
109 x_AGGREGATE_FUNCTION in varchar2,
110 x_SEED_COLUMN_MAP_ID in varchar2,
111 x_GROUP_BY_FLAG in varchar2,
112 x_UNIQUE_FLAG in varchar2,
113 x_ORG_ID in varchar2,
114 x_UPDATE_CLAUSE in varchar2,
115 x_MODIFIED in varchar2,
116 x_EDITABLE in varchar2,
117 x_CALC_EXT_TABLE_ID in varchar2,
118 x_OBJECT_VERSION_NUMBER in varchar2,
119 x_SECURITY_GROUP_ID in varchar2,
120 x_APPLICATION_SHORT_NAME in varchar2,
121 x_OWNER in varchar2);
122
123 END cn_column_maps_pkg;