[Home] [Help]
PACKAGE: APPS.CN_TABLE_MAPS_PKG
Source
1 PACKAGE CN_TABLE_MAPS_PKG AUTHID CURRENT_USER AS
2 -- $Header: cncotms.pls 120.4 2005/10/24 00:44:50 apink noship $
3 --
4 -- Public Procedures
5 --
6 --
7 -- Procedure Name
8 -- insert_row
9 -- Purpose
10 -- Insert a new record in the table.
11 --
12 PROCEDURE insert_row (
13 X_rowid OUT NOCOPY ROWID,
14 X_table_map_id IN OUT NOCOPY cn_table_maps.table_map_id%TYPE,
15 X_mapping_type cn_table_maps.mapping_type%TYPE,
16 X_module_id cn_table_maps.module_id%TYPE,
17 X_source_table_id cn_table_maps.source_table_id%TYPE,
18 X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
19 X_destination_table_id cn_table_maps.destination_table_id%TYPE,
20 X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
21 X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
22 X_notify_where cn_table_maps.notify_where%TYPE,
23 X_collect_where cn_table_maps.collect_where%TYPE,
24 X_delete_flag cn_table_maps.delete_flag%TYPE,
25 X_creation_date cn_table_maps.creation_date%TYPE,
26 X_created_by cn_table_maps.created_by%TYPE,
27 X_org_id cn_table_maps.org_id%TYPE);
28
29 PROCEDURE lock_row (
30 X_table_map_id cn_table_maps.table_map_id%TYPE,
31 X_mapping_type cn_table_maps.mapping_type%TYPE,
32 X_module_id cn_table_maps.module_id%TYPE,
33 X_source_table_id cn_table_maps.source_table_id%TYPE,
34 X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
35 X_destination_table_id cn_table_maps.destination_table_id%TYPE,
36 X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
37 X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
38 X_notify_where cn_table_maps.notify_where%TYPE,
39 X_collect_where cn_table_maps.collect_where%TYPE,
40 X_delete_flag cn_table_maps.delete_flag%TYPE);
41
42 PROCEDURE update_row (
43 X_table_map_id cn_table_maps.table_map_id%TYPE,
44 X_mapping_type cn_table_maps.mapping_type%TYPE,
45 X_module_id cn_table_maps.module_id%TYPE,
46 X_source_table_id cn_table_maps.source_table_id%TYPE,
47 X_source_tbl_pkcol_id cn_table_maps.source_tbl_pkcol_id%TYPE,
48 X_destination_table_id cn_table_maps.destination_table_id%TYPE,
49 X_source_hdr_tbl_pkcol_id cn_table_maps.source_hdr_tbl_pkcol_id%TYPE,
50 X_source_tbl_hdr_fkcol_id cn_table_maps.source_tbl_hdr_fkcol_id%TYPE,
51 X_notify_where cn_table_maps.notify_where%TYPE,
52 X_collect_where cn_table_maps.collect_where%TYPE,
53 X_delete_flag cn_table_maps.delete_flag%TYPE,
54 X_last_update_date cn_table_maps.last_update_date%TYPE,
55 X_last_updated_by cn_table_maps.last_updated_by%TYPE,
56 X_last_update_login cn_table_maps.last_update_login%TYPE,
57 x_object_version_number NUMBER := cn_api.G_MISS_NUM,
58 x_org_id cn_table_maps.org_id%TYPE);
59
60 PROCEDURE delete_row (
61 X_table_map_id in NUMBER,
62 X_org_id IN NUMBER);
63
64 PROCEDURE load_seed_row(x_UPLOAD_MODE in varchar2,
65 x_TABLE_MAP_ID in varchar2,
66 x_MAPPING_TYPE in varchar2,
67 x_SOURCE_TABLE_ID in varchar2,
68 x_DESTINATION_TABLE_ID in varchar2,
69 x_MODULE_ID in varchar2,
70 x_LAST_UPDATE_DATE in varchar2,
71 x_LAST_UPDATED_BY in varchar2,
72 x_CREATION_DATE in varchar2,
73 x_CREATED_BY in varchar2,
74 x_DESCRIPTION in varchar2,
75 x_SEED_TABLE_MAP_ID in varchar2,
76 x_ORG_ID in varchar2,
77 x_LAST_UPDATE_LOGIN in varchar2,
78 x_SOURCE_TBL_PKCOL_ID in varchar2,
79 x_DELETE_FLAG in varchar2,
80 x_SOURCE_HDR_TBL_PKCOL_ID in varchar2,
81 x_SOURCE_TBL_HDR_FKCOL_ID in varchar2,
82 x_NOTIFY_WHERE in varchar2,
83 x_COLLECT_WHERE in varchar2,
84 x_OBJECT_VERSION_NUMBER in varchar2,
85 x_SECURITY_GROUP_ID in varchar2,
86 x_FILTER in varchar2,
87 x_APPLICATION_SHORT_NAME in varchar2,
88 x_OWNER in varchar2);
89
90 PROCEDURE load_row(x_TABLE_MAP_ID in varchar2,
91 x_MAPPING_TYPE in varchar2,
92 x_SOURCE_TABLE_ID in varchar2,
93 x_DESTINATION_TABLE_ID in varchar2,
94 x_MODULE_ID in varchar2,
95 x_LAST_UPDATE_DATE in varchar2,
96 x_LAST_UPDATED_BY in varchar2,
97 x_CREATION_DATE in varchar2,
98 x_CREATED_BY in varchar2,
99 x_DESCRIPTION in varchar2,
100 x_SEED_TABLE_MAP_ID in varchar2,
101 x_ORG_ID in varchar2,
102 x_LAST_UPDATE_LOGIN in varchar2,
103 x_SOURCE_TBL_PKCOL_ID in varchar2,
104 x_DELETE_FLAG in varchar2,
105 x_SOURCE_HDR_TBL_PKCOL_ID in varchar2,
106 x_SOURCE_TBL_HDR_FKCOL_ID in varchar2,
107 x_NOTIFY_WHERE in varchar2,
108 x_COLLECT_WHERE in varchar2,
109 x_OBJECT_VERSION_NUMBER in varchar2,
110 x_SECURITY_GROUP_ID in varchar2,
111 x_FILTER in varchar2,
112 x_APPLICATION_SHORT_NAME in varchar2,
113 x_OWNER in varchar2);
114
115 END cn_table_maps_pkg;
116