DBA Data[Home] [Help]

APPS.XLA_CMP_ANALYTIC_CRITERIA_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 206: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

202: , p_application_id IN NUMBER
203: , p_product_rule_code IN VARCHAR2
204: , p_product_rule_type_code IN VARCHAR2
205: , p_amb_context_code IN VARCHAR2
206: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
207: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
208: )
209: IS
210:

Line 207: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

203: , p_product_rule_code IN VARCHAR2
204: , p_product_rule_type_code IN VARCHAR2
205: , p_amb_context_code IN VARCHAR2
206: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
207: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
208: )
209: IS
210:
211: CURSOR source_cur

Line 246: l_source_application_id xla_cmp_source_pkg.t_array_Num;

242: ORDER BY xas.source_type_code, xas.source_code
243: ;
244:
245: l_SourceIdx BINARY_INTEGER;
246: l_source_application_id xla_cmp_source_pkg.t_array_Num;
247: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
248: l_source_code xla_cmp_source_pkg.t_array_VL30;
249: l_log_module VARCHAR2(240);
250: --

Line 247: l_source_type_code xla_cmp_source_pkg.t_array_VL1;

243: ;
244:
245: l_SourceIdx BINARY_INTEGER;
246: l_source_application_id xla_cmp_source_pkg.t_array_Num;
247: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
248: l_source_code xla_cmp_source_pkg.t_array_VL30;
249: l_log_module VARCHAR2(240);
250: --
251: BEGIN

Line 248: l_source_code xla_cmp_source_pkg.t_array_VL30;

244:
245: l_SourceIdx BINARY_INTEGER;
246: l_source_application_id xla_cmp_source_pkg.t_array_Num;
247: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
248: l_source_code xla_cmp_source_pkg.t_array_VL30;
249: l_log_module VARCHAR2(240);
250: --
251: BEGIN
252: IF g_log_enabled THEN

Line 290: l_SourceIdx := xla_cmp_source_pkg.StackSource (

286: IF l_source_code.EXISTS(NVL(l_source_code.FIRST,1)) THEN
287:
288: FOR Idx IN l_source_code.FIRST .. l_source_code.LAST LOOP
289:
290: l_SourceIdx := xla_cmp_source_pkg.StackSource (
291: p_source_code => l_source_code(Idx)
292: , p_source_type_code => l_source_type_code(Idx)
293: , p_source_application_id => l_source_application_id(Idx)
294: , p_array_source_index => p_array_evt_source_index

Line 345: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

341: , p_application_id IN NUMBER
342: , p_entity IN VARCHAR2
343: , p_event_class IN VARCHAR2
344: --
345: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
346: )
347: RETURN CLOB
348: IS
349: --

Line 380: l_array_order xla_cmp_source_pkg.t_array_Num;

376: AND xadb.grouping_order IS NOT NULL
377: ORDER BY xadb.grouping_order
378: ;
379: --
380: l_array_order xla_cmp_source_pkg.t_array_Num;
381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

Line 381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;

377: ORDER BY xadb.grouping_order
378: ;
379: --
380: l_array_order xla_cmp_source_pkg.t_array_Num;
381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;

Line 382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;

378: ;
379: --
380: l_array_order xla_cmp_source_pkg.t_array_Num;
381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
386: --

Line 383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;

379: --
380: l_array_order xla_cmp_source_pkg.t_array_Num;
381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
386: --
387: l_source_Idx BINARY_INTEGER;

Line 384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

380: l_array_order xla_cmp_source_pkg.t_array_Num;
381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
386: --
387: l_source_Idx BINARY_INTEGER;
388: --

Line 385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;

381: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
382: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
383: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
384: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
385: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
386: --
387: l_source_Idx BINARY_INTEGER;
388: --
389: l_analytical_criteria CLOB;

Line 447: l_source_Idx := xla_cmp_source_pkg.CacheSource(

443: l_detail := REPLACE(l_detail,'$Jdx$',TO_CHAR(l_array_order(Idx)));
444:
445: IF l_array_source_code(Idx) IS NOT NULL THEN
446:
447: l_source_Idx := xla_cmp_source_pkg.CacheSource(
448: p_source_code => l_array_source_code(Idx)
449: , p_source_type_code => l_array_source_type_code(Idx)
450: , p_source_application_id => l_array_source_appl_id(Idx)
451: , p_rec_sources => p_rec_sources

Line 455: xla_cmp_source_pkg.GenerateSource(

451: , p_rec_sources => p_rec_sources
452: );
453:
454: l_detail := REPLACE(l_detail,'$detail_value$',
455: xla_cmp_source_pkg.GenerateSource(
456: p_Index => l_source_Idx
457: , p_rec_sources => p_rec_sources
458: , p_variable => 'H'
459: , p_translated_flag => p_criterion_value)

Line 529: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

525: , p_amb_context_code IN VARCHAR2
526: , p_entity IN VARCHAR2
527: , p_event_class IN VARCHAR2
528: , p_event_type IN VARCHAR2
529: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
530: )
531: RETURN CLOB
532: IS
533: --

Line 564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;

560: AND xaht.language(+) = USERENV('LANG')
561: ORDER BY xah.analytical_criterion_type_code, xah.analytical_criterion_code
562: ;
563: --
564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
567: l_array_name xla_cmp_source_pkg.t_array_VL80;
568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;

Line 565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;

561: ORDER BY xah.analytical_criterion_type_code, xah.analytical_criterion_code
562: ;
563: --
564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
567: l_array_name xla_cmp_source_pkg.t_array_VL80;
568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
569: --

Line 566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;

562: ;
563: --
564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
567: l_array_name xla_cmp_source_pkg.t_array_VL80;
568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
569: --
570: l_analytical_criteria CLOB;

Line 567: l_array_name xla_cmp_source_pkg.t_array_VL80;

563: --
564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
567: l_array_name xla_cmp_source_pkg.t_array_VL80;
568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
569: --
570: l_analytical_criteria CLOB;
571: l_log_module VARCHAR2(240);

Line 568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;

564: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
565: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
566: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
567: l_array_name xla_cmp_source_pkg.t_array_VL80;
568: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
569: --
570: l_analytical_criteria CLOB;
571: l_log_module VARCHAR2(240);
572: BEGIN

Line 714: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

710: , p_name IN VARCHAR2
711: , p_application_id IN NUMBER
712: , p_event_class IN VARCHAR2
713: , p_ac_type IN VARCHAR2 -- 4262811
714: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
715: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
716: )
717: RETURN CLOB
718: IS

Line 715: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

711: , p_application_id IN NUMBER
712: , p_event_class IN VARCHAR2
713: , p_ac_type IN VARCHAR2 -- 4262811
714: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
715: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
716: )
717: RETURN CLOB
718: IS
719: --

Line 749: l_array_order xla_cmp_source_pkg.t_array_Num;

745: AND xadb.grouping_order IS NOT NULL
746: ORDER BY xadb.grouping_order
747: ;
748: --
749: l_array_order xla_cmp_source_pkg.t_array_Num;
750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

Line 750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;

746: ORDER BY xadb.grouping_order
747: ;
748: --
749: l_array_order xla_cmp_source_pkg.t_array_Num;
750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;

Line 751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;

747: ;
748: --
749: l_array_order xla_cmp_source_pkg.t_array_Num;
750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
755: --

Line 752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;

748: --
749: l_array_order xla_cmp_source_pkg.t_array_Num;
750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
755: --
756: l_source_Idx BINARY_INTEGER;

Line 753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

749: l_array_order xla_cmp_source_pkg.t_array_Num;
750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
755: --
756: l_source_Idx BINARY_INTEGER;
757: --

Line 754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;

750: l_array_detail_code xla_cmp_source_pkg.t_array_VL30;
751: l_array_data_type xla_cmp_source_pkg.t_array_VL1;
752: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
753: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
754: l_array_source_appl_id xla_cmp_source_pkg.t_array_Num;
755: --
756: l_source_Idx BINARY_INTEGER;
757: --
758: l_analytical_criteria CLOB;

Line 818: l_source_Idx := xla_cmp_source_pkg.StackSource (

814: l_detail := REPLACE(l_detail,'$Jdx$', TO_CHAR(l_array_order(Idx)));
815:
816: IF l_array_source_code(Idx) IS NOT NULL THEN
817:
818: l_source_Idx := xla_cmp_source_pkg.StackSource (
819: p_source_code => l_array_source_code(Idx)
820: , p_source_type_code => l_array_source_type_code(Idx)
821: , p_source_application_id => l_array_source_appl_id(Idx)
822: , p_array_source_index => p_array_alt_source_index

Line 827: xla_cmp_source_pkg.GenerateSource(

823: , p_rec_sources => p_rec_sources
824: );
825:
826: l_detail := REPLACE(l_detail,'$detail_value$',
827: xla_cmp_source_pkg.GenerateSource(
828: p_Index => l_source_Idx
829: , p_rec_sources => p_rec_sources
830: , p_translated_flag => p_criterion_value)
831: );

Line 900: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

896: , p_line_definition_owner_code IN VARCHAR2
897: , p_line_definition_code IN VARCHAR2
898: , p_accrual_jlt_owner_code IN VARCHAR2
899: , p_accrual_jlt_code IN VARCHAR2
900: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
901: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
902: )
903: RETURN CLOB
904: IS

Line 901: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

897: , p_line_definition_code IN VARCHAR2
898: , p_accrual_jlt_owner_code IN VARCHAR2
899: , p_accrual_jlt_code IN VARCHAR2
900: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
901: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
902: )
903: RETURN CLOB
904: IS
905: --

Line 936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;

932: AND xahb.enabled_flag = 'Y'
933: ORDER BY xmhc.analytical_criterion_type_code, xmhc.analytical_criterion_code
934: ;
935:
936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
940: l_array_name xla_cmp_source_pkg.t_array_VL80;

Line 937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;

933: ORDER BY xmhc.analytical_criterion_type_code, xmhc.analytical_criterion_code
934: ;
935:
936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
940: l_array_name xla_cmp_source_pkg.t_array_VL80;
941:

Line 938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;

934: ;
935:
936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
940: l_array_name xla_cmp_source_pkg.t_array_VL80;
941:
942: l_body CLOB;

Line 939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;

935:
936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
940: l_array_name xla_cmp_source_pkg.t_array_VL80;
941:
942: l_body CLOB;
943: l_log_module VARCHAR2(240);

Line 940: l_array_name xla_cmp_source_pkg.t_array_VL80;

936: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
937: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
938: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
939: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
940: l_array_name xla_cmp_source_pkg.t_array_VL80;
941:
942: l_body CLOB;
943: l_log_module VARCHAR2(240);
944: --

Line 1047: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1043: , p_accrual_jlt_owner_code IN VARCHAR2
1044: , p_accrual_jlt_code IN VARCHAR2
1045: , p_mpa_jlt_owner_code IN VARCHAR2
1046: , p_mpa_jlt_code IN VARCHAR2
1047: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1048: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1049: )
1050: RETURN CLOB
1051: IS

Line 1048: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1044: , p_accrual_jlt_code IN VARCHAR2
1045: , p_mpa_jlt_owner_code IN VARCHAR2
1046: , p_mpa_jlt_code IN VARCHAR2
1047: , p_array_mpa_jlt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1048: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1049: )
1050: RETURN CLOB
1051: IS
1052:

Line 1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;

1081: AND xahb.enabled_flag = 'Y'
1082: ORDER BY xmlc.analytical_criterion_type_code, xmlc.analytical_criterion_code
1083: ;
1084: --
1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
1089: l_array_name xla_cmp_source_pkg.t_array_VL80;

Line 1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;

1082: ORDER BY xmlc.analytical_criterion_type_code, xmlc.analytical_criterion_code
1083: ;
1084: --
1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
1089: l_array_name xla_cmp_source_pkg.t_array_VL80;
1090:

Line 1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;

1083: ;
1084: --
1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
1089: l_array_name xla_cmp_source_pkg.t_array_VL80;
1090:
1091: l_body CLOB;

Line 1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;

1084: --
1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
1089: l_array_name xla_cmp_source_pkg.t_array_VL80;
1090:
1091: l_body CLOB;
1092: l_log_module VARCHAR2(240);

Line 1089: l_array_name xla_cmp_source_pkg.t_array_VL80;

1085: l_array_ac_code xla_cmp_source_pkg.t_array_VL30;
1086: l_array_ac_type_code xla_cmp_source_pkg.t_array_VL1;
1087: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1088: l_array_ac_value xla_cmp_source_pkg.t_array_VL1;
1089: l_array_name xla_cmp_source_pkg.t_array_VL80;
1090:
1091: l_body CLOB;
1092: l_log_module VARCHAR2(240);
1093: --

Line 1193: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1189: , p_line_definition_code IN VARCHAR2
1190: , p_accounting_line_type_code IN VARCHAR2
1191: , p_accounting_line_code IN VARCHAR2
1192: --
1193: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1194: --
1195: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1196: )
1197: RETURN CLOB

Line 1195: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1191: , p_accounting_line_code IN VARCHAR2
1192: --
1193: , p_array_alt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1194: --
1195: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1196: )
1197: RETURN CLOB
1198: IS
1199: --

Line 1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;

1227: AND xahb.enabled_flag = 'Y'
1228: ORDER BY xlda.analytical_criterion_type_code, xlda.analytical_criterion_code
1229: ;
1230: --
1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1234: l_array_name xla_cmp_source_pkg.t_array_VL80;
1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;

Line 1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;

1228: ORDER BY xlda.analytical_criterion_type_code, xlda.analytical_criterion_code
1229: ;
1230: --
1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1234: l_array_name xla_cmp_source_pkg.t_array_VL80;
1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
1236: --

Line 1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;

1229: ;
1230: --
1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1234: l_array_name xla_cmp_source_pkg.t_array_VL80;
1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
1236: --
1237: l_analytical_criteria CLOB;

Line 1234: l_array_name xla_cmp_source_pkg.t_array_VL80;

1230: --
1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1234: l_array_name xla_cmp_source_pkg.t_array_VL80;
1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
1236: --
1237: l_analytical_criteria CLOB;
1238: l_log_module VARCHAR2(240);

Line 1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;

1231: l_array_analytic_code xla_cmp_source_pkg.t_array_VL30;
1232: l_array_analytic_type_code xla_cmp_source_pkg.t_array_VL1;
1233: l_array_balancing_flag xla_cmp_source_pkg.t_array_VL1;
1234: l_array_name xla_cmp_source_pkg.t_array_VL80;
1235: l_array_criterion_value xla_cmp_source_pkg.t_array_VL1;
1236: --
1237: l_analytical_criteria CLOB;
1238: l_log_module VARCHAR2(240);
1239: BEGIN