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.
1: PACKAGE BODY POS_ACK_SEARCH AS 2: /* $Header: POSASRCB.pls 115.24 2001/12/05 15:27:19 pkm ship $ */ 3: 4: PROCEDURE veera_debug(p_debug_string VARCHAR2) 5: IS
117: 118: htp.p(' 119:
120: 121: 122: ' NAME="fixedframe" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder=no SCROLLING=NO> 123: 124: 125: ' NAME="criteria" MARGINWIDTH="0" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO SCROLLING=NO> 126: 127: 128:
124: 125: ' NAME="criteria" MARGINWIDTH="0" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO SCROLLING=NO> 126: 127: 128: 129: NAME="counter" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 130: 131: 132: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO>
127: 128: 129: NAME="counter" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 130: 131: 132: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO> 133: 134: 135: NAME="add" MARGINWIDTH="5" MARGINHEIGHT="5" SCROLLING=NO NORESIZE FRAMEBORDER=NO>
130: 131: 132: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO> 133: 134: 135: NAME="add" MARGINWIDTH="5" MARGINHEIGHT="5" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 136: 137: NAME="lowerbanner" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 138:
218: 219: NAME="upperbanner" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder=no SCROLLING=NO> 220: 221: 222: 223: ' NAME="fixedframe" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder=no SCROLLING=NO> 224: 225: 226: NAME="criteria" MARGINWIDTH="0" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO SCROLLING=NO>
221: 222: 223: ' NAME="fixedframe" MARGINWIDTH="0" MARGINHEIGHT="0" frameborder=no SCROLLING=NO> 224: 225: 226: NAME="criteria" MARGINWIDTH="0" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO SCROLLING=NO> 227: 228: 229:
225: 226: NAME="criteria" MARGINWIDTH="0" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO SCROLLING=NO> 227: 228: 229: 230: NAME="counter" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 231: 232: 233: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO>
228: 229: 230: NAME="counter" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 231: 232: 233: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO> 234: 235: 236: NAME="add" MARGINWIDTH="5" MARGINHEIGHT="5" SCROLLING=NO NORESIZE FRAMEBORDER=NO>
231: 232: 233: NAME="result" MARGINWIDTH="5" MARGINHEIGHT="0" NORESIZE FRAMEBORDER=NO> 234: 235: 236: NAME="add" MARGINWIDTH="5" MARGINHEIGHT="5" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 237: 238: NAME="lowerbanner" MARGINWIDTH="0" MARGINHEIGHT="0" SCROLLING=NO NORESIZE FRAMEBORDER=NO> 239:
315: { 316: var c_where_clause = ""; 317: c_where_clause = escape(c_where_clause, 1); 318: 319: LOV("178", c_attribute_code, "178", "POS_ACK_SEARCH_R", 320: "POS_ACK_SEARCH", "criteria", "", c_where_clause); 321: } 322: 323:
316: var c_where_clause = ""; 317: c_where_clause = escape(c_where_clause, 1); 318: 319: LOV("178", c_attribute_code, "178", "POS_ACK_SEARCH_R", 320: "POS_ACK_SEARCH", "criteria", "", c_where_clause); 321: } 322: 323: 324: function clearsearchfields()
322: 323: 324: function clearsearchfields() 325: { 326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value=""; 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value="";
323: 324: function clearsearchfields() 325: { 326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value=""; 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value=""; 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.value="";
324: function clearsearchfields() 325: { 326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value=""; 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value=""; 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.value=""; 332: }
325: { 326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value=""; 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value=""; 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.value=""; 332: } 333:
326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value=""; 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value=""; 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.value=""; 332: } 333: 334: ');
327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.value=""; 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.value=""; 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value=""; 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value=""; 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.value=""; 332: } 333: 334: '); 335:
348: 349: /* if the supplier is not set up for the user dont paint the search fields. instead 350: show a message */ 351: IF l_supplier_id <> -1 THEN 352: htp.p(''); 353: 354: htp.p(''); 355: 356: Paint_Search_Fields(p_advance_flag => p_advance_flag,
367: 368: if l_po_number is not null then 369: veera_debug('criteria_frame: po number not null'); 370: htp.p(''); 373: end if; 374: 375: htp.bodyClose;
510: } 511: 512: function SubmitDlg(p_start, p_end, p_total, p_rows_inserted, p_string) 513: { 514: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" + 515: "p_first=" + p_start + 516: "&p_last=" + p_end + 517: "&p_total=" + p_total; 518:
517: "&p_total=" + p_total; 518: 519: parent.counter.location.href = l_URL; 520: 521: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" + 522: "p_total=" + p_total; 523: 524: parent.add.location.href = l_URL2; 525:
581: } 582: 583: function NextSet() 584: { 585: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value== "0") 586: { 587: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 588: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-26) 589: }
583: function NextSet() 584: { 585: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value== "0") 586: { 587: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 588: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-26) 589: } 590: else 591: {
584: { 585: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value== "0") 586: { 587: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 588: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-26) 589: } 590: else 591: { 592: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value =
588: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-26) 589: } 590: else 591: { 592: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 593: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-25) 594: } 595: top.criteria.document.POS_ACK_SEARCH.submit(); 596: }
589: } 590: else 591: { 592: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 593: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-25) 594: } 595: top.criteria.document.POS_ACK_SEARCH.submit(); 596: } 597:
591: { 592: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 593: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-25) 594: } 595: top.criteria.document.POS_ACK_SEARCH.submit(); 596: } 597: 598: function PreviousSet() 599: {
596: } 597: 598: function PreviousSet() 599: { 600: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "0" || top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "1") 601: { 602: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 603: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - 25; 604: }
598: function PreviousSet() 599: { 600: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "0" || top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "1") 601: { 602: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 603: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - 25; 604: } 605: top.criteria.document.POS_ACK_SEARCH.submit(); 606: }
599: { 600: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "0" || top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value != "1") 601: { 602: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 603: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - 25; 604: } 605: top.criteria.document.POS_ACK_SEARCH.submit(); 606: } 607:
601: { 602: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value = 603: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - 25; 604: } 605: top.criteria.document.POS_ACK_SEARCH.submit(); 606: } 607: 608: 609: function SubmitAcknowledge()
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), 692: p_return_parents => 'F',
819: IF l_row = 1 THEN 820: htp.p('
930: htp.p(' 931: 932: function LoadCounter(p_start, p_end, p_total) 933: { 934: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" + 935: "p_first=" + p_start + 936: "&p_last=" + p_end + 937: "&p_total=" + p_total; 938: /*
940: */ 941: 942: parent.counter.location.href = l_URL; 943: 944: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" + 945: "p_total=" + p_total; 946: 947: parent.add.location.href = l_URL2; 948:
1056: '' || 1057: '' || 1058: ''); 1059: htp.p('
1104: { 1105: if (p_rows_inserted > 0) 1106: alert(p_string1); 1107: alert(p_string2); 1108: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" + 1109: "p_first=" + p_start + 1110: "&p_last=" + p_end + 1111: "&p_total=" + p_total; 1112:
1111: "&p_total=" + p_total; 1112: 1113: parent.counter.location.href = l_URL; 1114: 1115: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" + 1116: "p_total=" + p_total; 1117: 1118: parent.add.location.href = l_URL2; 1119:
1209: '' || 1210: '
2205: htp.bodyClose; 2206: htp.htmlClose; 2207: END DISPLAY_LOG; 2208: 2209: END POS_ACK_SEARCH;