APPS.CN_OBJECTS_PKG dependencies on CN_OBJECTS

Line 1: PACKAGE BODY cn_objects_pkg AS

1: PACKAGE BODY cn_objects_pkg AS
2: -- $Header: cnreobjb.pls 120.6 2005/09/26 01:51:32 hakhter noship $
3: --+
4: -- Public Functions
5: --+

Line 9: X_object_id cn_objects.object_id%TYPE,

5: --+
6:
7: PROCEDURE insert_row (
8: X_rowid IN OUT NOCOPY ROWID,
9: X_object_id cn_objects.object_id%TYPE,
10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,

Line 10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,

6:
7: PROCEDURE insert_row (
8: X_rowid IN OUT NOCOPY ROWID,
9: X_object_id cn_objects.object_id%TYPE,
10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,

Line 11: X_name cn_objects.name%TYPE,

7: PROCEDURE insert_row (
8: X_rowid IN OUT NOCOPY ROWID,
9: X_object_id cn_objects.object_id%TYPE,
10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,

Line 12: X_description cn_objects.description%TYPE,

8: X_rowid IN OUT NOCOPY ROWID,
9: X_object_id cn_objects.object_id%TYPE,
10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,

Line 13: X_object_type cn_objects.object_type%TYPE,

9: X_object_id cn_objects.object_id%TYPE,
10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,

Line 14: X_repository_id cn_objects.repository_id%TYPE,

10: X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,

Line 15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,

11: X_name cn_objects.name%TYPE,
12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS

Line 16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,

12: X_description cn_objects.description%TYPE,
13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS
20:

Line 17: X_object_status cn_objects.object_status%TYPE,

13: X_object_type cn_objects.object_type%TYPE,
14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS
20:
21: BEGIN

Line 18: X_object_value cn_objects.object_value%TYPE,

14: X_repository_id cn_objects.repository_id%TYPE,
15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS
20:
21: BEGIN
22: INSERT INTO cn_objects (

Line 19: X_org_id cn_objects.org_id%TYPE) IS

15: X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
16: X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
17: X_object_status cn_objects.object_status%TYPE,
18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS
20:
21: BEGIN
22: INSERT INTO cn_objects (
23: object_id,

Line 22: INSERT INTO cn_objects (

18: X_object_value cn_objects.object_value%TYPE,
19: X_org_id cn_objects.org_id%TYPE) IS
20:
21: BEGIN
22: INSERT INTO cn_objects (
23: object_id,
24: dependency_map_complete,
25: name,
26: description,

Line 51: FROM cn_objects

47: 1);
48:
49: SELECT ROWID
50: INTO X_rowid
51: FROM cn_objects
52: WHERE object_id = X_object_id
53: AND org_id = X_org_id;
54:
55: IF (SQL%NOTFOUND) THEN

Line 63: recinfo IN OUT NOCOPY cn_objects%ROWTYPE) IS

59: END insert_row;
60:
61:
62: PROCEDURE select_row (
63: recinfo IN OUT NOCOPY cn_objects%ROWTYPE) IS
64:
65: BEGIN
66:
67: -- select row based on object_id (primary key)

Line 71: FROM cn_objects co

67: -- select row based on object_id (primary key)
68: IF (recinfo.object_id IS NOT NULL) THEN
69:
70: SELECT * INTO recinfo
71: FROM cn_objects co
72: WHERE co.object_id = recinfo.object_id;
73:
74: END IF;
75:

Line 147: --CN_OBJECTS_PKG.TRANSLATE_ROW(x_owner);

143: x_OWNER in varchar2)
144: IS
145: BEGIN
146: if (x_upload_mode = 'NLS') then
147: --CN_OBJECTS_PKG.TRANSLATE_ROW(x_owner);
148: -- As this ldt is not required to loaded translated data, you could leave it blank.
149: null;
150: else
151: CN_OBJECTS_PKG.LOAD_ROW(

Line 151: CN_OBJECTS_PKG.LOAD_ROW(

147: --CN_OBJECTS_PKG.TRANSLATE_ROW(x_owner);
148: -- As this ldt is not required to loaded translated data, you could leave it blank.
149: null;
150: else
151: CN_OBJECTS_PKG.LOAD_ROW(
152: x_OBJECT_ID,
153: x_DEPENDENCY_MAP_COMPLETE,
154: x_NAME,
155: x_OBJECT_TYPE,

Line 303: update cn_objects_all set

299: ELSE
300: USER_ID := 0;
301: END IF;
302:
303: update cn_objects_all set
304: DEPENDENCY_MAP_COMPLETE = x_DEPENDENCY_MAP_COMPLETE,
305: NAME = x_NAME,
306: OBJECT_TYPE = x_OBJECT_TYPE,
307: REPOSITORY_ID = to_number(x_REPOSITORY_ID),

Line 370: -- Insert new record to CN_OBJECTS_TABLE table

366: OBJECT_ID = X_OBJECT_ID
367: and ORG_ID = X_ORG_ID;
368:
369: IF (SQL%NOTFOUND) THEN
370: -- Insert new record to CN_OBJECTS_TABLE table
371: insert into CN_OBJECTS_ALL
372: (
373: OBJECT_ID,
374: DEPENDENCY_MAP_COMPLETE,

Line 371: insert into CN_OBJECTS_ALL

367: and ORG_ID = X_ORG_ID;
368:
369: IF (SQL%NOTFOUND) THEN
370: -- Insert new record to CN_OBJECTS_TABLE table
371: insert into CN_OBJECTS_ALL
372: (
373: OBJECT_ID,
374: DEPENDENCY_MAP_COMPLETE,
375: NAME,

Line 511: END cn_objects_pkg;

507: END LOAD_ROW;
508:
509:
510:
511: END cn_objects_pkg;