1: PACKAGE cn_obj_sequences_v_pkg AUTHID CURRENT_USER AS
2: -- $Header: cnreseqs.pls 115.1 99/07/16 07:15:11 porting ship $
3:
4:
5: --
9: --
10: -- Procedure Name
11: -- insert_row
12: -- Purpose
13: -- Insert a new record in the cn_obj_sequences_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_sequence_id cn_obj_sequences_v.sequence_id%TYPE,
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_sequence_id cn_obj_sequences_v.sequence_id%TYPE,
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_sequence_id cn_obj_sequences_v.sequence_id%TYPE,
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
18: X_rowid OUT ROWID,
19: X_sequence_id cn_obj_sequences_v.sequence_id%TYPE,
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
19: X_sequence_id cn_obj_sequences_v.sequence_id%TYPE,
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
27: X_seed_sequence_id cn_obj_sequences_v.seed_sequence_id%TYPE);
20: X_name cn_obj_sequences_v.name%TYPE,
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
27: X_seed_sequence_id cn_obj_sequences_v.seed_sequence_id%TYPE);
28:
21: X_description cn_obj_sequences_v.description%TYPE,
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
27: X_seed_sequence_id cn_obj_sequences_v.seed_sequence_id%TYPE);
28:
29:
22: X_dependency_map_complete cn_obj_sequences_v.dependency_map_complete%TYPE,
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
27: X_seed_sequence_id cn_obj_sequences_v.seed_sequence_id%TYPE);
28:
29:
30: --
23: X_status cn_obj_sequences_v.status%TYPE,
24: X_repository_id cn_obj_sequences_v.repository_id%TYPE,
25: X_start_value cn_obj_sequences_v.start_value%TYPE,
26: X_increment_value cn_obj_sequences_v.increment_value%TYPE,
27: X_seed_sequence_id cn_obj_sequences_v.seed_sequence_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_sequences_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_sequences_v%ROWTYPE);
40:
41:
42: END cn_obj_sequences_v_pkg;
38: PROCEDURE select_row (
39: recinfo IN OUT cn_obj_sequences_v%ROWTYPE);
40:
41:
42: END cn_obj_sequences_v_pkg;