DBA Data[Home] [Help]

APPS.BIM_I_SGMT_FACTS_PKG dependencies on AMS_LISTGENERATION_PKG

Line 299: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;

295: l_master_type VARCHAR2(80);
296: l_master_type_id NUMBER;
297: l_source_object_name VARCHAR2(80);
298: l_source_object_pk_field VARCHAR2(80);
299: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;
300: l_from_position NUMBER;
301: l_from_counter NUMBER;
302: l_end_position NUMBER;
303: l_end_counter NUMBER;

Line 340: AMS_ListGeneration_PKG.validate_sql_string(

336: l_length := length(l_string_copy);
337: END LOOP;
338:
339: l_found := 'N';
340: AMS_ListGeneration_PKG.validate_sql_string(
341: p_sql_string => l_sql_string_tbl ,
342: p_search_string => 'FROM',
343: p_comma_valid => 'N',
344: x_found => l_found,

Line 351: AMS_ListGeneration_PKG.get_master_types (

347:
348:
349: l_found := 'N';
350:
351: AMS_ListGeneration_PKG.get_master_types (
352: p_sql_string => l_sql_string_tbl,
353: p_start_length => 1,
354: p_start_counter => 1,
355: p_end_length => l_from_position,

Line 713: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;

709: l_master_type VARCHAR2(80);
710: l_master_type_id NUMBER;
711: l_source_object_name VARCHAR2(80);
712: l_source_object_pk_field VARCHAR2(80);
713: l_sql_string_tbl AMS_ListGeneration_PKG.sql_string;
714: l_from_position NUMBER;
715: l_from_counter NUMBER;
716: l_end_position NUMBER;
717: l_end_counter NUMBER;

Line 754: AMS_ListGeneration_PKG.validate_sql_string(

750: l_length := length(l_string_copy);
751: END LOOP;
752:
753: l_found := 'N';
754: AMS_ListGeneration_PKG.validate_sql_string(
755: p_sql_string => l_sql_string_tbl ,
756: p_search_string => 'FROM',
757: p_comma_valid => 'N',
758: x_found => l_found,

Line 765: AMS_ListGeneration_PKG.get_master_types (

761:
762:
763: l_found := 'N';
764:
765: AMS_ListGeneration_PKG.get_master_types (
766: p_sql_string => l_sql_string_tbl,
767: p_start_length => 1,
768: p_start_counter => 1,
769: p_end_length => l_from_position,