APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_OBJECTS

Line 80: FROM cn_table_map_objects tmov, cn_objects obj

76: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';
77:
78: CURSOR c_param IS
79: SELECT tmov.object_id, LOWER(OBJ.name) object_name
80: FROM cn_table_map_objects tmov, cn_objects obj
81: WHERE tmov.table_map_id = x_table_map_id
82: AND tmov.tm_object_type = 'PARAM'
83: and obj.object_id = tmov.object_id
84: and tmov.org_id = obj.org_id

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

141: cn_utils.indent(code, 1);
142: cn_utils.appindcr(code, '--*** Declaring user-defined Notification Parameters');
143: FOR rec IN c_param
144: LOOP
145: cn_utils.appindcr(code, rec.object_name||' cn_objects.object_value%TYPE;');
146: END LOOP;
147: cn_utils.unindent(code, 1);
148: cn_utils.appindcr(code, 'BEGIN');
149: --+

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

154: FOR rec IN c_param
155: LOOP
156: cn_utils.appindcr(code, 'SELECT object_value');
157: cn_utils.appindcr(code, 'INTO '||rec.object_name);
158: cn_utils.appindcr(code, 'FROM cn_objects');
159: cn_utils.appindcr(code, 'WHERE object_id = '||rec.object_id||' --*** Object_Id for '||rec.object_name);
160: cn_utils.appindcr(code, 'AND org_id = '||l_org_id||';');
161: cn_utils.appendcr(code);
162: END LOOP;

Line 335: SELECT column_map_id, expression, cno.NAME dest_column FROM cn_column_maps ccmv, cn_objects cno

331: IS -- Added For R12 MOAC Changes
332:
333:
334: CURSOR api_direct_maps IS
335: SELECT column_map_id, expression, cno.NAME dest_column FROM cn_column_maps ccmv, cn_objects cno
336: WHERE ccmv.table_map_id = x_table_map_id
337: AND ccmv.expression IS NOT NULL
338: AND ccmv.calc_ext_table_id IS NULL
339: AND ccmv.update_clause IS NULL

Line 618: cn_objects obj

614: FROM
615: cn_column_maps cm,
616: cn_obj_columns_v destcol,
617: cn_calc_ext_tables ext,
618: cn_objects obj
619: WHERE
620: cm.table_map_id = x_table_map_id
621: AND cm.expression IS NOT NULL
622: AND (cm.calc_ext_table_id IS NOT NULL

Line 665: FROM cn_table_maps ctm, CN_OBJECTS CB

661:
662: INTO
663: x_dest_table_name,
664: x_dest_alias
665: FROM cn_table_maps ctm, CN_OBJECTS CB
666: WHERE
667: ctm.table_map_id = x_table_map_id
668: and CB.object_id = CTM.destination_table_id
669: and cb.org_id = ctm.org_id

Line 782: FROM cn_table_map_objects tmov, cn_objects obj

778: l_delete_flag VARCHAR2(1);
779: l_statement VARCHAR2(100);
780: CURSOR c_filter IS
781: SELECT OBJ.object_value
782: FROM cn_table_map_objects tmov, cn_objects obj
783: WHERE tmov.table_map_id = x_table_map_id
784: AND tmov.tm_object_type = 'FILTER'
785: and tmov.object_id = obj.object_id
786: and tmov.org_id = obj.org_id

Line 855: FROM cn_table_map_objects tmov, cn_objects obj

851: -- For every line of User Code registered for this location
852: --+
853: FOR rec IN
854: (SELECT OBJ.object_value
855: FROM cn_table_map_objects tmov, cn_objects obj
856: WHERE tmov.table_map_id = p_table_map_id
857: and obj.object_id = tmov.object_id
858: and tmov.org_id = obj.org_id
859: AND tmov.tm_object_type = 'USERCODE'