APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_OBJECTS

Line 61: cn_objects obj

57: IS
58: SELECT tmov.object_id,
59: LOWER(OBJ.name) object_name
60: FROM cn_table_map_objects tmov,
61: cn_objects obj
62: WHERE tmov.table_map_id = x_table_map_id
63: AND tmov.tm_object_type = 'PARAM'
64: AND obj.object_id = tmov.object_id
65: AND tmov.org_id = obj.org_id

Line 116: cn_utils.appindcr(code, rec.object_name||' cn_objects.object_value%TYPE;');

112: cn_utils.indent(code, 1);
113: cn_utils.appindcr(code, '--*** Declaring user-defined Notification Parameters');
114: FOR rec IN c_param
115: LOOP
116: cn_utils.appindcr(code, rec.object_name||' cn_objects.object_value%TYPE;');
117: END LOOP;
118: cn_utils.unindent(code, 1);
119: cn_utils.appindcr(code, 'BEGIN');
120: --+

Line 129: cn_utils.appindcr(code, 'FROM cn_objects');

125: FOR rec IN c_param
126: LOOP
127: cn_utils.appindcr(code, 'SELECT object_value');
128: cn_utils.appindcr(code, 'INTO '||rec.object_name);
129: cn_utils.appindcr(code, 'FROM cn_objects');
130: cn_utils.appindcr(code, 'WHERE object_id = '||rec.object_id||' --*** Object_Id for '||rec.object_name);
131: cn_utils.appindcr(code, 'AND org_id = '||l_org_id||';');
132: cn_utils.appendcr(code);
133: END LOOP;

Line 288: cn_objects cno

284: SELECT column_map_id,
285: expression,
286: cno.NAME dest_column
287: FROM cn_column_maps ccmv,
288: cn_objects cno
289: WHERE ccmv.table_map_id = x_table_map_id
290: AND ccmv.expression IS NOT NULL
291: AND ccmv.calc_ext_table_id IS NULL
292: AND ccmv.update_clause IS NULL

Line 527: cn_objects obj

523: LOWER(destcol.name) dest_column
524: FROM cn_column_maps cm,
525: cn_obj_columns_v destcol,
526: cn_calc_ext_tables ext,
527: cn_objects obj
528: WHERE cm.table_map_id = x_table_map_id
529: AND cm.expression IS NOT NULL
530: AND (cm.calc_ext_table_id IS NOT NULL
531: OR cm.update_clause IS NOT NULL)

Line 566: CN_OBJECTS CB

562: LOWER(NVL(cB.alias , cB.name))
563: INTO x_dest_table_name,
564: x_dest_alias
565: FROM cn_table_maps ctm,
566: CN_OBJECTS CB
567: WHERE ctm.table_map_id = x_table_map_id
568: AND CB.object_id = CTM.destination_table_id
569: AND cb.org_id = ctm.org_id
570: AND cb.org_id =x_org_id;

Line 690: cn_objects obj

686: CURSOR c_filter
687: IS
688: SELECT OBJ.object_value
689: FROM cn_table_map_objects tmov,
690: cn_objects obj
691: WHERE tmov.table_map_id = x_table_map_id
692: AND tmov.tm_object_type = 'FILTER'
693: AND tmov.object_id = obj.object_id
694: AND tmov.org_id = obj.org_id

Line 778: cn_objects obj

774: END IF;
775: FOR rec IN
776: (SELECT OBJ.object_value
777: FROM cn_table_map_objects tmov,
778: cn_objects obj
779: WHERE tmov.table_map_id = p_table_map_id
780: AND obj.object_id = tmov.object_id
781: AND tmov.org_id = obj.org_id
782: AND tmov.tm_object_type = 'USERCODE'