219: +---------------------------------------------------------------------------*/
220:
221: FUNCTION generate_desc_details (
222: p_description_prio_id IN NUMBER
223: , p_array_desc_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
224: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
225: )
226: RETURN VARCHAR2
227: IS
220:
221: FUNCTION generate_desc_details (
222: p_description_prio_id IN NUMBER
223: , p_array_desc_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
224: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
225: )
226: RETURN VARCHAR2
227: IS
228:
331: l_desc_detail := NULL;
332:
333: IF desc_details_rec.value_type_code = 'S' THEN
334: -- source
335: l_Index:= xla_cmp_source_pkg.StackSource (
336: p_source_code => desc_details_rec.source_code
337: , p_source_type_code => desc_details_rec.source_type_code
338: , p_source_application_id => desc_details_rec.source_application_id
339: , p_array_source_index => p_array_desc_source_index
349:
350: IF desc_details_rec.flexfield_segment_code IS NULL THEN
351: --not key flexfield
352: l_desc_detail := REPLACE(l_desc_detail,
353: '$source$', nvl(xla_cmp_source_pkg.GenerateSource(
354: p_Index => l_Index
355: , p_rec_sources => p_rec_sources
356: , p_translated_flag => 'Y'),' null')
357: );
361:
362: l_desc_detail := REPLACE(l_desc_detail, '$source$', C_FLEXFIELD_SEGMENT);
363:
364: l_desc_detail := REPLACE(l_desc_detail,'$ccid$',
365: xla_cmp_source_pkg.GenerateSource(
366: p_Index => l_Index
367: , p_rec_sources => p_rec_sources
368: , p_translated_flag => 'N')
369: );
396: l_desc_detail := REPLACE(l_desc_detail,
397: '$source$', C_FLEXFIELD_DESC);
398:
399: l_desc_detail := REPLACE(l_desc_detail,'$ccid$',
400: xla_cmp_source_pkg.GenerateSource(
401: p_Index => l_Index
402: , p_rec_sources => p_rec_sources
403: , p_translated_flag => 'N')
404: );
501: , p_amb_context_code IN VARCHAR2
502: , p_description_code IN VARCHAR2
503: , p_description_type_code IN VARCHAR2
504: , p_description_name IN VARCHAR2
505: , p_array_desc_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
506: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
507: , p_IsCompiled IN OUT NOCOPY BOOLEAN
508: )
509: RETURN CLOB
502: , p_description_code IN VARCHAR2
503: , p_description_type_code IN VARCHAR2
504: , p_description_name IN VARCHAR2
505: , p_array_desc_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
506: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
507: , p_IsCompiled IN OUT NOCOPY BOOLEAN
508: )
509: RETURN CLOB
510: IS
658: , p_description_code IN VARCHAR2
659: , p_description_type_code IN VARCHAR2
660: , p_description_name IN VARCHAR2
661: , p_description_level IN VARCHAR2
662: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
663: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
664: , p_IsCompiled IN OUT NOCOPY BOOLEAN
665: )
666: RETURN DBMS_SQL.VARCHAR2S
659: , p_description_type_code IN VARCHAR2
660: , p_description_name IN VARCHAR2
661: , p_description_level IN VARCHAR2
662: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
663: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
664: , p_IsCompiled IN OUT NOCOPY BOOLEAN
665: )
666: RETURN DBMS_SQL.VARCHAR2S
667: IS
669: l_array_desc DBMS_SQL.VARCHAR2S;
670: l_null_array_desc DBMS_SQL.VARCHAR2S;
671: l_description CLOB;
672: l_description_code VARCHAR2(30);
673: l_array_desc_source_index xla_cmp_source_pkg.t_array_ByInt;
674: l_log_module VARCHAR2(240);
675: BEGIN
676: IF g_log_enabled THEN
677: l_log_module := C_DEFAULT_MODULE||'.generate_desc_fct';
713: )
714: );
715:
716: l_description := xla_cmp_string_pkg.replace_token(l_description, '$parameters$' ,
717: xla_cmp_source_pkg.GenerateParameters(
718: p_array_source_index => l_array_desc_source_index
719: , p_rec_sources => p_rec_sources)
720: );
721:
719: , p_rec_sources => p_rec_sources)
720: );
721:
722: l_description := xla_cmp_string_pkg.replace_token(l_description, '$desc_hash_id$' , -- 4417664
723: TO_CHAR(xla_cmp_source_pkg.CacheAADObject (
724: p_object => p_description_level
725: , p_object_code => p_description_code
726: , p_object_type_code => p_description_type_code
727: , p_application_id => p_application_id
784: p_product_rule_code IN VARCHAR2
785: , p_product_rule_type_code IN VARCHAR2
786: , p_application_id IN NUMBER
787: , p_amb_context_code IN VARCHAR2
788: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
789: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
790: , p_IsCompiled IN OUT NOCOPY BOOLEAN
791: )
792: RETURN DBMS_SQL.VARCHAR2S
785: , p_product_rule_type_code IN VARCHAR2
786: , p_application_id IN NUMBER
787: , p_amb_context_code IN VARCHAR2
788: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
789: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
790: , p_IsCompiled IN OUT NOCOPY BOOLEAN
791: )
792: RETURN DBMS_SQL.VARCHAR2S
793: IS
1016: AND xld.budgetary_control_flag = XLA_CMP_PAD_PKG.g_bc_pkg_flag
1017: )
1018: ;
1019:
1020: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
1021: l_array_desc_name xla_cmp_source_pkg.t_array_VL80;
1022: l_array_desc_owner xla_cmp_source_pkg.t_array_VL1;
1023:
1024: l_descriptions DBMS_SQL.VARCHAR2S;
1017: )
1018: ;
1019:
1020: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
1021: l_array_desc_name xla_cmp_source_pkg.t_array_VL80;
1022: l_array_desc_owner xla_cmp_source_pkg.t_array_VL1;
1023:
1024: l_descriptions DBMS_SQL.VARCHAR2S;
1025: l_null_descriptions DBMS_SQL.VARCHAR2S;
1018: ;
1019:
1020: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
1021: l_array_desc_name xla_cmp_source_pkg.t_array_VL80;
1022: l_array_desc_owner xla_cmp_source_pkg.t_array_VL1;
1023:
1024: l_descriptions DBMS_SQL.VARCHAR2S;
1025: l_null_descriptions DBMS_SQL.VARCHAR2S;
1026:
1077: , p_amb_context_code => p_amb_context_code
1078: , p_description_code => l_array_desc_code(Idx)
1079: , p_description_type_code => l_array_desc_owner(Idx)
1080: , p_description_name => l_array_desc_name(Idx)
1081: , p_description_level => xla_cmp_source_pkg.C_DESC
1082: , p_rec_aad_objects => p_rec_aad_objects
1083: , p_rec_sources => p_rec_sources
1084: , p_IsCompiled => l_IsCompiled )
1085: );
1135: , p_product_rule_type_code IN VARCHAR2
1136: , p_application_id IN NUMBER
1137: , p_amb_context_code IN VARCHAR2
1138: , p_package_name IN VARCHAR2
1139: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1140: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1141: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1142: )
1143: RETURN BOOLEAN
1136: , p_application_id IN NUMBER
1137: , p_amb_context_code IN VARCHAR2
1138: , p_package_name IN VARCHAR2
1139: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1140: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1141: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1142: )
1143: RETURN BOOLEAN
1144: IS