1: PACKAGE cn_obj_dblinks_v_pkg AUTHID CURRENT_USER AS
2: -- $Header: cnredbls.pls 115.1 99/07/16 07:13:50 porting ship $
3:
4:
5: --
9: --
10: -- Procedure Name
11: -- insert_row
12: -- Purpose
13: -- Insert a new record in the cn_obj_dblinks_v view.
14: -- History
15: -- 11-JUN-94 Devesh Khatu Created
16: --
17: PROCEDURE insert_row (
15: -- 11-JUN-94 Devesh Khatu Created
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_dblink_id cn_obj_dblinks_v.dblink_id%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_dblink_id cn_obj_dblinks_v.dblink_id%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_dblink_id cn_obj_dblinks_v.dblink_id%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
18: X_rowid OUT ROWID,
19: X_dblink_id cn_obj_dblinks_v.dblink_id%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
19: X_dblink_id cn_obj_dblinks_v.dblink_id%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
20: X_name cn_obj_dblinks_v.name%TYPE,
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
28: X_seed_dblink_id cn_obj_dblinks_v.seed_dblink_id%TYPE);
21: X_description cn_obj_dblinks_v.description%TYPE,
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
28: X_seed_dblink_id cn_obj_dblinks_v.seed_dblink_id%TYPE);
29:
22: X_dependency_map_complete cn_obj_dblinks_v.dependency_map_complete%TYPE,
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
28: X_seed_dblink_id cn_obj_dblinks_v.seed_dblink_id%TYPE);
29:
30:
23: X_status cn_obj_dblinks_v.status%TYPE,
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
28: X_seed_dblink_id cn_obj_dblinks_v.seed_dblink_id%TYPE);
29:
30:
31: --
24: X_repository_id cn_obj_dblinks_v.repository_id%TYPE,
25: X_connect_to_username cn_obj_dblinks_v.connect_to_username%TYPE,
26: X_connect_to_password cn_obj_dblinks_v.connect_to_password%TYPE,
27: X_connect_to_host cn_obj_dblinks_v.connect_to_host%TYPE,
28: X_seed_dblink_id cn_obj_dblinks_v.seed_dblink_id%TYPE);
29:
30:
31: --
32: -- Procedure Name
31: --
32: -- Procedure Name
33: -- select_row
34: -- Purpose
35: -- Selects a record from the cn_obj_dblinks_v view.
36: -- History
37: -- 11-JUN-94 Devesh Khatu Created
38: --
39: PROCEDURE select_row (
36: -- History
37: -- 11-JUN-94 Devesh Khatu Created
38: --
39: PROCEDURE select_row (
40: recinfo IN OUT cn_obj_dblinks_v%ROWTYPE);
41:
42:
43: END cn_obj_dblinks_v_pkg;
39: PROCEDURE select_row (
40: recinfo IN OUT cn_obj_dblinks_v%ROWTYPE);
41:
42:
43: END cn_obj_dblinks_v_pkg;