PACKAGE: APPS.CN_OBJ_TABLES_V_PKG

Source

1 PACKAGE cn_obj_tables_v_pkg AUTHID CURRENT_USER AS
2 -- $Header: cnretbls.pls 115.1 99/07/16 07:15:17 porting ship $
3 
4 
5 --
6 -- Public Procedures
7 --
8 
9   --
10   -- Procedure Name
11   --   insert_row
12   -- Purpose
13   --   Insert a new record in the table underlying the view with the values
14   --   supplied by the parameters.
15   -- History
16   --   11/17/93		Devesh Khatu		Created
17   --   16-FEB-94	Devesh Khatu		Modified
18   --
19   PROCEDURE insert_row (
20 	X_rowid			OUT	rowid,
21         X_row_id                        rowid		default NULL,
22 	X_table_id 		IN OUT	number,
23 	X_name 				varchar2,
24 	X_description 			varchar2	default NULL,
25 	X_status 			varchar2,
26 	X_dependency_map_complete 	varchar2,
27 	X_repository_id			number,
28 	X_alias				varchar2	default NULL,
29 	X_table_level			varchar2	default NULL,
30 	X_table_type			varchar2	default NULL,
31 	X_seed_table_id			varchar2	default NULL);
32 
33   --
34   -- Procedure Name
35   --   update_row
36   -- Purpose
37   --   Update a row in the table, with the information given in the parameters
38   -- History
39   --   11/24/93		Tony Lower		Created
40   --
41   PROCEDURE update_row (
42 	X_rowid				varchar2,
43 	X_table_id 			number,
44 	X_name 				varchar2,
45 	X_description			varchar2	default NULL,
46 	X_repository_id			number,
47 	X_alias				varchar2	default NULL,
48 	X_table_level			varchar2	default NULL,
49 	X_table_type			varchar2	default NULL);
50 
51 
52   --
53   -- Procedure Name
54   --   lock_row
55   -- History
56   --   11/17/93		Devesh Khatu		Created
57   --
58   PROCEDURE lock_row( tab_id IN number);
59 
60 
61 
62   --
63   -- Procedure Name
64   --   select_row
65   -- Purpose
66   --   Select a row from the table, given the primary key
67   -- History
68   --   11/17/93		Devesh Khatu		Created
69   --
70   PROCEDURE select_row (
71 	row IN OUT cn_obj_tables_v%ROWTYPE);
72 
73 
74 END cn_obj_tables_v_pkg;