DBA Data[Home] [Help]

APPS.POA_CM_EVALUATION_ICX dependencies on AK_QUERY_PKG

Line 703: ak_query_pkg.exec_query(p_parent_region_appl_id=>201,

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',

Line 711: l_index := ak_query_pkg.g_items_table.FIRST;

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

Line 714: IF (ak_query_pkg.g_items_table(l_index).node_display_flag = 'Y') AND

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="'||

Line 716: IF (ak_query_pkg.g_items_table(l_index).item_style = 'HIDDEN') THEN

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: '">');

Line 720: GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

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('');

Line 723: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN

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('');
725: htp.p(''||
726: ''||
727: ak_query_pkg.g_items_table(l_index).attribute_label_long||

Line 727: ak_query_pkg.g_items_table(l_index).attribute_label_long||

723: ELSIF (ak_query_pkg.g_items_table(l_index).item_style = 'TEXT') THEN
724: htp.p('');
725: htp.p(''||
726: ''||
727: ak_query_pkg.g_items_table(l_index).attribute_label_long||
728: '
 ');
729: htp.p(''||
730: '');
731: htp.p('

Line 731: htp.p('

727: ak_query_pkg.g_items_table(l_index).attribute_label_long||
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)||

Line 732: ' onChange="javascript:reset_hidden(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||

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||'>
 ');

Line 733: ' onFocus="javascript:check_read_only(''' || ak_query_pkg.g_items_table(l_index).attribute_code || ''')"' ||

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:

Line 734: ' VALUE="'|| GetAttributeValue(p_attribute_name=>ak_query_pkg.g_items_table(l_index).attribute_code,

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

Line 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||'> ');

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('

Line 738: IF (ak_query_pkg.g_items_table(l_index).lov_region_code IS NOT NULL AND

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: '>
');

Line 739: ak_query_pkg.g_items_table(l_index).lov_attribute_code IS NOT NULL) THEN

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:

Line 740: htp.p('

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;

Line 752: htp.p('');
754:
755: END IF;
756:

Line 753: ' - '||ak_query_pkg.g_items_table(l_index).item_style||' -->');

749:
750: ELSE
751:
752: htp.p('');
754:
755: END IF;
756:
757: END IF;

Line 759: l_index := ak_query_pkg.g_items_table.NEXT(l_index);

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('');