eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_OBJ_PACKAGES_V_PKG dependencies on CN_OBJ_PACKAGES_V

Line 1: PACKAGE BODY cn_obj_packages_v_pkg AS

1: PACKAGE BODY cn_obj_packages_v_pkg AS
2: -- $Header: cnrepkgb.pls 115.1 99/07/16 07:14:56 porting ship $
3:
4:
5: --

Line 19: X_package_id cn_obj_packages_v.package_id%TYPE,

15: -- 16-FEB-94 Devesh Khatu Modified
16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_package_id cn_obj_packages_v.package_id%TYPE,
20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,

Line 20: X_name cn_obj_packages_v.name%TYPE,

16: --
17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_package_id cn_obj_packages_v.package_id%TYPE,
20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,

Line 21: X_description cn_obj_packages_v.description%TYPE,

17: PROCEDURE insert_row (
18: X_rowid OUT ROWID,
19: X_package_id cn_obj_packages_v.package_id%TYPE,
20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,

Line 22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,

18: X_rowid OUT ROWID,
19: X_package_id cn_obj_packages_v.package_id%TYPE,
20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,

Line 23: X_status cn_obj_packages_v.status%TYPE,

19: X_package_id cn_obj_packages_v.package_id%TYPE,
20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS

Line 24: X_repository_id cn_obj_packages_v.repository_id%TYPE,

20: X_name cn_obj_packages_v.name%TYPE,
21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:

Line 25: X_package_type cn_obj_packages_v.package_type%TYPE,

21: X_description cn_obj_packages_v.description%TYPE,
22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:
29: X_object_type cn_obj_packages_v.object_type%TYPE;

Line 26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,

22: X_dependency_map_complete cn_obj_packages_v.dependency_map_complete%TYPE,
23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:
29: X_object_type cn_obj_packages_v.object_type%TYPE;
30: X_primary_key cn_obj_packages_v.package_id%TYPE;

Line 27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS

23: X_status cn_obj_packages_v.status%TYPE,
24: X_repository_id cn_obj_packages_v.repository_id%TYPE,
25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:
29: X_object_type cn_obj_packages_v.object_type%TYPE;
30: X_primary_key cn_obj_packages_v.package_id%TYPE;
31:

Line 29: X_object_type cn_obj_packages_v.object_type%TYPE;

25: X_package_type cn_obj_packages_v.package_type%TYPE,
26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:
29: X_object_type cn_obj_packages_v.object_type%TYPE;
30: X_primary_key cn_obj_packages_v.package_id%TYPE;
31:
32: BEGIN
33:

Line 30: X_primary_key cn_obj_packages_v.package_id%TYPE;

26: X_package_specification_id cn_obj_packages_v.package_specification_id%TYPE,
27: X_seed_package_id cn_obj_packages_v.seed_package_id%TYPE) IS
28:
29: X_object_type cn_obj_packages_v.object_type%TYPE;
30: X_primary_key cn_obj_packages_v.package_id%TYPE;
31:
32: BEGIN
33:
34: X_primary_key := X_package_id;

Line 49: INSERT INTO cn_obj_packages_v(

45: -- package body
46: X_object_type := 'PKB';
47: END IF;
48:
49: INSERT INTO cn_obj_packages_v(
50: package_id,
51: name,
52: description,
53: dependency_map_complete,

Line 74: FROM cn_obj_packages_v

70: X_seed_package_id);
71:
72: SELECT ROWID
73: INTO X_rowid
74: FROM cn_obj_packages_v
75: WHERE package_id = X_primary_key;
76:
77: IF (SQL%NOTFOUND) THEN
78: RAISE NO_DATA_FOUND;

Line 93: row IN OUT cn_obj_packages_v%ROWTYPE) IS

89: -- Select row from CN_REP_OBJ_PKGS_V.
90: -- History
91: --
92: PROCEDURE select_row(
93: row IN OUT cn_obj_packages_v%ROWTYPE) IS
94:
95: BEGIN
96:
97: IF (row.package_id IS NOT NULL) THEN

Line 100: FROM cn_obj_packages_v

96:
97: IF (row.package_id IS NOT NULL) THEN
98: SELECT *
99: INTO row
100: FROM cn_obj_packages_v
101: WHERE cn_obj_packages_v.package_id = row.package_id;
102: END IF;
103:
104: END select_row;

Line 101: WHERE cn_obj_packages_v.package_id = row.package_id;

97: IF (row.package_id IS NOT NULL) THEN
98: SELECT *
99: INTO row
100: FROM cn_obj_packages_v
101: WHERE cn_obj_packages_v.package_id = row.package_id;
102: END IF;
103:
104: END select_row;
105:

Line 107: END cn_obj_packages_v_pkg;

103:
104: END select_row;
105:
106:
107: END cn_obj_packages_v_pkg;