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.POS_ACK_SEARCH dependencies on AK_QUERY_PKG

Line 687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,

683: '');
684: htp.p('');
685: htp.p('');
686:
687: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
688: p_parent_region_code => 'POS_ACK_SEARCH_R',
689: p_where_clause => l_where_clause,
690: p_responsibility_id => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
691: p_user_id => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

Line 695: l_attribute_index := ak_query_pkg.g_items_table.FIRST;

691: p_user_id => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
692: p_return_parents => 'F',
693: p_return_children => 'F');
694:
695: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
696: l_result_index := ak_query_pkg.g_results_table.FIRST;
697:
698: htp.p('');
699:
Line 696: l_result_index := ak_query_pkg.g_results_table.FIRST;

692: p_return_parents => 'F',
693: p_return_children => 'F');
694:
695: l_attribute_index := ak_query_pkg.g_items_table.FIRST;
696: l_result_index := ak_query_pkg.g_results_table.FIRST;
697:
698: htp.p('

');
699:
700: htp.p('');
Line 751: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN

747: item_code(l_attribute_index) || '"' || ' value="' ||
748: nvl(get_result_value(l_result_index, l_current_col), '') ||
749: '" >');
750: end if;
751: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
752: htp.p(' 755: BORDER=0 WIDTH=23 HEIGHT=21 border=no align=absmiddle>

Line 753: ak_query_pkg.g_items_table(l_attribute_index).attribute_code ||

749: '" >');
750: end if;
751: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
752: htp.p(' 755: BORDER=0 WIDTH=23 HEIGHT=21 border=no align=absmiddle>
756: ');
757: END IF;

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

755: BORDER=0 WIDTH=23 HEIGHT=21 border=no align=absmiddle>
756: ');
757: END IF;
758: IF item_code(l_attribute_index) = 'POS_ACK_SR_ACC_REQD_START_DATE' THEN
759: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
760: l_current_col := l_current_col + 1;
761: htp.p('' ||
762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||
763: ' ');

Line 762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||

758: IF item_code(l_attribute_index) = 'POS_ACK_SR_ACC_REQD_START_DATE' THEN
759: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
760: l_current_col := l_current_col + 1;
761: htp.p('' ||
762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||
763: ' ');
764: htp.p('
Line 765: ak_query_pkg.g_items_table(l_attribute_index).attribute_code ||

761: htp.p('' ||
762: ak_query_pkg.g_items_table(l_attribute_index).attribute_label_long ||
763: ' ');
764: htp.p(' 767: ' MAXLENGTH='||
768: ak_query_pkg.g_items_table(l_attribute_index).attribute_value_length||
769: '>');

Line 768: ak_query_pkg.g_items_table(l_attribute_index).attribute_value_length||

764: htp.p(' 767: ' MAXLENGTH='||
768: ak_query_pkg.g_items_table(l_attribute_index).attribute_value_length||
769: '>');
770: END IF;
771: htp.p('');
772: ELSE

Line 815: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);

811: ELSIF (item_style(l_attribute_index) = 'IMAGE') THEN
812: null;
813: END IF;
814: END IF;
815: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
816:
817: if ((l_current_col mod 1) = 0) THEN
818: l_row := l_row + 1;
819: IF l_row = 1 THEN

Line 1038: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,

1034: /*
1035: select count(*) into l_count
1036: from pos_ack_select;
1037: */
1038: ak_query_pkg.exec_query(p_parent_region_appl_id => 178,
1039: p_parent_region_code => 'POS_ACK_EDIT_R',
1040: p_where_clause => '',
1041: p_responsibility_id => g_responsibility_id,
1042: p_user_id => g_user_id,

Line 1045: l_count := ak_query_pkg.g_results_table.count;

1041: p_responsibility_id => g_responsibility_id,
1042: p_user_id => g_user_id,
1043: p_return_parents => 'T',
1044: p_return_children => 'F');
1045: l_count := ak_query_pkg.g_results_table.count;
1046: veera_debug('SearchPO: no of rows: ' || to_char(l_count));
1047:
1048: htp.p('' ||
1676: --LOV Test
1677: '" >'
1678: );
1679: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
1680: /*
1681: htp.p(' 1683: '>');

Line 1682: ak_query_pkg.g_items_table(l_attribute_index).attribute_code || ''')"' ||

1678: );
1679: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN
1680: /*
1681: htp.p(' 1683: '>');
1684: */
1685: htp.p(' 1683: '>');
1684: */
1685: htp.p(' 1688: '>');
1689: END IF;
1690: htp.p('');

Line 1730: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);

1726: END IF;
1727: END IF;
1728: END IF;
1729: <>
1730: l_attribute_index := ak_query_pkg.g_items_table.NEXT(l_attribute_index);
1731: END LOOP;
1732: -- test promise date
1733: htp.p('
1734: