1: PACKAGE cn_obj_packages_v_pkg AUTHID CURRENT_USER AS
2: -- $Header: cnrepkgs.pls 115.1 99/07/16 07:14:59 porting ship $
3:
4:
5:
14: -- 16-FEB-94 Devesh Khatu Modified
15: --
16: PROCEDURE insert_row (
17: X_rowid OUT ROWID,
18: X_package_id cn_obj_packages_v.package_id%TYPE,
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
15: --
16: PROCEDURE insert_row (
17: X_rowid OUT ROWID,
18: X_package_id cn_obj_packages_v.package_id%TYPE,
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
16: PROCEDURE insert_row (
17: X_rowid OUT ROWID,
18: X_package_id cn_obj_packages_v.package_id%TYPE,
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
17: X_rowid OUT ROWID,
18: X_package_id cn_obj_packages_v.package_id%TYPE,
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
18: X_package_id cn_obj_packages_v.package_id%TYPE,
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
26: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE);
19: X_name cn_obj_packages_v.name%TYPE,
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
26: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE);
27:
20: X_description cn_obj_packages_v.description%TYPE,
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
26: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE);
27:
28: --
21: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
26: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE);
27:
28: --
29: -- Procedure Name
22: X_status cn_obj_packages_v.status%TYPE,
23: X_repository_id cn_obj_packages_v.repository_id%TYPE,
24: X_package_type cn_obj_packages_v.package_type%TYPE,
25: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
26: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE);
27:
28: --
29: -- Procedure Name
30: -- select_row
33: -- History
34: -- 11/17/93 Devesh Khatu Created
35: --
36: PROCEDURE select_row (
37: row IN OUT cn_obj_packages_v%ROWTYPE);
38:
39:
40: END cn_obj_packages_v_pkg;
36: PROCEDURE select_row (
37: row IN OUT cn_obj_packages_v%ROWTYPE);
38:
39:
40: END cn_obj_packages_v_pkg;