699: l_count NUMBER;
700: l_where_clause VARCHAR2(240) := null;
701: temp VARCHAR2(30);
702: BEGIN
703: ak_query_pkg.exec_query(p_parent_region_appl_id=>201,
704: p_parent_region_code=>'POA_CM_EVALUATION_R',
705: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
706: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
707: p_return_parents=>'F',
707: p_return_parents=>'F',
708: p_return_children=>'F');
709:
710: l_count := 0;
711: l_index := ak_query_pkg.g_items_table.FIRST;
712: WHILE (l_index IS NOT NULL) LOOP
713: l_count := l_count + 1;
714: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
715: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
710: l_count := 0;
711: l_index := ak_query_pkg.g_items_table.FIRST;
712: WHILE (l_index IS NOT NULL) LOOP
713: l_count := l_count + 1;
714: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
715: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
716: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
717: htp.p('
718: ak_query_pkg.g_items_table(l_index).attribute_code||
719: '" TYPE="hidden" VALUE="'||
712: WHILE (l_index IS NOT NULL) LOOP
713: l_count := l_count + 1;
714: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND
715: (ak_query_pkg.g_items_table(l_index).secured_column = 'F') THEN
716: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
717: htp.p('
718: ak_query_pkg.g_items_table(l_index).attribute_code||
719: '" TYPE="hidden" VALUE="'||
720: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
721: p_start_index=>l_count)||
722: '">');
716: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN
717: htp.p('');
723: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
724: htp.p('
719: '" TYPE="hidden" VALUE="'||
720: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
721: p_start_index=>l_count)||
722: '">');
723: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
724: htp.p('
723: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
724: htp.p('
727: ak_query_pkg.g_items_table(l_index).attribute_label_long||
728: '
728: '
729: htp.p('
730: '');
731: htp.p('
732: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||
733: ' onFocus="javascript:check_read_only(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||
734: ' VALUE="'|| GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
735: p_start_index=>l_count)||
736: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length||' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length||'> ');
737:
738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
732: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||
733: ' onFocus="javascript:check_read_only(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||
734: ' VALUE="'|| GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
735: p_start_index=>l_count)||
736: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length||' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length||'> ');
737:
738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
739: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
740: htp.p('
734: ' VALUE="'|| GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,
735: p_start_index=>l_count)||
736: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length||' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length||'> ');
737:
738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
739: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
740: htp.p('
741: -- ' onMouseOver="window.status=''List of Values'';return true"' ||
742: '>
735: p_start_index=>l_count)||
736: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length||' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length||'> ');
737:
738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
739: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
740: htp.p('
741: -- ' onMouseOver="window.status=''List of Values'';return true"' ||
742: '>');
743:
736: '" SIZE='||ak_query_pkg.g_items_table(l_index).display_value_length||' MAXLENGTH='||ak_query_pkg.g_items_table(l_index).attribute_value_length||'> ');
737:
738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND
739: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN
740: htp.p('
741: -- ' onMouseOver="window.status=''List of Values'';return true"' ||
742: '>');
743:
744: END IF;
749:
750: ELSE
751:
752: htp.p('');
754:
755: END IF;
756:
757: END IF;
755: END IF;
756:
757: END IF;
758:
759: l_index := ak_query_pkg.g_items_table.NEXT(l_index);
760:
761: END LOOP;
762:
763: htp.p('');