1: PACKAGE cn_obj_indexes_v_pkg AUTHID CURRENT_USER AS
2: -- $Header: cnreinds.pls 115.1 99/07/16 07:14:36 porting ship $
3:
4:
5: --
9: --
10: -- Procedure Name
11: -- insert_row
12: -- Purpose
13: -- Insert a new record in the cn_obj_indexes_v view.
14: -- History
15: -- 11-FEB-94 Devesh Khatu Created
16: --
17: PROCEDURE insert_row (
15: -- 11-FEB-94 Devesh Khatu Created
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_index_id cn_obj_indexes_v.index_id%TYPE,
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_index_id cn_obj_indexes_v.index_id%TYPE,
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_index_id cn_obj_indexes_v.index_id%TYPE,
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
18: X_rowid OUT ROWID,
19: X_index_id cn_obj_indexes_v.index_id%TYPE,
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
19: X_index_id cn_obj_indexes_v.index_id%TYPE,
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
27: X_seed_index_id cn_obj_indexes_v.seed_index_id%TYPE);
20: X_name cn_obj_indexes_v.name%TYPE,
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
27: X_seed_index_id cn_obj_indexes_v.seed_index_id%TYPE);
28:
21: X_description cn_obj_indexes_v.description%TYPE,
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
27: X_seed_index_id cn_obj_indexes_v.seed_index_id%TYPE);
28:
29:
22: X_dependency_map_complete cn_obj_indexes_v.dependency_map_complete%TYPE,
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
27: X_seed_index_id cn_obj_indexes_v.seed_index_id%TYPE);
28:
29:
30: --
23: X_status cn_obj_indexes_v.status%TYPE,
24: X_repository_id cn_obj_indexes_v.repository_id%TYPE,
25: X_table_id cn_obj_indexes_v.table_id%TYPE,
26: X_unique_flag cn_obj_indexes_v.unique_flag%TYPE,
27: X_seed_index_id cn_obj_indexes_v.seed_index_id%TYPE);
28:
29:
30: --
31: -- Procedure Name
30: --
31: -- Procedure Name
32: -- select_row
33: -- Purpose
34: -- Selects a record from the cn_obj_indexes_v view.
35: -- History
36: -- 11-FEB-94 Devesh Khatu Created
37: --
38: PROCEDURE select_row (
35: -- History
36: -- 11-FEB-94 Devesh Khatu Created
37: --
38: PROCEDURE select_row (
39: recinfo IN OUT cn_obj_indexes_v%ROWTYPE);
40:
41:
42: END cn_obj_indexes_v_pkg;
38: PROCEDURE select_row (
39: recinfo IN OUT cn_obj_indexes_v%ROWTYPE);
40:
41:
42: END cn_obj_indexes_v_pkg;