APPS.CN_COLLECTION_OE_GEN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

  PROCEDURE insert_comm_lines_api (
	x_table_map_id		IN cn_table_maps.table_map_id%TYPE,
	x_package_id		IN cn_obj_packages_v.package_id%TYPE,
	procedure_name		IN cn_obj_procedures_v.name%TYPE,
	x_module_id			IN cn_modules.module_id%TYPE,
	x_repository_id 	IN cn_repositories.repository_id%TYPE,
	x_event_id			IN cn_events.event_id%TYPE,
	code				IN OUT	NOCOPY	cn_utils.code_type,
	x_org_id 			IN NUMBER)
  IS
  BEGIN
      l_org_id := x_org_id;

Line: 37

      cn_utils.appendcr(code, '--******** INSERT CN_COMM_LINES_API *********-- ');

Line: 38

      cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Inserting into CN_COMM_LINES_API.'');');

Line: 39

      cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Inserting into CN_COMM_LINES_API.'');');

Line: 50

 	  cn_collection_custom_gen.insert_comm_lines_api_select(x_table_map_id, code,l_org_id, '');

Line: 82

	 cn_collection_custom_gen.insert_comm_lines_api_select(x_table_map_id, code,l_org_id, '');

Line: 96

      cn_utils.appindcr(code, '           SELECT line_id');

Line: 117

	  cn_collection_custom_gen.insert_comm_lines_api_select(x_table_map_id, code,l_org_id,'');

Line: 131

      cn_utils.appindcr(code, '           SELECT line_id');

Line: 150

	  cn_collection_custom_gen.insert_comm_lines_api_select(x_table_map_id, code,l_org_id,'');

Line: 165

      cn_utils.appindcr(code, '           SELECT line_id');

Line: 189

	  cn_collection_custom_gen.insert_comm_lines_api_select(x_table_map_id, code,l_org_id,'');

Line: 201

      cn_utils.appindcr(code, '           SELECT line_id');

Line: 211

      cn_utils.appindcr(code, '           SELECT line_id');

Line: 228

      cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ':Inserted '' || comm_lines_api_count || '' line records into CN_COMM_LINES_API.'');');

Line: 229

      cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ':Inserted '' || comm_lines_api_count || '' line records into CN_COMM_LINES_API.'');');

Line: 240

      cn_utils.appindcr(code, 'UPDATE cn_not_trx cnt');

Line: 247

      cn_utils.appindcr(code, 'cn_message_pkg.debug(''' || procedure_name || ': Updated collected_flag in cn_not_trx.'');');

Line: 248

      cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log, ''' || procedure_name || ': Updated collected_flag in cn_not_trx.'');');

Line: 256

      cn_debug.print_msg('insert_lines: in exception handler for NO_DATA_FOUND',1);

Line: 257

    	fnd_file.put_line(fnd_file.Log, 'insert_lines: in exception handler for NO_DATA_FOUND');

Line: 259

  END insert_comm_lines_api;