DBA Data[Home] [Help]

APPS.POS_ACK_SEARCH dependencies on POS_ACK_SEARCH

Line 1: PACKAGE BODY POS_ACK_SEARCH AS

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

Line 121:

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>

Line 124:

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:

Line 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>

Line 131:

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>

Line 134:

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:

Line 222:

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>

Line 225:

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:

Line 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>

Line 232:

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>

Line 235:

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:

Line 319: LOV("178", c_attribute_code, "178", "POS_ACK_SEARCH_R",

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:

Line 320: "POS_ACK_SEARCH", "criteria", "", c_where_clause);

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

Line 326: document.POS_ACK_SEARCH.POS_ACK_SUPPLIER_SITE.value="";

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

Line 327: document.POS_ACK_SEARCH.POS_ACK_SR_SUPPLIER_SITE_ID.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="";

Line 328: document.POS_ACK_SEARCH.POS_ACK_SR_PO_NUMBER.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: }

Line 329: document.POS_ACK_SEARCH.POS_ACK_SR_DOC_TYPE.value="";

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:

Line 330: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_START_DATE.value="";

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

Line 331: document.POS_ACK_SEARCH.POS_ACK_SR_ACC_REQD_END_DATE.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: ');
335:

Line 352: htp.p('
');

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,

Line 371: htp.p('document.POS_ACK_SEARCH.submit(); ');

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;

Line 514: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +

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:

Line 521: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" +

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:

Line 585: if (top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value== "0")

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: }

Line 587: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value =

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: {

Line 588: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-26)

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 =

Line 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: }

Line 593: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - (-25)

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:

Line 595: top.criteria.document.POS_ACK_SEARCH.submit();

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: {

Line 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")

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: }

Line 602: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value =

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: }

Line 603: top.criteria.document.POS_ACK_SEARCH.POS_ACK_SR_ROW_NUM.value - 25;

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:

Line 605: top.criteria.document.POS_ACK_SEARCH.submit();

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

Line 688: p_parent_region_code => 'POS_ACK_SEARCH_R',

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

Line 823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));

819: IF l_row = 1 THEN
820: htp.p('');
821:
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
825: htp.p('');
826: htp.p('');
827:

Line 934: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +

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: /*

Line 944: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" +

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:

Line 1060: '/POS_ACK_SEARCH.ACKNOWLEDGE_POS" target="result" method="POST">');

1056: '' ||
1057: '' ||
1058: '');
1059: htp.p('

');
1061:
1062:
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));

Line 1108: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +

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:

Line 1115: var l_URL2 = parent.scriptName + "/POS_ACK_SEARCH.ADD_FRAME?" +

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:

Line 1213: '/POS_ACK_SEARCH.ACKNOWLEDGE_POS" target="result" method="POST">');

1209: '' ||
1210: '

');
1211: --test
1212: htp.p('
');
1214:
1215:
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1217: paint_edit_pos(to_number(pos_ack_sr_row_num));

Line 2209: END POS_ACK_SEARCH;

2205: htp.bodyClose;
2206: htp.htmlClose;
2207: END DISPLAY_LOG;
2208:
2209: END POS_ACK_SEARCH;