APPS.XLA_CMP_EXTRACT_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 60: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt

56: , p_amb_context_code IN VARCHAR2
57: , p_product_rule_type_code IN VARCHAR2
58: , p_product_rule_code IN VARCHAR2
59: --
60: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
61: --
62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

58: , p_product_rule_code IN VARCHAR2
59: --
60: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
61: --
62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

59: --
60: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
61: --
62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --

Line 64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

60: , p_array_evt_source_index IN xla_cmp_source_pkg.t_array_ByInt
61: --
62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1

61: --
62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --

Line 66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1

62: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
63: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

Line 68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

64: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
65: , p_array_datatype_code IN xla_cmp_source_pkg.t_array_VL1
66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

Line 70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

66: , p_array_translated_flag IN xla_cmp_source_pkg.t_array_VL1
67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

67: --
68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --

Line 72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

68: , p_array_evt_source_Level OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

69: --
70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000

Line 74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

70: , p_array_object_name OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
71: , p_array_parent_object_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --

Line 76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

72: , p_array_object_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000

73: , p_array_object_hash_id OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
74: , p_array_populated_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

75: --
76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

76: , p_array_ref_obj_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

77: , p_array_join_condition OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

78: --
79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

79: , p_array_h_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
87: )

Line 84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

80: , p_array_h_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
87: )
88: RETURN BOOLEAN

Line 85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

81: , p_array_h_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
87: )
88: RETURN BOOLEAN
89: ;

Line 86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

82: , p_array_h_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
83: , p_array_l_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
84: , p_array_l_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
85: , p_array_l_mls_source_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
86: , p_array_l_mls_table_index OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
87: )
88: RETURN BOOLEAN
89: ;
90: --

Line 101: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

97: --| |
98: --+==========================================================================+
99: --
100: FUNCTION GenerateLineStructure (
101: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
102: --
103: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
104: --
105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 103: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

99: --
100: FUNCTION GenerateLineStructure (
101: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
102: --
103: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
104: --
105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
107: --

Line 105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

101: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
102: --
103: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
104: --
105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
107: --
108: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
109: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

102: --
103: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
104: --
105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
107: --
108: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
109: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
110: --

Line 108: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

104: --
105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
107: --
108: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
109: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
110: --
111: --
112: )

Line 109: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

105: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
106: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
107: --
108: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
109: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
110: --
111: --
112: )
113: RETURN VARCHAR2

Line 125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

121: --| |
122: --+==========================================================================+
123: --
124: FUNCTION GenerateHdrVariables
125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)

Line 126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

122: --+==========================================================================+
123: --
124: FUNCTION GenerateHdrVariables
125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
130: RETURN VARCHAR2;

Line 127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

123: --
124: FUNCTION GenerateHdrVariables
125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
130: RETURN VARCHAR2;
131:

Line 128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

124: FUNCTION GenerateHdrVariables
125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
130: RETURN VARCHAR2;
131:
132: --

Line 129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)

125: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
126: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
127: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
128: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
129: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num)
130: RETURN VARCHAR2;
131:
132: --
133: --+==========================================================================+

Line 142: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

138: --| |
139: --+==========================================================================+
140: --
141: FUNCTION GenerateFetchHeaderCursor (
142: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
143: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
144: --
145: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
146: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 143: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

139: --+==========================================================================+
140: --
141: FUNCTION GenerateFetchHeaderCursor (
142: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
143: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
144: --
145: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
146: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
147: )

Line 145: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

141: FUNCTION GenerateFetchHeaderCursor (
142: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
143: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
144: --
145: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
146: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
147: )
148: RETURN VARCHAR2
149: ;

Line 146: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

142: p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
143: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
144: --
145: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
146: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
147: )
148: RETURN VARCHAR2
149: ;
150: --

Line 161: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

157: --+==========================================================================+
158: --
159: --
160: FUNCTION GenerateLineVariables(
161: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
163: --
164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

158: --
159: --
160: FUNCTION GenerateLineVariables(
161: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
163: --
164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
166: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

160: FUNCTION GenerateLineVariables(
161: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
163: --
164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
166: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
167: )
168: RETURN VARCHAR2

Line 165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

161: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
163: --
164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
166: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
167: )
168: RETURN VARCHAR2
169: ;

Line 166: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

162: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
163: --
164: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
165: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
166: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
167: )
168: RETURN VARCHAR2
169: ;
170: --

Line 180: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

176: --| |
177: --+==========================================================================+
178: --
179: FUNCTION GenerateFetchLineCursor(
180: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
182: --
183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

177: --+==========================================================================+
178: --
179: FUNCTION GenerateFetchLineCursor(
180: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
182: --
183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
185: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

179: FUNCTION GenerateFetchLineCursor(
180: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
182: --
183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
185: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
186: )
187: RETURN VARCHAR2

Line 184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

180: p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
182: --
183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
185: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
186: )
187: RETURN VARCHAR2
188: ;

Line 185: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

181: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
182: --
183: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
184: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
185: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
186: )
187: RETURN VARCHAR2
188: ;
189:

Line 203: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

199: --+==========================================================================+
200: --
201: FUNCTION GenerateHeaderCursor (
202: --
203: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --

Line 204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

200: --
201: FUNCTION GenerateHeaderCursor (
202: --
203: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

201: FUNCTION GenerateHeaderCursor (
202: --
203: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

202: --
203: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
210: --

Line 208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

204: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
210: --
211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

205: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
206: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
210: --
211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
213: --

Line 211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

207: --
208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
210: --
211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
213: --
214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

208: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
209: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
210: --
211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
213: --
214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --

Line 214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

210: --
211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
213: --
214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --
217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

211: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
212: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
213: --
214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --
217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
219: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

213: --
214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --
217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
219: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
220: , p_procedure IN VARCHAR2)
221: RETURN VARCHAR2

Line 218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

214: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --
217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
219: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
220: , p_procedure IN VARCHAR2)
221: RETURN VARCHAR2
222: ;

Line 219: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

215: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
216: --
217: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
218: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
219: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
220: , p_procedure IN VARCHAR2)
221: RETURN VARCHAR2
222: ;
223: --

Line 237: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

233: --
234: FUNCTION GenerateLineCursor (
235: p_application_id IN NUMBER
236: --
237: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --

Line 238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

234: FUNCTION GenerateLineCursor (
235: p_application_id IN NUMBER
236: --
237: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

235: p_application_id IN NUMBER
236: --
237: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

236: --
237: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
244: --

Line 242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

238: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
244: --
245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

239: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
240: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
244: --
245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
247: --

Line 245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

241: --
242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
244: --
245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
247: --
248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

242: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
243: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
244: --
245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
247: --
248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --

Line 248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

244: --
245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
247: --
248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --
251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

245: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
246: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
247: --
248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --
251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
253: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

247: --
248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --
251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
253: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
254: , p_procedure IN VARCHAR2)
255: RETURN VARCHAR2

Line 252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

248: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --
251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
253: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
254: , p_procedure IN VARCHAR2)
255: RETURN VARCHAR2
256: ;

Line 253: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

249: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
250: --
251: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
252: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
253: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
254: , p_procedure IN VARCHAR2)
255: RETURN VARCHAR2
256: ;
257: --

Line 266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

262: --| |
263: --| |
264: --+==========================================================================+
265: FUNCTION GenerateHdrStructure
266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

263: --| |
264: --+==========================================================================+
265: FUNCTION GenerateHdrStructure
266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)

Line 268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

264: --+==========================================================================+
265: FUNCTION GenerateHdrStructure
266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
272: RETURN VARCHAR2;

Line 269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

265: FUNCTION GenerateHdrStructure
266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
272: RETURN VARCHAR2;
273: --

Line 270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

266: (p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
272: RETURN VARCHAR2;
273: --
274: --

Line 271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)

267: ,p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
268: ,p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
269: ,p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
270: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
271: ,p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt)
272: RETURN VARCHAR2;
273: --
274: --
275: --+==========================================================================+

Line 283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

279: --| |
280: --| |
281: --+==========================================================================+
282: FUNCTION GenerateCacheHdrSources
283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
287: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)

Line 284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

280: --| |
281: --+==========================================================================+
282: FUNCTION GenerateCacheHdrSources
283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
287: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
288: RETURN VARCHAR2;

Line 285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

281: --+==========================================================================+
282: FUNCTION GenerateCacheHdrSources
283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
287: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
288: RETURN VARCHAR2;
289: --

Line 286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

282: FUNCTION GenerateCacheHdrSources
283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
287: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
288: RETURN VARCHAR2;
289: --
290:

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

283: (p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
284: ,p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
285: ,p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
286: ,p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
287: ,p_array_datatype_code IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL1)
288: RETURN VARCHAR2;
289: --
290:
291: --

Line 330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

326: --+==========================================================================+
327: --
328: FUNCTION GenerateInsertHdrSources (
329: --
330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

327: --
328: FUNCTION GenerateInsertHdrSources (
329: --
330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --

Line 332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

328: FUNCTION GenerateInsertHdrSources (
329: --
330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

329: --
330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

330: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
331: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
338: --

Line 336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

332: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
338: --
339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

333: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
334: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
338: --
339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
341: --

Line 339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

335: --
336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
338: --
339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
341: --
342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

336: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
337: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
338: --
339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
341: --
342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --

Line 342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

338: --
339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
341: --
342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

339: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
340: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
341: --
342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

341: --
342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

342: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

343: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
351: --

Line 348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

344: --
345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
351: --
352: , p_procedure IN VARCHAR2

Line 349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

345: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
351: --
352: , p_procedure IN VARCHAR2
353: )

Line 350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

346: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
347: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
348: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
349: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
350: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
351: --
352: , p_procedure IN VARCHAR2
353: )
354: RETURN CLOB

Line 369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

365: --+==========================================================================+
366: --
367: FUNCTION GenerateInsertLineSources (
368: --
369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

366: --
367: FUNCTION GenerateInsertLineSources (
368: --
369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --

Line 371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

367: FUNCTION GenerateInsertLineSources (
368: --
369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

368: --
369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

369: p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
370: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
377: --

Line 375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

371: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
377: --
378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

372: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
373: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
377: --
378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
380: --

Line 378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

374: --
375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
377: --
378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
380: --
381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

375: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
376: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
377: --
378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
380: --
381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --

Line 381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

377: --
378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
380: --
381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

Line 382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

378: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
379: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
380: --
381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

Line 384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num

380: --
381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

Line 385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

381: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

Line 386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1

382: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
390: --

Line 387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num

383: --
384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
390: --
391: ,p_procedure IN VARCHAR2

Line 388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30

384: , p_array_application_id IN xla_cmp_source_pkg.t_array_Num
385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
390: --
391: ,p_procedure IN VARCHAR2
392: )

Line 389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num

385: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
386: , p_array_source_type_code IN xla_cmp_source_pkg.t_array_VL1
387: , p_array_flex_value_set_id IN xla_cmp_source_pkg.t_array_Num
388: , p_array_lookup_type IN xla_cmp_source_pkg.t_array_VL30
389: , p_array_view_application_id IN xla_cmp_source_pkg.t_array_Num
390: --
391: ,p_procedure IN VARCHAR2
392: )
393: RETURN CLOB