[Home] [Help]
PACKAGE: APPS.CN_OBJ_COLUMNS_V_PKG
Source
1 PACKAGE cn_obj_columns_v_pkg AUTHID CURRENT_USER as
2 -- $Header: cnrecols.pls 115.1 99/07/16 07:13:39 porting ship $
3
4
5 --
6 -- Public Procedures
7 --
8
9 --
10 -- Procedure Name
11 -- insert_row
12 -- History
13 -- 12/28/93 Paul Mitchell Created
14 -- 16-FEB-94 Devesh Khatu Modified
15 --
16 PROCEDURE Insert_Row(
17 X_Rowid OUT rowid,
18 X_row_id rowid default NULL,
19 X_Column_Id number,
20 X_Last_Update_Date date default NULL,
21 X_Last_Updated_By number default NULL,
22 X_Creation_Date date default NULL,
23 X_Created_By number default NULL,
24 X_Last_Update_Login number default NULL,
25 X_Name varchar2,
26 X_Description varchar2 default NULL,
27 X_Dependency_Map_Complete varchar2,
28 X_Next_Synchronization_Date date default NULL,
29 X_Synchronization_Frequency varchar2 default NULL,
30 X_Status varchar2,
31 X_Repository_Id number,
32 X_Table_Id number default NULL,
33 X_Data_Length number default NULL,
34 X_Data_Type varchar2 default NULL,
35 X_Nullable varchar2 default NULL,
36 X_Primary_Key varchar2 default NULL,
37 X_Position number default NULL,
38 X_Dimension_Id number default NULL,
39 X_Data_Scale number default NULL,
40 X_Column_Type varchar2 default NULL,
41 X_user_column_name varchar2,
42 X_Seed_Column_Id number default NULL);
43
44
45
46 --
47 -- Procedure Name
48 -- update_row
49 -- History
50 -- 12/28/93 Paul Mitchell Created
51 --
52 PROCEDURE Update_Row(
53 X_rowid varchar2,
54 X_row_id rowid default NULL,
55 X_column_id number,
56 X_name varchar2,
57 X_description varchar2 default NULL,
58 x_dependency_map_complete varchar2,
59 X_next_synchronization_date date default NULL,
60 X_synchronization_frequency varchar2 default NULL,
61 X_status varchar2,
62 X_repository_id number,
63 X_table_id number default NULL,
64 X_data_length number default NULL,
65 X_data_type varchar2 default NULL,
66 X_nullable varchar2 default NULL,
67 X_primary_key varchar2 default NULL,
68 X_position number default NULL,
69 X_dimension_id number default NULL,
70 X_data_scale number default NULL,
71 X_column_type varchar2 default NULL,
72 X_seed_column_id number default NULL);
73
74
75 --
76 -- Procedure Name
77 -- delete_row
78 -- History
79 -- 12/28/93 Paul Mitchell Created
80 --
81 PROCEDURE Delete_Row(
82 X_Rowid varchar2);
83
84
85 END cn_obj_columns_v_pkg;