944: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
945:
946: FUNCTION GenerateCcidExtract
947: (p_extract_type IN VARCHAR2,
948: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
949:
950: l_array_pkg DBMS_SQL.VARCHAR2S;
951: l_BodyPkg VARCHAR2(32000);
952: l_array_body DBMS_SQL.VARCHAR2S;
946: FUNCTION GenerateCcidExtract
947: (p_extract_type IN VARCHAR2,
948: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
949:
950: l_array_pkg DBMS_SQL.VARCHAR2S;
951: l_BodyPkg VARCHAR2(32000);
952: l_array_body DBMS_SQL.VARCHAR2S;
953: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
954:
948: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
949:
950: l_array_pkg DBMS_SQL.VARCHAR2S;
951: l_BodyPkg VARCHAR2(32000);
952: l_array_body DBMS_SQL.VARCHAR2S;
953: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
954:
955: BEGIN
956: