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_TABLE_MAPS_PVT dependencies on CN_OBJECTS

Line 34: l_object_id cn_objects.object_id%TYPE;

30: l_application_repository_id cn_events.application_repository_id%TYPE;
31: l_parent_module_id cn_modules.parent_module_id%TYPE;
32: l_user_id NUMBER := nvl(fnd_profile.value('USER_ID'),-1);
33: l_column_map_id cn_column_maps.column_map_id%TYPE;
34: l_object_id cn_objects.object_id%TYPE;
35: l_table_map_object_id cn_table_map_objects.object_id%TYPE;
36: l_org_append VARCHAR2(100);
37: l_count NUMBER;
38:

Line 49: FROM CN_OBJECTS

45: x_note_id NUMBER;
46:
47: CURSOR get_object_name(x_object_id NUMBER, x_org_id NUMBER) IS
48: SELECT name
49: FROM CN_OBJECTS
50: WHERE object_id = x_object_id
51: AND org_id = x_org_id;
52:
53:

Line 198: FROM CN_OBJECTS

194: --+ WHERE column_id = p_table_map_rec.source_tbl_pkcol_id;
195:
196: SELECT table_id
197: INTO p_table_map_rec.source_table_id
198: FROM CN_OBJECTS
199: WHERE object_type = 'COL'
200: AND object_id = p_table_map_rec.source_tbl_pkcol_id
201: AND org_id = p_table_map_rec.org_id;
202:

Line 210: FROM cn_objects

206: --+
207:
208: SELECT object_id
209: INTO p_table_map_rec.destination_table_id
210: FROM cn_objects
211: WHERE name = 'CN_COMM_LINES_API'
212: AND org_id = p_table_map_rec.org_id;
213:
214: --+ Create Table Map that points to Module

Line 442: l_pkg_spec_id cn_objects.object_id%TYPE;

438: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Map';
439: l_api_version CONSTANT NUMBER := 1.0;
440: l_rowid ROWID;
441: l_event_id cn_events.event_id%TYPE;
442: l_pkg_spec_id cn_objects.object_id%TYPE;
443: l_pkg_body_id cn_objects.object_id%TYPE;
444:
445: CURSOR c_table_map IS
446: SELECT * FROM cn_table_maps_v

Line 443: l_pkg_body_id cn_objects.object_id%TYPE;

439: l_api_version CONSTANT NUMBER := 1.0;
440: l_rowid ROWID;
441: l_event_id cn_events.event_id%TYPE;
442: l_pkg_spec_id cn_objects.object_id%TYPE;
443: l_pkg_body_id cn_objects.object_id%TYPE;
444:
445: CURSOR c_table_map IS
446: SELECT * FROM cn_table_maps_v
447: WHERE table_map_id = p_table_map_id

Line 458: FROM cn_objects

454: l_org_append VARCHAR2(100) ;
455:
456: CURSOR l_pks_csr(p_mapping_type VARCHAR2,p_org_append VARCHAR2) IS
457: SELECT object_id
458: FROM cn_objects
459: WHERE object_type = 'PKS'
460: AND name = 'cn_collect_'||LOWER(p_mapping_type)||p_org_append
461: AND org_id = p_org_id; -- Added For MOAC
462:

Line 465: FROM cn_objects

461: AND org_id = p_org_id; -- Added For MOAC
462:
463: CURSOR l_pkb_csr(p_mapping_type VARCHAR2,p_org_append VARCHAR2) IS
464: SELECT object_id
465: FROM cn_objects
466: WHERE object_type = 'PKB'
467: AND name = 'cn_collect_'||LOWER(p_mapping_type)||p_org_append
468: AND org_id = p_org_id; -- Added For MOAC
469:

Line 535: -- FROM cn_objects

531: --+
532:
533: -- SELECT object_id
534: -- INTO l_pkg_spec_id
535: -- FROM cn_objects
536: -- WHERE object_type = 'PKS'
537: -- AND name = 'cn_collect_'||LOWER(l_table_map_rec.mapping_type)||l_org_append;
538: -- SELECT object_id
539: -- INTO l_pkg_body_id

Line 540: -- FROM cn_objects

536: -- WHERE object_type = 'PKS'
537: -- AND name = 'cn_collect_'||LOWER(l_table_map_rec.mapping_type)||l_org_append;
538: -- SELECT object_id
539: -- INTO l_pkg_body_id
540: -- FROM cn_objects
541: -- WHERE object_type = 'PKB'
542: -- AND name = 'cn_collect_'||LOWER(l_table_map_rec.mapping_type)||l_org_append;
543:
544: OPEN l_pks_csr(l_table_map_rec.mapping_type, l_org_append);

Line 553: DELETE FROM cn_objects WHERE object_id IN (l_pkg_spec_id, l_pkg_body_id);

549: FETCH l_pkb_csr INTO l_pkg_body_id;
550: CLOSE l_pkb_csr;
551:
552: DELETE FROM cn_source WHERE object_id IN (l_pkg_spec_id, l_pkg_body_id);
553: DELETE FROM cn_objects WHERE object_id IN (l_pkg_spec_id, l_pkg_body_id);
554: --+
555: -- Delete Table Map Objects
556: --+
557: FOR rec IN

Line 651: l_ovn_obj_number cn_objects.object_version_number%TYPE;

647: IS
648:
649: l_api_name CONSTANT VARCHAR2(30) := 'Update_Table_Map_Objects';
650: l_api_version CONSTANT NUMBER := 1.0;
651: l_ovn_obj_number cn_objects.object_version_number%TYPE;
652: l_ovn_tbl_number cn_table_maps.object_version_number%TYPE;
653:
654: l_org_id NUMBER; -- Added For R12 MOAC
655:

Line 658: FROM cn_objects

654: l_org_id NUMBER; -- Added For R12 MOAC
655:
656: CURSOR l_ovn_obj IS
657: SELECT object_version_number
658: FROM cn_objects
659: WHERE object_id = p_object_id
660: AND org_id = x_org_id; -- Added For R12 MOAC
661:
662: CURSOR l_ovn_tbl IS

Line 721: UPDATE CN_OBJECTS

717: WHERE table_map_id = p_table_map_id
718: AND org_id = l_org_id;
719: END IF;
720:
721: UPDATE CN_OBJECTS
722: SET NAME = p_object_name,
723: OBJECT_VALUE = p_object_value
724: WHERE OBJECT_ID = p_object_id
725: AND org_id = l_org_id;

Line 920: -- does not yet exist in CN_OBJECTS. If you are creating a

916: ------------------------------------------------------------------------------+
917: -- Procedure : Create_Table_Map_Object
918: ------------------------------------------------------------------------------+
919: -- WARNING: only use this procedure to create a table map object that
920: -- does not yet exist in CN_OBJECTS. If you are creating a
921: -- table map object which references an existing object (for
922: -- example an Extra Collection Table) then just use the
923: -- cn_table_map_objects_pkg.insert_row procedure.
924: PROCEDURE Create_Table_Map_Object (

Line 977: SELECT cn_objects_s.NEXTVAL

973: WHERE module_type = 'COL' -- name = 'Collection';
974: AND org_id = x_org_id; -- MOAC Change Need To Verify
975: --+
976:
977: SELECT cn_objects_s.NEXTVAL
978: INTO x_object_id
979: FROM dual;
980: --+
981: -- Create the object in CN_OBJECTS

Line 981: -- Create the object in CN_OBJECTS

977: SELECT cn_objects_s.NEXTVAL
978: INTO x_object_id
979: FROM dual;
980: --+
981: -- Create the object in CN_OBJECTS
982: --+
983:
984: cn_objects_pkg.insert_row(
985: x_rowid => l_rowid,

Line 984: cn_objects_pkg.insert_row(

980: --+
981: -- Create the object in CN_OBJECTS
982: --+
983:
984: cn_objects_pkg.insert_row(
985: x_rowid => l_rowid,
986: x_object_id => x_object_id,
987: x_dependency_map_complete => 'N',
988: x_name => p_object_name,

Line 1103: -- Delete the object in CN_OBJECTS

1099: -------------------+
1100: -- API body
1101: -------------------+
1102: --+
1103: -- Delete the object in CN_OBJECTS
1104: --+
1105: FOR del IN del_tbmp
1106: LOOP
1107: DELETE FROM cn_objects WHERE object_id = del.object_id;

Line 1107: DELETE FROM cn_objects WHERE object_id = del.object_id;

1103: -- Delete the object in CN_OBJECTS
1104: --+
1105: FOR del IN del_tbmp
1106: LOOP
1107: DELETE FROM cn_objects WHERE object_id = del.object_id;
1108: END LOOP;
1109: --+
1110: -- Delete the reference to the object in CN_TABLE_MAP_OBJECTS
1111: --+

Line 1256: cn_objects obj

1252: -- Add to the Collect_From list any extra collection tables that have been specified
1253: --+
1254: (SELECT LOWER(obj.name||' '||NVL(obj.alias,obj.name)) name
1255: FROM cn_table_map_objects tmobj,
1256: cn_objects obj
1257: WHERE tmobj.table_map_id = l_c1_rec.table_map_id
1258: AND tmobj.tm_object_type = 'COLLTAB'
1259: AND obj.object_id = tmobj.object_id
1260: AND obj.org_id = p_org_id AND obj.org_id = tmobj.org_id)