eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_CMP_EXTRACT_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

752: --+==========================================================================+
753:
754: FUNCTION GenerateFromHdrTabs (
755: --
756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

753:
754: FUNCTION GenerateFromHdrTabs (
755: --
756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --

Line 758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

754: FUNCTION GenerateFromHdrTabs (
755: --
756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

755: --
756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

756: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
757: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
764: --

Line 762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

758: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
764: --
765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

759: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
760: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
764: --
765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --

Line 765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

761: --
762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
764: --
765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --
768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

762: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
763: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
764: --
765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --
768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
770: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

764: --
765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --
768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
770: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
771: )
772: RETURN VARCHAR2

Line 769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

765: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --
768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
770: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
771: )
772: RETURN VARCHAR2
773: ;

Line 770: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

766: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
767: --
768: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
769: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
770: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
771: )
772: RETURN VARCHAR2
773: ;
774:

Line 777: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

773: ;
774:
775: FUNCTION GenerateHdrWhereClause (
776: --
777: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --

Line 778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

774:
775: FUNCTION GenerateHdrWhereClause (
776: --
777: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

775: FUNCTION GenerateHdrWhereClause (
776: --
777: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

776: --
777: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
784: --

Line 782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

778: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
784: --
785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

779: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
780: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
784: --
785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
787: --

Line 785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

781: --
782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
784: --
785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
787: --
788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

782: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
783: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
784: --
785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
787: --
788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --

Line 788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

784: --
785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
787: --
788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --
791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

785: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
786: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
787: --
788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --
791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
793: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

787: --
788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --
791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
793: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
794: )
795: RETURN VARCHAR2

Line 792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

788: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --
791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
793: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
794: )
795: RETURN VARCHAR2
796: ;

Line 793: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

789: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
790: --
791: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
792: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
793: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
794: )
795: RETURN VARCHAR2
796: ;
797: --

Line 800: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

796: ;
797: --
798: FUNCTION GenerateFromLineTabs (
799: --
800: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --

Line 801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

797: --
798: FUNCTION GenerateFromLineTabs (
799: --
800: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

798: FUNCTION GenerateFromLineTabs (
799: --
800: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
806: --

Line 803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

799: --
800: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
806: --
807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

801: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
802: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
806: --
807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
809: --

Line 807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

803: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
806: --
807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
809: --
810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

804: --
805: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
806: --
807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
809: --
810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --

Line 810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

806: --
807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
809: --
810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --
813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

807: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
808: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
809: --
810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --
813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
815: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

809: --
810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --
813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
815: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
816: )
817: RETURN VARCHAR2

Line 814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

810: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --
813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
815: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
816: )
817: RETURN VARCHAR2
818: ;

Line 815: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

811: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
812: --
813: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
814: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
815: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
816: )
817: RETURN VARCHAR2
818: ;
819: --

Line 823: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

819: --
820: --
821: FUNCTION GenerateLineWhereClause (
822: --
823: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --

Line 824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

820: --
821: FUNCTION GenerateLineWhereClause (
822: --
823: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

821: FUNCTION GenerateLineWhereClause (
822: --
823: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

822: --
823: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
830: --

Line 828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

824: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
830: --
831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

825: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
826: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
830: --
831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
833: --

Line 831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

827: --
828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
830: --
831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
833: --
834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

828: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
829: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
830: --
831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
833: --
834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --

Line 834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

830: --
831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
833: --
834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --
837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

831: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
832: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
833: --
834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --
837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
839: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

833: --
834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --
837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
839: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
840: )
841: RETURN VARCHAR2

Line 838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

834: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --
837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
839: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
840: )
841: RETURN VARCHAR2
842: ;

Line 839: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

835: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
836: --
837: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
838: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
839: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
840: )
841: RETURN VARCHAR2
842: ;
843:

Line 875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

871: --| |
872: --+==========================================================================+
873: --
874: PROCEDURE InitSourceArrays (
875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num

872: --+==========================================================================+
873: --
874: PROCEDURE InitSourceArrays (
875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

873: --
874: PROCEDURE InitSourceArrays (
875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
881: )

Line 878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

874: PROCEDURE InitSourceArrays (
875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
881: )
882: IS

Line 879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

875: p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
881: )
882: IS
883: --

Line 880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

876: , p_array_application_id IN OUT NOCOPY xla_cmp_source_pkg.t_array_Num
877: , p_array_source_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
878: , p_array_source_type_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
879: , p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
880: , p_array_translated_flag IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
881: )
882: IS
883: --
884: Jdx BINARY_INTEGER;

Line 885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;

881: )
882: IS
883: --
884: Jdx BINARY_INTEGER;
885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;

Line 886: l_array_application_id xla_cmp_source_pkg.t_array_Num;

882: IS
883: --
884: Jdx BINARY_INTEGER;
885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;

Line 887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;

883: --
884: Jdx BINARY_INTEGER;
885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
891: l_log_module VARCHAR2(240);

Line 888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

884: Jdx BINARY_INTEGER;
885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
891: l_log_module VARCHAR2(240);
892: --

Line 889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;

885: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
891: l_log_module VARCHAR2(240);
892: --
893: BEGIN

Line 890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;

886: l_array_application_id xla_cmp_source_pkg.t_array_Num;
887: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
888: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
889: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
890: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
891: l_log_module VARCHAR2(240);
892: --
893: BEGIN
894: --

Line 1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt

1041: PROCEDURE InsertSourcesIntoGtTable (
1042: p_application_id IN NUMBER
1043: , p_entity_code IN VARCHAR2
1044: , p_event_class_code IN VARCHAR2
1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1

Line 1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

1042: p_application_id IN NUMBER
1043: , p_entity_code IN VARCHAR2
1044: , p_event_class_code IN VARCHAR2
1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

1043: , p_entity_code IN VARCHAR2
1044: , p_event_class_code IN VARCHAR2
1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1051: )

Line 1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

1044: , p_event_class_code IN VARCHAR2
1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1051: )
1052: IS

Line 1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1

1045: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1051: )
1052: IS
1053: --

Line 1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

1046: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1047: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1048: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1049: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1050: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1051: )
1052: IS
1053: --
1054: l_log_module VARCHAR2(240);

Line 1196: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1192: PROCEDURE GetSourceLevels (
1193: p_application_id IN NUMBER
1194: , p_entity_code IN VARCHAR2
1195: , p_event_class_code IN VARCHAR2
1196: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1197: )
1198: IS
1199: --
1200: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;

Line 1200: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;

1196: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1197: )
1198: IS
1199: --
1200: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
1201: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
1202: --
1203: l_log_module VARCHAR2(240);
1204: --

Line 1201: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;

1197: )
1198: IS
1199: --
1200: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
1201: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
1202: --
1203: l_log_module VARCHAR2(240);
1204: --
1205: BEGIN

Line 1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1298: PROCEDURE GetExtractObjects (
1299: p_application_id IN NUMBER
1300: , p_entity_code IN VARCHAR2
1301: , p_event_class_code IN VARCHAR2
1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1299: p_application_id IN NUMBER
1300: , p_entity_code IN VARCHAR2
1301: , p_event_class_code IN VARCHAR2
1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1300: , p_entity_code IN VARCHAR2
1301: , p_event_class_code IN VARCHAR2
1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000

Line 1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1301: , p_event_class_code IN VARCHAR2
1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000
1309: )

Line 1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1302: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000
1309: )
1310: IS

Line 1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1303: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000
1309: )
1310: IS
1311: --

Line 1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000

1304: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1305: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1306: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1307: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000
1309: )
1310: IS
1311: --
1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;

Line 1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;

1308: , p_array_join_condition OUT NOCOPY xla_cmp_Source_pkg.t_array_VL2000
1309: )
1310: IS
1311: --
1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;
1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

Line 1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;

1309: )
1310: IS
1311: --
1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;
1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --

Line 1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;

1310: IS
1311: --
1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;
1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

Line 1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;

1311: --
1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;
1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

Line 1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

1312: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1313: l_array_parent_name xla_cmp_source_pkg.t_array_VL30;
1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
1320: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;

Line 1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

1314: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
1320: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
1321: TYPE t_array_by_VL30 IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
1322: l_array_table_index t_array_by_VL30;

Line 1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

1315: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
1320: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
1321: TYPE t_array_by_VL30 IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
1322: l_array_table_index t_array_by_VL30;
1323: --

Line 1320: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;

1316: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
1317: --
1318: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
1319: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
1320: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
1321: TYPE t_array_by_VL30 IS TABLE OF NUMBER INDEX BY VARCHAR2(30);
1322: l_array_table_index t_array_by_VL30;
1323: --
1324: CURSOR table_cur( p_application_id NUMBER

Line 1521: ,p_array_object_name IN xla_cmp_source_pkg.t_array_VL30

1517: --+==========================================================================+
1518: --
1519: FUNCTION GetObjectIndex (
1520: p_object_name IN VARCHAR2
1521: ,p_array_object_name IN xla_cmp_source_pkg.t_array_VL30
1522: )
1523: RETURN BINARY_INTEGER
1524: IS
1525: objectIndex BINARY_INTEGER:=NULL;

Line 1559: , p_array_object_name IN xla_cmp_source_pkg.t_array_VL30

1555: PROCEDURE GetSourcesWithExtractObject (
1556: p_application_id IN NUMBER
1557: , p_entity_code IN VARCHAR2
1558: , p_event_class_code IN VARCHAR2
1559: , p_array_object_name IN xla_cmp_source_pkg.t_array_VL30
1560: --
1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1563: --

Line 1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1557: , p_entity_code IN VARCHAR2
1558: , p_event_class_code IN VARCHAR2
1559: , p_array_object_name IN xla_cmp_source_pkg.t_array_VL30
1560: --
1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1563: --
1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1558: , p_event_class_code IN VARCHAR2
1559: , p_array_object_name IN xla_cmp_source_pkg.t_array_VL30
1560: --
1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1563: --
1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1566: --

Line 1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1560: --
1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1563: --
1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1566: --
1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1561: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1562: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1563: --
1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1566: --
1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1569: --

Line 1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1563: --
1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1566: --
1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1569: --
1570: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1571: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1564: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1565: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1566: --
1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1569: --
1570: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1571: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1572: --

Line 1570: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1566: --
1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1569: --
1570: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1571: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1572: --
1573: )
1574: IS

Line 1571: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1567: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1568: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1569: --
1570: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1571: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1572: --
1573: )
1574: IS
1575: --

Line 1577: l_array_source_hash_id xla_cmp_source_pkg.t_array_ByInt;

1573: )
1574: IS
1575: --
1576: --
1577: l_array_source_hash_id xla_cmp_source_pkg.t_array_ByInt;
1578: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1579: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1580: l_log_module VARCHAR2(240);
1581: --

Line 1578: l_array_object_name xla_cmp_source_pkg.t_array_VL30;

1574: IS
1575: --
1576: --
1577: l_array_source_hash_id xla_cmp_source_pkg.t_array_ByInt;
1578: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1579: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1580: l_log_module VARCHAR2(240);
1581: --
1582: BEGIN

Line 1579: l_array_object_type xla_cmp_source_pkg.t_array_VL30;

1575: --
1576: --
1577: l_array_source_hash_id xla_cmp_source_pkg.t_array_ByInt;
1578: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
1579: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
1580: l_log_module VARCHAR2(240);
1581: --
1582: BEGIN
1583: --

Line 1721: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

1717: l_col_start_pos PLS_INTEGER;
1718: l_and_pos PLS_INTEGER;
1719: l_start_pos PLS_INTEGER;
1720: i PLS_INTEGER;
1721: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
1722: l_relation VARCHAR2(2);
1723:
1724: l_log_module VARCHAR2(240);
1725:

Line 1966: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt

1962: , p_amb_context_code IN VARCHAR2
1963: , p_product_rule_type_code IN VARCHAR2
1964: , p_product_rule_code IN VARCHAR2
1965: --
1966: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1967: --
1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

1964: , p_product_rule_code IN VARCHAR2
1965: --
1966: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1967: --
1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

1965: --
1966: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1967: --
1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --

Line 1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

1966: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
1967: --
1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1

1967: --
1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --

Line 1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

1968: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
1969: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

Line 1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1970: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
1971: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

Line 1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1972: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1973: --
1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --

Line 1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1974: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1975: --
1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000

Line 1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1976: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1977: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --

Line 1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1978: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000

1979: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1980: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1981: --
1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1982: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1983: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1984: --
1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1985: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1993: )

Line 1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1986: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1993: )
1994: RETURN BOOLEAN

Line 1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1987: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1993: )
1994: RETURN BOOLEAN
1995: IS

Line 1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1988: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1989: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1990: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1991: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1992: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1993: )
1994: RETURN BOOLEAN
1995: IS
1996: --

Line 1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;

1995: IS
1996: --
1997: l_IsExtractValid BOOLEAN:=TRUE;
1998: --
1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;

Line 2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;

1996: --
1997: l_IsExtractValid BOOLEAN:=TRUE;
1998: --
1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;

Line 2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;

1997: l_IsExtractValid BOOLEAN:=TRUE;
1998: --
1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --

Line 2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;

1998: --
1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;

Line 2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;

1999: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --

Line 2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;

2000: l_array_application_id xla_cmp_source_pkg.t_array_Num;
2001: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;

Line 2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;

2002: l_array_source_type_code xla_cmp_source_pkg.t_array_VL1;
2003: l_array_datatype_code xla_cmp_source_pkg.t_array_VL1;
2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;

Line 2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;

2004: l_array_translated_flag xla_cmp_source_pkg.t_array_VL1;
2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

Line 2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;

2005: --
2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --

Line 2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;

2006: l_array_evt_source_Level xla_cmp_source_pkg.t_array_VL1;
2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

Line 2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;

2007: --
2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

Line 2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

2008: l_array_object_name xla_cmp_source_pkg.t_array_VL30;
2009: l_array_parent_object_index xla_cmp_source_pkg.t_array_ByInt;
2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --

Line 2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

2010: l_array_object_type xla_cmp_source_pkg.t_array_VL30;
2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

2011: l_array_object_hash_id xla_cmp_source_pkg.t_array_VL30;
2012: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

Line 2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;

2013: --
2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;

Line 2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;

2014: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

2015: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

Line 2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

2016: --
2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;

2017: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2025: l_log_module VARCHAR2(240);

Line 2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;

2018: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2025: l_log_module VARCHAR2(240);
2026: --

Line 2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

2019: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2025: l_log_module VARCHAR2(240);
2026: --
2027: BEGIN

Line 2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

2020: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
2022: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
2023: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
2024: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
2025: l_log_module VARCHAR2(240);
2026: --
2027: BEGIN
2028: --

Line 2272: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

2268: --| |
2269: --+==========================================================================+
2270: --
2271: FUNCTION GenerateLineStructure (
2272: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
2273: --
2274: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2275: --
2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 2274: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

2270: --
2271: FUNCTION GenerateLineStructure (
2272: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
2273: --
2274: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2275: --
2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
2278: --

Line 2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

2272: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
2273: --
2274: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2275: --
2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
2278: --
2279: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2280: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

2273: --
2274: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2275: --
2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
2278: --
2279: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2280: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
2281: --

Line 2279: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

2275: --
2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
2278: --
2279: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2280: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
2281: --
2282: )
2283: RETURN VARCHAR2

Line 2280: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

2276: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2277: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
2278: --
2279: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2280: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
2281: --
2282: )
2283: RETURN VARCHAR2
2284: IS

Line 2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

2380: --+==========================================================================+
2381: --
2382:
2383: FUNCTION GenerateHdrVariables
2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)

Line 2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

2381: --
2382:
2383: FUNCTION GenerateHdrVariables
2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
2389: RETURN VARCHAR2 IS

Line 2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

2382:
2383: FUNCTION GenerateHdrVariables
2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
2389: RETURN VARCHAR2 IS
2390:

Line 2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

2383: FUNCTION GenerateHdrVariables
2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
2389: RETURN VARCHAR2 IS
2390:
2391: C_HEADER_VAR CONSTANT VARCHAR2(2000) :='l_array_source_$Index$ t_array_source_$Index$;';

Line 2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)

2384: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2385: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2386: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2387: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2388: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
2389: RETURN VARCHAR2 IS
2390:
2391: C_HEADER_VAR CONSTANT VARCHAR2(2000) :='l_array_source_$Index$ t_array_source_$Index$;';
2392: C_LOOKUP_VAR CONSTANT VARCHAR2(100) :='l_array_source_$Index$_meaning t_array_lookup_meaning;';

Line 2481: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

2477: --| |
2478: --+==========================================================================+
2479: --
2480: FUNCTION GenerateFetchHeaderCursor (
2481: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2483: --
2484: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2485: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 2482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

2478: --+==========================================================================+
2479: --
2480: FUNCTION GenerateFetchHeaderCursor (
2481: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2483: --
2484: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2485: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2486: )

Line 2484: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

2480: FUNCTION GenerateFetchHeaderCursor (
2481: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2483: --
2484: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2485: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2486: )
2487: RETURN VARCHAR2
2488: IS

Line 2485: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

2481: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
2482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2483: --
2484: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2485: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2486: )
2487: RETURN VARCHAR2
2488: IS
2489: --

Line 2594: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

2590: --+==========================================================================+
2591: --
2592: --
2593: FUNCTION GenerateLineVariables(
2594: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2596: --
2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

2591: --
2592: --
2593: FUNCTION GenerateLineVariables(
2594: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2596: --
2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2599: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

2593: FUNCTION GenerateLineVariables(
2594: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2596: --
2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2599: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2600: )
2601: RETURN VARCHAR2

Line 2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

2594: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2596: --
2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2599: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2600: )
2601: RETURN VARCHAR2
2602: IS

Line 2599: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

2595: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2596: --
2597: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2598: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2599: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2600: )
2601: RETURN VARCHAR2
2602: IS
2603: --

Line 2715: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

2711: --| |
2712: --+==========================================================================+
2713: --
2714: FUNCTION GenerateFetchLineCursor(
2715: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2717: --
2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

2712: --+==========================================================================+
2713: --
2714: FUNCTION GenerateFetchLineCursor(
2715: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2717: --
2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2720: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

2714: FUNCTION GenerateFetchLineCursor(
2715: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2717: --
2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2720: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2721: )
2722: RETURN VARCHAR2

Line 2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

2715: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2717: --
2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2720: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2721: )
2722: RETURN VARCHAR2
2723: IS

Line 2720: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

2716: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
2717: --
2718: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2719: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2720: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2721: )
2722: RETURN VARCHAR2
2723: IS
2724: --

Line 2835: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

2831: --| |
2832: --+==========================================================================+
2833: --
2834: PROCEDURE GetUsedExtractObject(
2835: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2836: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
2837: , p_array_diff_table_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2838: )
2839: IS

Line 2836: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

2832: --+==========================================================================+
2833: --
2834: PROCEDURE GetUsedExtractObject(
2835: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2836: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
2837: , p_array_diff_table_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2838: )
2839: IS
2840: --

Line 2837: , p_array_diff_table_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2833: --
2834: PROCEDURE GetUsedExtractObject(
2835: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2836: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
2837: , p_array_diff_table_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2838: )
2839: IS
2840: --
2841: l_log_module VARCHAR2(240);

Line 2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

2905: --| |
2906: --+==========================================================================+
2907: --
2908: FUNCTION GenerateExtractColumns(
2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

2906: --+==========================================================================+
2907: --
2908: FUNCTION GenerateExtractColumns(
2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt

2907: --
2908: FUNCTION GenerateExtractColumns(
2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2915: )

Line 2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

2908: FUNCTION GenerateExtractColumns(
2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2915: )
2916: RETURN VARCHAR2

Line 2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

2909: p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2915: )
2916: RETURN VARCHAR2
2917: IS

Line 2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

2910: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
2911: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
2912: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
2913: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
2914: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
2915: )
2916: RETURN VARCHAR2
2917: IS
2918: --

Line 3006: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt

3002: --| |
3003: --+==========================================================================+
3004: --
3005: FUNCTION GenerateLookupTables(
3006: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3007: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3008: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3009: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3010: )

Line 3007: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

3003: --+==========================================================================+
3004: --
3005: FUNCTION GenerateLookupTables(
3006: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3007: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3008: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3009: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3010: )
3011: RETURN VARCHAR2

Line 3008: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

3004: --
3005: FUNCTION GenerateLookupTables(
3006: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3007: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3008: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3009: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3010: )
3011: RETURN VARCHAR2
3012: IS

Line 3009: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

3005: FUNCTION GenerateLookupTables(
3006: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3007: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3008: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3009: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3010: )
3011: RETURN VARCHAR2
3012: IS
3013: --

Line 3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt

3081: --| |
3082: --+==========================================================================+
3083: --
3084: FUNCTION GenerateLookupClauses(
3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

3082: --+==========================================================================+
3083: --
3084: FUNCTION GenerateLookupClauses(
3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

3083: --
3084: FUNCTION GenerateLookupClauses(
3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

3084: FUNCTION GenerateLookupClauses(
3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3092: )

Line 3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

3085: p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3092: )
3093: RETURN VARCHAR2

Line 3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

3086: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3092: )
3093: RETURN VARCHAR2
3094: IS

Line 3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

3087: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3088: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3089: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3090: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3091: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3092: )
3093: RETURN VARCHAR2
3094: IS
3095: --

Line 3180: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

3176: --| |
3177: --+==========================================================================+
3178: --
3179: FUNCTION GetAnAlwaysPopulatedObject(
3180: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3181: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3182: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3183: )
3184: RETURN NUMBER

Line 3181: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

3177: --+==========================================================================+
3178: --
3179: FUNCTION GetAnAlwaysPopulatedObject(
3180: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3181: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3182: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3183: )
3184: RETURN NUMBER
3185: IS

Line 3182: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

3178: --
3179: FUNCTION GetAnAlwaysPopulatedObject(
3180: p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
3181: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3182: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3183: )
3184: RETURN NUMBER
3185: IS
3186: l_object_index NUMBER;

Line 3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

3248: --| |
3249: --+==========================================================================+
3250: --
3251: FUNCTION GenerateHeaderCursor
3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

3249: --+==========================================================================+
3250: --
3251: FUNCTION GenerateHeaderCursor
3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000

Line 3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

3250: --
3251: FUNCTION GenerateHeaderCursor
3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

3251: FUNCTION GenerateHeaderCursor
3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

3252: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000

3253: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

3254: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

3255: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

3256: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

3257: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3265: ,p_procedure IN VARCHAR2)

Line 3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

3258: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3265: ,p_procedure IN VARCHAR2)
3266: RETURN VARCHAR2 IS

Line 3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

3259: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3265: ,p_procedure IN VARCHAR2)
3266: RETURN VARCHAR2 IS
3267: --

Line 3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

3260: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3261: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3262: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3263: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3264: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3265: ,p_procedure IN VARCHAR2)
3266: RETURN VARCHAR2 IS
3267: --
3268: l_hdr_cur VARCHAR2(32000);

Line 3281: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;

3277: --
3278: l_h_count BINARY_INTEGER;
3279: l_h_mls_count BINARY_INTEGER;
3280: --
3281: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
3282: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
3283: --
3284: l_first_tab BINARY_INTEGER;
3285: l_first_mls_tab BINARY_INTEGER;

Line 3282: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;

3278: l_h_count BINARY_INTEGER;
3279: l_h_mls_count BINARY_INTEGER;
3280: --
3281: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
3282: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
3283: --
3284: l_first_tab BINARY_INTEGER;
3285: l_first_mls_tab BINARY_INTEGER;
3286: --

Line 3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

3636: --+==========================================================================+
3637: --
3638: FUNCTION GenerateLineCursor
3639: (p_application_id IN NUMBER
3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

3637: --
3638: FUNCTION GenerateLineCursor
3639: (p_application_id IN NUMBER
3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

3638: FUNCTION GenerateLineCursor
3639: (p_application_id IN NUMBER
3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

3639: (p_application_id IN NUMBER
3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

3640: ,p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

3641: ,p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

3642: ,p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

3643: ,p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

3644: ,p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

3645: ,p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3653: ,p_procedure IN VARCHAR2)

Line 3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

3646: ,p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3653: ,p_procedure IN VARCHAR2)
3654: RETURN VARCHAR2 IS

Line 3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

3647: ,p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3653: ,p_procedure IN VARCHAR2)
3654: RETURN VARCHAR2 IS
3655:

Line 3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

3648: ,p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3649: ,p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3650: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
3651: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
3652: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
3653: ,p_procedure IN VARCHAR2)
3654: RETURN VARCHAR2 IS
3655:
3656: l_line_cur VARCHAR2(32000);

Line 3670: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;

3666: l_l_count BINARY_INTEGER;
3667: l_l_mls_count BINARY_INTEGER;
3668: --
3669: --
3670: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
3671: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
3672: --
3673: l_first_tab BINARY_INTEGER;
3674: l_first_mls_tab BINARY_INTEGER;

Line 3671: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;

3667: l_l_mls_count BINARY_INTEGER;
3668: --
3669: --
3670: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
3671: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
3672: --
3673: l_first_tab BINARY_INTEGER;
3674: l_first_mls_tab BINARY_INTEGER;
3675: --

Line 4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4108: --| |
4109: --+==========================================================================+
4110: --
4111: FUNCTION GenerateHdrStructure
4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

4109: --+==========================================================================+
4110: --
4111: FUNCTION GenerateHdrStructure
4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)

Line 4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4110: --
4111: FUNCTION GenerateHdrStructure
4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
4118: RETURN VARCHAR2 IS

Line 4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

4111: FUNCTION GenerateHdrStructure
4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
4118: RETURN VARCHAR2 IS
4119:

Line 4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4112: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
4118: RETURN VARCHAR2 IS
4119:
4120: C_STRUCTURE CONSTANT VARCHAR2(2000):=

Line 4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)

4113: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4114: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4115: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4116: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4117: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
4118: RETURN VARCHAR2 IS
4119:
4120: C_STRUCTURE CONSTANT VARCHAR2(2000):=
4121: 'TYPE t_array_source_$Index$ IS TABLE OF $table$.$column$%TYPE INDEX BY BINARY_INTEGER;';

Line 4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4194: --| |
4195: --| |
4196: --+==========================================================================+
4197: FUNCTION GenerateCacheHdrSources
4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)

Line 4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4195: --| |
4196: --+==========================================================================+
4197: FUNCTION GenerateCacheHdrSources
4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
4203:

Line 4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

4196: --+==========================================================================+
4197: FUNCTION GenerateCacheHdrSources
4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
4203:
4204: RETURN VARCHAR2 IS

Line 4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

4197: FUNCTION GenerateCacheHdrSources
4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
4203:
4204: RETURN VARCHAR2 IS
4205: C_SOURCE CONSTANT VARCHAR2(2000) :='g_array_event(l_event_id).array_value_$datatype$(''source_$index$'') := l_array_source_$index$(hdr_idx);';

Line 4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)

4198: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4199: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4200: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4201: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4202: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
4203:
4204: RETURN VARCHAR2 IS
4205: C_SOURCE CONSTANT VARCHAR2(2000) :='g_array_event(l_event_id).array_value_$datatype$(''source_$index$'') := l_array_source_$index$(hdr_idx);';
4206: C_SOURCE_LKP CONSTANT VARCHAR2(2000) :='g_array_event(l_event_id).array_value_char(''source_$index$_meaning'') := l_array_source_$index$_meaning(hdr_idx);';

Line 4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4346: --+==========================================================================+
4347: --
4348: FUNCTION GenerateFromHdrTabs (
4349: --
4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

4347: --
4348: FUNCTION GenerateFromHdrTabs (
4349: --
4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --

Line 4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

4348: FUNCTION GenerateFromHdrTabs (
4349: --
4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

4349: --
4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

4350: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4351: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4358: --

Line 4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4352: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4358: --
4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

4353: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4354: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4358: --
4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --

Line 4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4355: --
4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4358: --
4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --
4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4356: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4357: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4358: --
4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --
4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4364: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

4358: --
4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --
4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4364: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4365: )
4366: RETURN VARCHAR2

Line 4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

4359: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --
4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4364: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4365: )
4366: RETURN VARCHAR2
4367: IS

Line 4364: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

4360: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4361: --
4362: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4363: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4364: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4365: )
4366: RETURN VARCHAR2
4367: IS
4368: --

Line 4375: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;

4371: --
4372: l_h_count BINARY_INTEGER;
4373: l_h_mls_count BINARY_INTEGER;
4374: --
4375: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
4376: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4377: --
4378: l_first_tab BINARY_INTEGER;
4379: l_first_mls_tab BINARY_INTEGER;

Line 4376: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;

4372: l_h_count BINARY_INTEGER;
4373: l_h_mls_count BINARY_INTEGER;
4374: --
4375: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
4376: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4377: --
4378: l_first_tab BINARY_INTEGER;
4379: l_first_mls_tab BINARY_INTEGER;
4380: --

Line 4542: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4538: --+==========================================================================+
4539: --
4540: FUNCTION GenerateHdrWhereClause (
4541: --
4542: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --

Line 4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

4539: --
4540: FUNCTION GenerateHdrWhereClause (
4541: --
4542: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

4540: FUNCTION GenerateHdrWhereClause (
4541: --
4542: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

4541: --
4542: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4549: --

Line 4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

4543: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4549: --
4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

4544: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4545: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4549: --
4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4552: --

Line 4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4546: --
4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4549: --
4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4552: --
4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

4547: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4548: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4549: --
4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4552: --
4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --

Line 4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4549: --
4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4552: --
4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --
4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4550: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4551: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4552: --
4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --
4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4558: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

4552: --
4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --
4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4558: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4559: )
4560: RETURN VARCHAR2

Line 4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

4553: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --
4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4558: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4559: )
4560: RETURN VARCHAR2
4561: IS

Line 4558: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

4554: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4555: --
4556: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4557: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4558: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4559: )
4560: RETURN VARCHAR2
4561: IS
4562: --

Line 4572: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;

4568: --
4569: l_h_count BINARY_INTEGER;
4570: l_h_mls_count BINARY_INTEGER;
4571: --
4572: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
4573: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4574: --
4575: l_first_tab BINARY_INTEGER;
4576: l_first_mls_tab BINARY_INTEGER;

Line 4573: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;

4569: l_h_count BINARY_INTEGER;
4570: l_h_mls_count BINARY_INTEGER;
4571: --
4572: l_array_h_tab xla_cmp_source_pkg.t_array_ByInt;
4573: l_array_h_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4574: --
4575: l_first_tab BINARY_INTEGER;
4576: l_first_mls_tab BINARY_INTEGER;
4577: --

Line 4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4889: --+==========================================================================+
4890: --
4891: FUNCTION GenerateFromLineTabs (
4892: --
4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

4890: --
4891: FUNCTION GenerateFromLineTabs (
4892: --
4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --

Line 4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

4891: FUNCTION GenerateFromLineTabs (
4892: --
4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

4892: --
4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

4893: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4894: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4901: --

Line 4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

4895: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4901: --
4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

4896: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4897: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4901: --
4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --

Line 4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4898: --
4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4901: --
4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --
4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4899: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4900: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4901: --
4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --
4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4907: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

4901: --
4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --
4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4907: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4908: )
4909: RETURN VARCHAR2

Line 4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

4902: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --
4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4907: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4908: )
4909: RETURN VARCHAR2
4910: IS

Line 4907: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

4903: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4904: --
4905: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
4906: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
4907: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
4908: )
4909: RETURN VARCHAR2
4910: IS
4911: --

Line 4916: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;

4912: l_line_tabs VARCHAR2(20000);
4913: l_line_tab VARCHAR2(1000);
4914: l_l_count BINARY_INTEGER;
4915: l_l_mls_count BINARY_INTEGER;
4916: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
4917: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4918: l_first_tab BINARY_INTEGER;
4919: l_first_mls_tab BINARY_INTEGER;
4920: --

Line 4917: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;

4913: l_line_tab VARCHAR2(1000);
4914: l_l_count BINARY_INTEGER;
4915: l_l_mls_count BINARY_INTEGER;
4916: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
4917: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
4918: l_first_tab BINARY_INTEGER;
4919: l_first_mls_tab BINARY_INTEGER;
4920: --
4921: l_log_module VARCHAR2(240);

Line 5073: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

5069: --+==========================================================================+
5070: --
5071: FUNCTION GenerateLineWhereClause (
5072: --
5073: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --

Line 5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

5070: --
5071: FUNCTION GenerateLineWhereClause (
5072: --
5073: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --
5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

5071: FUNCTION GenerateLineWhereClause (
5072: --
5073: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --
5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

5072: --
5073: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --
5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5080:

Line 5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

5074: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --
5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5080:
5081: --
5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

5075: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5076: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5077: --
5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5080:
5081: --
5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

5078: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5080:
5081: --
5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5084: --
5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

5079: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5080:
5081: --
5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5084: --
5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --

Line 5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

5081: --
5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5084: --
5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --
5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

5082: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5083: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5084: --
5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --
5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5090: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

5084: --
5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --
5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5090: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5091: )
5092: RETURN VARCHAR2

Line 5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

5085: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --
5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5090: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5091: )
5092: RETURN VARCHAR2
5093: IS

Line 5090: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

5086: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5087: --
5088: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5089: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5090: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5091: )
5092: RETURN VARCHAR2
5093: IS
5094: --

Line 5103: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;

5099: --
5100: l_l_count BINARY_INTEGER;
5101: l_l_mls_count BINARY_INTEGER;
5102: --
5103: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
5104: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
5105: --
5106: l_first_tab BINARY_INTEGER;
5107: l_first_mls_tab BINARY_INTEGER;

Line 5104: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;

5100: l_l_count BINARY_INTEGER;
5101: l_l_mls_count BINARY_INTEGER;
5102: --
5103: l_array_l_tab xla_cmp_source_pkg.t_array_ByInt;
5104: l_array_l_mls_tab xla_cmp_source_pkg.t_array_ByInt;
5105: --
5106: l_first_tab BINARY_INTEGER;
5107: l_first_mls_tab BINARY_INTEGER;
5108: --

Line 5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

5450: --| |
5451: --+==========================================================================+
5452: --
5453: FUNCTION GenerateInsertStm(
5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

5451: --+==========================================================================+
5452: --
5453: FUNCTION GenerateInsertStm(
5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt

5452: --
5453: FUNCTION GenerateInsertStm(
5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --

Line 5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

5453: FUNCTION GenerateInsertStm(
5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

5454: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

5455: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5456: , p_array_table_index IN xla_cmp_source_pkg.t_array_ByInt
5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

Line 5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt

5457: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

Line 5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

5458: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

5459: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

5460: --
5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5468: --

Line 5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

5461: , p_array_source_index IN xla_cmp_source_pkg.t_array_ByInt
5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5468: --
5469: , p_level IN VARCHAR2

Line 5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

5462: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5468: --
5469: , p_level IN VARCHAR2
5470: , p_procedure IN VARCHAR2

Line 5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

5463: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5464: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5465: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5466: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5467: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5468: --
5469: , p_level IN VARCHAR2
5470: , p_procedure IN VARCHAR2
5471: )

Line 5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

5739: --+==========================================================================+
5740: --
5741: FUNCTION GenerateInsertHdrSources (
5742: --
5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

5740: --
5741: FUNCTION GenerateInsertHdrSources (
5742: --
5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --

Line 5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

5741: FUNCTION GenerateInsertHdrSources (
5742: --
5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1

Line 5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

5742: --
5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000

Line 5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

5743: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5744: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
5751: --

Line 5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1

5745: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
5751: --
5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000

5746: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5747: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
5751: --
5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
5754: --

Line 5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

5748: --
5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
5751: --
5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
5754: --
5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

5749: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_vl1
5750: , p_array_join_condition IN xla_cmp_source_pkg.t_array_vl2000
5751: --
5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
5754: --
5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --

Line 5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

5751: --
5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
5754: --
5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

5752: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
5753: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
5754: --
5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

5754: --
5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

5755: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

5756: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5764: --

Line 5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

5757: --
5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5764: --
5765: , p_procedure IN VARCHAR2

Line 5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

5758: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5764: --
5765: , p_procedure IN VARCHAR2
5766: )

Line 5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

5759: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5760: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5761: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5762: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5763: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5764: --
5765: , p_procedure IN VARCHAR2
5766: )
5767: RETURN CLOB

Line 5773: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;

5769: --
5770: l_sql_statement CLOB;
5771: l_log_module VARCHAR2(240);
5772: --
5773: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;
5774: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;
5775: --
5776: BEGIN
5777: --

Line 5774: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;

5770: l_sql_statement CLOB;
5771: l_log_module VARCHAR2(240);
5772: --
5773: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;
5774: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;
5775: --
5776: BEGIN
5777: --
5778: IF g_log_enabled THEN

Line 5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

5941: --+==========================================================================+
5942: --
5943: FUNCTION GenerateInsertLineSources (
5944: --
5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

5942: --
5943: FUNCTION GenerateInsertLineSources (
5944: --
5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --

Line 5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

5943: FUNCTION GenerateInsertLineSources (
5944: --
5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

5944: --
5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

5945: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
5946: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5953: --

Line 5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

5947: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5953: --
5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

5948: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
5949: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5953: --
5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5956: --

Line 5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

5950: --
5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5953: --
5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5956: --
5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

5951: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
5952: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
5953: --
5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5956: --
5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --

Line 5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

5953: --
5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5956: --
5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

5954: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
5955: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
5956: --
5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

5956: --
5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

5957: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

5958: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5966: --

Line 5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

5959: --
5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5966: --
5967: ,p_procedure IN VARCHAR2

Line 5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

5960: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5966: --
5967: ,p_procedure IN VARCHAR2
5968: )

Line 5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

5961: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
5962: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
5963: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
5964: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
5965: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
5966: --
5967: ,p_procedure IN VARCHAR2
5968: )
5969: RETURN CLOB

Line 5975: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;

5971: --
5972: l_sql_statement CLOB;
5973: l_log_module VARCHAR2(240);
5974: --
5975: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;
5976: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;
5977: --
5978: BEGIN
5979: --

Line 5976: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;

5972: l_sql_statement CLOB;
5973: l_log_module VARCHAR2(240);
5974: --
5975: l_array_source_index xla_cmp_source_pkg.t_array_ByInt;
5976: l_array_table_index xla_cmp_source_pkg.t_array_ByInt;
5977: --
5978: BEGIN
5979: --
5980: IF g_log_enabled THEN