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_TABLE_MAP_OBJECTS

Line 35: l_table_map_object_id cn_table_map_objects.object_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:
39: -- Variable For ORG_ID Value - MOAC Change

Line 561: FROM cn_table_map_objects

557: FOR rec IN
558: (SELECT table_map_object_id,
559: UPPER(tm_object_type) tm_object_type,
560: object_id
561: FROM cn_table_map_objects
562: WHERE table_map_id = p_table_map_id
563: AND org_id = p_org_id) -- Added For R12 MOAC
564: LOOP
565: IF rec.tm_object_type IN ('PARAM','FILTER','PKS','PKB') THEN

Line 581: cn_table_map_objects_pkg.delete_row(rec.table_map_object_id,p_org_id);

577: --+
578: -- Collections only created the reference to the object, so just
579: -- delete that.
580: --+
581: cn_table_map_objects_pkg.delete_row(rec.table_map_object_id,p_org_id);
582: END IF;
583: END LOOP;
584: -------------------+
585: -- End of API body.

Line 923: -- cn_table_map_objects_pkg.insert_row procedure.

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 (
925: p_api_version IN NUMBER,
926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
927: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 998: -- Create the reference to the object in CN_TABLE_MAP_OBJECTS

994: x_synchronization_frequency => NULL,
995: x_object_status => 'A',
996: X_org_id => l_org_id);
997: --+
998: -- Create the reference to the object in CN_TABLE_MAP_OBJECTS
999: --+
1000:
1001: cn_table_map_objects_pkg.insert_row(
1002: x_rowid => l_rowid,

Line 1001: cn_table_map_objects_pkg.insert_row(

997: --+
998: -- Create the reference to the object in CN_TABLE_MAP_OBJECTS
999: --+
1000:
1001: cn_table_map_objects_pkg.insert_row(
1002: x_rowid => l_rowid,
1003: x_table_map_object_id => x_table_map_object_id, --set inside procedure
1004: x_tm_object_type => UPPER(p_tm_object_type),
1005: x_table_map_id => p_table_map_id,

Line 1058: -- Query Parameters. If you only want to delete the CN_TABLE_MAP_OBJECTS

1054: ------------------------------------------------------------------------------+
1055: -- Procedure : Delete_Table_Map_Object
1056: ------------------------------------------------------------------------------+
1057: -- WARNING: Use this procedure for deleting objects like Notification
1058: -- Query Parameters. If you only want to delete the CN_TABLE_MAP_OBJECTS
1059: -- references to an object (for example an Extra Collection Table)
1060: -- then just use the cn_table_map_objects_pkg.delete_row procedure.
1061: PROCEDURE Delete_Table_Map_Object (
1062: p_api_version IN NUMBER,

Line 1060: -- then just use the cn_table_map_objects_pkg.delete_row procedure.

1056: ------------------------------------------------------------------------------+
1057: -- WARNING: Use this procedure for deleting objects like Notification
1058: -- Query Parameters. If you only want to delete the CN_TABLE_MAP_OBJECTS
1059: -- references to an object (for example an Extra Collection Table)
1060: -- then just use the cn_table_map_objects_pkg.delete_row procedure.
1061: PROCEDURE Delete_Table_Map_Object (
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 1078: FROM cn_table_map_objects

1074: l_object_id NUMBER;
1075:
1076: CURSOR del_tbmp IS
1077: SELECT object_id
1078: FROM cn_table_map_objects
1079: WHERE table_map_object_id = p_table_map_object_id
1080: AND org_id = x_org_id;
1081:
1082: BEGIN

Line 1110: -- Delete the reference to the object in CN_TABLE_MAP_OBJECTS

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: --+
1112: cn_table_map_objects_pkg.delete_row(
1113: x_table_map_object_id => p_table_map_object_id,
1114: x_org_id => x_org_id); -- Added For R12 MOAC

Line 1112: cn_table_map_objects_pkg.delete_row(

1108: END LOOP;
1109: --+
1110: -- Delete the reference to the object in CN_TABLE_MAP_OBJECTS
1111: --+
1112: cn_table_map_objects_pkg.delete_row(
1113: x_table_map_object_id => p_table_map_object_id,
1114: x_org_id => x_org_id); -- Added For R12 MOAC
1115: -------------------+
1116: -- End of API body.

Line 1255: FROM cn_table_map_objects tmobj,

1251: --+
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