756: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_xla_cmp_header_pkg.';
757:
758: FUNCTION GenerateCcidExtract
759: (p_extract_type IN VARCHAR2,
760: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
761:
762: l_array_pkg DBMS_SQL.VARCHAR2S;
763: l_BodyPkg VARCHAR2(32000);
764: l_array_body DBMS_SQL.VARCHAR2S;
758: FUNCTION GenerateCcidExtract
759: (p_extract_type IN VARCHAR2,
760: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
761:
762: l_array_pkg DBMS_SQL.VARCHAR2S;
763: l_BodyPkg VARCHAR2(32000);
764: l_array_body DBMS_SQL.VARCHAR2S;
765: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
766:
760: p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S) RETURN BOOLEAN IS
761:
762: l_array_pkg DBMS_SQL.VARCHAR2S;
763: l_BodyPkg VARCHAR2(32000);
764: l_array_body DBMS_SQL.VARCHAR2S;
765: l_procedure_name varchar2(80) := 'GenerateLoadExtract';
766:
767: BEGIN
768: