283: l_master_type VARCHAR2(80);
284: l_master_type_id NUMBER;
285: l_source_object_name VARCHAR2(80);
286: l_source_object_pk_field VARCHAR2(80);
287: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;
288: l_from_position NUMBER;
289: l_from_counter NUMBER;
290: l_end_position NUMBER;
291: l_end_counter NUMBER;
324: l_length := length(l_string_copy);
325: END LOOP;
326:
327: l_found := 'N';
328: AMS_ListGeneration_PKG.validate_sql_string(
329: p_sql_string => l_sql_string_tbl ,
330: p_search_string => 'FROM',
331: p_comma_valid => 'N',
332: x_found => l_found,
335:
336:
337: l_found := 'N';
338:
339: AMS_ListGeneration_PKG.get_master_types (
340: p_sql_string => l_sql_string_tbl,
341: p_start_length => 1,
342: p_start_counter => 1,
343: p_end_length => l_from_position,
578: l_master_type VARCHAR2(80);
579: l_master_type_id NUMBER;
580: l_source_object_name VARCHAR2(80);
581: l_source_object_pk_field VARCHAR2(80);
582: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;
583: l_from_position NUMBER;
584: l_from_counter NUMBER;
585: l_end_position NUMBER;
586: l_end_counter NUMBER;
619: l_length := length(l_string_copy);
620: END LOOP;
621:
622: l_found := 'N';
623: AMS_ListGeneration_PKG.validate_sql_string(
624: p_sql_string => l_sql_string_tbl ,
625: p_search_string => 'FROM',
626: p_comma_valid => 'N',
627: x_found => l_found,
630:
631:
632: l_found := 'N';
633:
634: AMS_ListGeneration_PKG.get_master_types (
635: p_sql_string => l_sql_string_tbl,
636: p_start_length => 1,
637: p_start_counter => 1,
638: p_end_length => l_from_position,