1: PACKAGE cn_obj_procedures_v_pkg AUTHID CURRENT_USER AS
2: -- $Header: cnreprcs.pls 115.1 99/07/16 07:15:06 porting ship $
3:
4:
5: --
12: -- 16-FEB-94 Devesh Khatu Modified
13: --
14: PROCEDURE insert_row (
15: X_rowid OUT ROWID,
16: X_procedure_id cn_obj_procedures_v.procedure_id%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
13: --
14: PROCEDURE insert_row (
15: X_rowid OUT ROWID,
16: X_procedure_id cn_obj_procedures_v.procedure_id%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
14: PROCEDURE insert_row (
15: X_rowid OUT ROWID,
16: X_procedure_id cn_obj_procedures_v.procedure_id%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
15: X_rowid OUT ROWID,
16: X_procedure_id cn_obj_procedures_v.procedure_id%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
16: X_procedure_id cn_obj_procedures_v.procedure_id%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
17: X_name cn_obj_procedures_v.name%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
18: X_description cn_obj_procedures_v.description%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
19: X_dependency_map_complete cn_obj_procedures_v.dependency_map_complete%TYPE,
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
27: X_seed_procedure_id cn_obj_procedures_v.seed_procedure_id%TYPE);
20: X_status cn_obj_procedures_v.status%TYPE,
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
27: X_seed_procedure_id cn_obj_procedures_v.seed_procedure_id%TYPE);
28:
21: X_repository_id cn_obj_procedures_v.repository_id%TYPE,
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
27: X_seed_procedure_id cn_obj_procedures_v.seed_procedure_id%TYPE);
28:
29:
22: X_parameter_list cn_obj_procedures_v.parameter_list%TYPE,
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
27: X_seed_procedure_id cn_obj_procedures_v.seed_procedure_id%TYPE);
28:
29:
30:
23: X_procedure_type cn_obj_procedures_v.procedure_type%TYPE,
24: X_return_type cn_obj_procedures_v.return_type%TYPE,
25: X_package_id cn_obj_procedures_v.package_id%TYPE,
26: X_public_flag cn_obj_procedures_v.public_flag%TYPE,
27: X_seed_procedure_id cn_obj_procedures_v.seed_procedure_id%TYPE);
28:
29:
30:
31: --
36: -- History
37: -- 11/17/93 Devesh Khatu Created
38: --
39: PROCEDURE select_row(
40: row IN OUT cn_obj_procedures_v%ROWTYPE);
41:
42:
43: END cn_obj_procedures_v_pkg;
39: PROCEDURE select_row(
40: row IN OUT cn_obj_procedures_v%ROWTYPE);
41:
42:
43: END cn_obj_procedures_v_pkg;