340: , p_mpa_jlt_type_code IN VARCHAR2
341: , p_mpa_jlt_code IN VARCHAR2
342: , p_bflow_method_code IN VARCHAR2 -- 4655713
343: --
344: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
345: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_byInt
346: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
347: )
348: RETURN CLOB
341: , p_mpa_jlt_code IN VARCHAR2
342: , p_bflow_method_code IN VARCHAR2 -- 4655713
343: --
344: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
345: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_byInt
346: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
347: )
348: RETURN CLOB
349: IS
342: , p_bflow_method_code IN VARCHAR2 -- 4655713
343: --
344: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
345: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_byInt
346: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
347: )
348: RETURN CLOB
349: IS
350: CURSOR adr_cur IS
380: ORDER BY decode(xldj.FLEXFIELD_SEGMENT_CODE,'ALL',1,2), -- 4655713 process ALL segments first
381: xldj.segment_rule_code
382: ;
383:
384: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
381: xldj.segment_rule_code
382: ;
383:
384: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
382: ;
383:
384: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
383:
384: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
391: l_array_transaction_coa_id xla_cmp_source_pkg.t_array_NUM;
384: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
391: l_array_transaction_coa_id xla_cmp_source_pkg.t_array_NUM;
392:
385: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
391: l_array_transaction_coa_id xla_cmp_source_pkg.t_array_NUM;
392:
393: l_adrs CLOB;
386: l_array_adr_segment_code xla_cmp_source_pkg.t_array_VL30;
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
391: l_array_transaction_coa_id xla_cmp_source_pkg.t_array_NUM;
392:
393: l_adrs CLOB;
394: l_log_module VARCHAR2(240);
387: l_array_side_code xla_cmp_source_pkg.t_array_VL30;
388: l_array_adr_appl_id xla_cmp_source_pkg.t_array_NUM;
389: l_array_inherit_adr_flag xla_cmp_source_pkg.t_array_VL1;
390: l_array_accounting_coa_id xla_cmp_source_pkg.t_array_NUM;
391: l_array_transaction_coa_id xla_cmp_source_pkg.t_array_NUM;
392:
393: l_adrs CLOB;
394: l_log_module VARCHAR2(240);
395:
499: , p_rounding_class_code IN VARCHAR2
500: , p_bflow_method_code IN VARCHAR2 -- 4655713
501: , p_inherit_desc_flag IN VARCHAR2 -- 4655713b
502: --
503: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
504: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
505: , p_IsCompiled OUT NOCOPY BOOLEAN
506: )
507: RETURN DBMS_SQL.VARCHAR2S
500: , p_bflow_method_code IN VARCHAR2 -- 4655713
501: , p_inherit_desc_flag IN VARCHAR2 -- 4655713b
502: --
503: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
504: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
505: , p_IsCompiled OUT NOCOPY BOOLEAN
506: )
507: RETURN DBMS_SQL.VARCHAR2S
508: IS
512: l_jlt CLOB;
513: l_ObjectIndex BINARY_INTEGER;
514: l_array_jlt DBMS_SQL.VARCHAR2S;
515:
516: l_array_mpa_jlt_source_index xla_cmp_source_pkg.t_array_ByInt;
517: l_array_null_mpa_jlt_src_idx xla_cmp_source_pkg.t_array_ByInt;
518: l_log_module VARCHAR2(240);
519:
520: BEGIN
513: l_ObjectIndex BINARY_INTEGER;
514: l_array_jlt DBMS_SQL.VARCHAR2S;
515:
516: l_array_mpa_jlt_source_index xla_cmp_source_pkg.t_array_ByInt;
517: l_array_null_mpa_jlt_src_idx xla_cmp_source_pkg.t_array_ByInt;
518: l_log_module VARCHAR2(240);
519:
520: BEGIN
521:
633: ,l_array_mpa_jlt_source_index -- IN OUT
634: ,p_rec_sources)
635: );
636: --
637: l_parameters := xla_cmp_source_pkg.GenerateParameters(
638: p_array_source_index => l_array_mpa_jlt_source_index
639: , p_rec_sources => p_rec_sources
640: ) ;
641: --
646: END IF;
647:
648: --
649:
650: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
651: p_object => xla_cmp_source_pkg.C_RECOG_JLT
652: , p_object_code => p_mpa_jlt_code
653: , p_object_type_code => p_mpa_jlt_owner_code
654: , p_application_id => p_application_id
647:
648: --
649:
650: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
651: p_object => xla_cmp_source_pkg.C_RECOG_JLT
652: , p_object_code => p_mpa_jlt_code
653: , p_object_type_code => p_mpa_jlt_owner_code
654: , p_application_id => p_application_id
655: , p_event_class_code => p_event_class_code
728: p_product_rule_code IN VARCHAR2
729: , p_product_rule_type_code IN VARCHAR2
730: , p_application_id IN NUMBER
731: , p_amb_context_code IN VARCHAR2
732: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
733: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
734: , p_IsCompiled OUT NOCOPY BOOLEAN
735: )
736: RETURN DBMS_SQL.VARCHAR2S
729: , p_product_rule_type_code IN VARCHAR2
730: , p_application_id IN NUMBER
731: , p_amb_context_code IN VARCHAR2
732: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
733: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
734: , p_IsCompiled OUT NOCOPY BOOLEAN
735: )
736: RETURN DBMS_SQL.VARCHAR2S
737: IS
844: --
845: l_body DBMS_SQL.VARCHAR2S;
846: l_jlt DBMS_SQL.VARCHAR2S;
847: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
845: l_body DBMS_SQL.VARCHAR2S;
846: l_jlt DBMS_SQL.VARCHAR2S;
847: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
846: l_jlt DBMS_SQL.VARCHAR2S;
847: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
851: --
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
852: l_array_desc_type_code xla_cmp_source_pkg.t_array_VL1;
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
853: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
854: --
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
855: l_array_entry_type_code xla_cmp_source_pkg.t_array_VL1;
856: l_array_natural_side_code xla_cmp_source_pkg.t_array_VL1;
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
857: l_array_transfer_mode xla_cmp_source_pkg.t_array_VL1;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
858: l_array_switch_side_flag xla_cmp_source_pkg.t_array_VL1;
859: l_array_merge_code xla_cmp_source_pkg.t_array_VL1;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
860: --
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
861: l_array_acct_class_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
862: l_array_rounding_class_code xla_cmp_source_pkg.t_array_VL30;
863: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
870: --
864: l_array_entity_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
870: --
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
865: l_array_class_code xla_cmp_source_pkg.t_array_VL30;
866: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
870: --
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
873: --
867: --
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
870: --
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
873: --
874: l_array_bflow_method_code xla_cmp_source_pkg.t_array_VL30; -- 4655713
875: l_array_inherit_desc_flag xla_cmp_source_pkg.t_array_VL1; -- 4655713b
868: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
869: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
870: --
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
873: --
874: l_array_bflow_method_code xla_cmp_source_pkg.t_array_VL30; -- 4655713
875: l_array_inherit_desc_flag xla_cmp_source_pkg.t_array_VL1; -- 4655713b
876:
870: --
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
873: --
874: l_array_bflow_method_code xla_cmp_source_pkg.t_array_VL30; -- 4655713
875: l_array_inherit_desc_flag xla_cmp_source_pkg.t_array_VL1; -- 4655713b
876:
877: --
878: l_IsCompiled BOOLEAN;
871: l_array_accrual_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
872: l_array_accrual_jlt_code xla_cmp_source_pkg.t_array_VL30;
873: --
874: l_array_bflow_method_code xla_cmp_source_pkg.t_array_VL30; -- 4655713
875: l_array_inherit_desc_flag xla_cmp_source_pkg.t_array_VL1; -- 4655713b
876:
877: --
878: l_IsCompiled BOOLEAN;
879: l_number NUMBER;
1015: , p_product_rule_type_code IN VARCHAR2
1016: , p_application_id IN NUMBER
1017: , p_amb_context_code IN VARCHAR2
1018: , p_package_name IN VARCHAR2
1019: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1020: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1021: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1022: )
1023: RETURN BOOLEAN
1016: , p_application_id IN NUMBER
1017: , p_amb_context_code IN VARCHAR2
1018: , p_package_name IN VARCHAR2
1019: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1020: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1021: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1022: )
1023: RETURN BOOLEAN
1024: IS