11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_gl_flex_values_obj_tbl IN OUT NOCOPY GL_FLEX_VALUES_OBJ_TBL,
15: p_gl_flex_values_nh_obj_tbl IN OUT NOCOPY GL_FLEX_VALUES_NH_OBJ_TBL,
16: p_gl_flex_values_status OUT NOCOPY VARCHAR2,
17: p_gl_flex_values_nh_status OUT NOCOPY VARCHAR2
18:
19: ) AS
120: END LOOP;
121: END IF;
122:
123:
124: IF p_gl_flex_values_nh_obj_tbl IS NOT NULL AND p_gl_flex_values_nh_obj_tbl.COUNT > 0 THEN
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
121: END IF;
122:
123:
124: IF p_gl_flex_values_nh_obj_tbl IS NOT NULL AND p_gl_flex_values_nh_obj_tbl.COUNT > 0 THEN
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
122:
123:
124: IF p_gl_flex_values_nh_obj_tbl IS NOT NULL AND p_gl_flex_values_nh_obj_tbl.COUNT > 0 THEN
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
123:
124: IF p_gl_flex_values_nh_obj_tbl IS NOT NULL AND p_gl_flex_values_nh_obj_tbl.COUNT > 0 THEN
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
131: l_gl_flex_values_nh_tbl(I).child_flex_value_high := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_high;
124: IF p_gl_flex_values_nh_obj_tbl IS NOT NULL AND p_gl_flex_values_nh_obj_tbl.COUNT > 0 THEN
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
131: l_gl_flex_values_nh_tbl(I).child_flex_value_high := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_high;
132: END IF;
125: FOR I in 1..p_gl_flex_values_nh_obj_tbl.LAST LOOP
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
131: l_gl_flex_values_nh_tbl(I).child_flex_value_high := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_high;
132: END IF;
133: END LOOP;
126: IF p_gl_flex_values_nh_obj_tbl.EXISTS(I) THEN
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
131: l_gl_flex_values_nh_tbl(I).child_flex_value_high := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_high;
132: END IF;
133: END LOOP;
134: END IF;
127: l_gl_flex_values_nh_tbl(I).value_set_name := p_gl_flex_values_nh_obj_tbl(I).value_set_name;
128: l_gl_flex_values_nh_tbl(I).parent_flex_value := p_gl_flex_values_nh_obj_tbl(I).parent_flex_value;
129: l_gl_flex_values_nh_tbl(I).range_attribute := p_gl_flex_values_nh_obj_tbl(I).range_attribute;
130: l_gl_flex_values_nh_tbl(I).child_flex_value_low := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_low;
131: l_gl_flex_values_nh_tbl(I).child_flex_value_high := p_gl_flex_values_nh_obj_tbl(I).child_flex_value_high;
132: END IF;
133: END LOOP;
134: END IF;
135:
160:
161: IF l_gl_flex_values_nh_tbl.COUNT > 0 THEN
162: FOR I in 1..l_gl_flex_values_nh_tbl.LAST LOOP
163: IF l_gl_flex_values_nh_tbl.EXISTS(I) THEN
164: p_gl_flex_values_nh_obj_tbl(I).status := l_gl_flex_values_nh_tbl(I).status;
165: END IF;
166: END LOOP;
167: END IF;
168: