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.PO_PDOI_UTL dependencies on PO_PDOI_PARAMS

Line 67: -- Issues a commit if PO_PDOI_PARAMS.g_request.commit_work is

63: -----------------------------------------------------------------------
64: --Start of Comments
65: --Name: commit_work
66: --Function:
67: -- Issues a commit if PO_PDOI_PARAMS.g_request.commit_work is
68: -- FND_API.G_TRUE
69: --Parameters:
70: --IN:
71: --IN OUT:

Line 88: IF (PO_PDOI_PARAMS.g_request.commit_work = FND_API.G_TRUE) THEN

84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin (d_module);
86: END IF;
87:
88: IF (PO_PDOI_PARAMS.g_request.commit_work = FND_API.G_TRUE) THEN
89: COMMIT;
90: END IF;
91:
92: IF (PO_LOG.d_proc) THEN

Line 200: processing_id = -PO_PDOI_PARAMS.g_processing_id

196: d_position := 20;
197: FORALL i IN 1..p_id_tbl.COUNT
198: UPDATE po_headers_interface
199: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
200: processing_id = -PO_PDOI_PARAMS.g_processing_id
201: WHERE interface_header_id = p_id_tbl(i)
202: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
203: ELSE
204: d_position := 30;

Line 202: AND processing_id = PO_PDOI_PARAMS.g_processing_id;

198: UPDATE po_headers_interface
199: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
200: processing_id = -PO_PDOI_PARAMS.g_processing_id
201: WHERE interface_header_id = p_id_tbl(i)
202: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
203: ELSE
204: d_position := 30;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 286: processing_id = -PO_PDOI_PARAMS.g_processing_id

282:
283: FORALL i IN 1..p_id_tbl.COUNT
284: UPDATE po_lines_interface
285: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
286: processing_id = -PO_PDOI_PARAMS.g_processing_id
287: WHERE interface_header_id = p_id_tbl(i)
288: AND processing_id = PO_PDOI_PARAMS.g_processing_id
289: RETURNING interface_line_id, interface_header_id
290: BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;

Line 288: AND processing_id = PO_PDOI_PARAMS.g_processing_id

284: UPDATE po_lines_interface
285: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
286: processing_id = -PO_PDOI_PARAMS.g_processing_id
287: WHERE interface_header_id = p_id_tbl(i)
288: AND processing_id = PO_PDOI_PARAMS.g_processing_id
289: RETURNING interface_line_id, interface_header_id
290: BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;
291:
292: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID) THEN

Line 298: processing_id = -PO_PDOI_PARAMS.g_processing_id

294:
295: FORALL i IN 1..p_id_tbl.COUNT
296: UPDATE po_lines_interface
297: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
298: processing_id = -PO_PDOI_PARAMS.g_processing_id
299: WHERE interface_line_id = p_id_tbl(i)
300: AND processing_id = PO_PDOI_PARAMS.g_processing_id
301: RETURNING interface_line_id, interface_header_id
302: BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;

Line 300: AND processing_id = PO_PDOI_PARAMS.g_processing_id

296: UPDATE po_lines_interface
297: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
298: processing_id = -PO_PDOI_PARAMS.g_processing_id
299: WHERE interface_line_id = p_id_tbl(i)
300: AND processing_id = PO_PDOI_PARAMS.g_processing_id
301: RETURNING interface_line_id, interface_header_id
302: BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;
303: ELSE
304:

Line 324: IF (PO_PDOI_PARAMS.g_request.document_type <>

320: reject_price_diff_intf
321: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID
322: , p_id_tbl => l_intf_line_id_tbl);
323:
324: IF (PO_PDOI_PARAMS.g_request.document_type <>
325: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
326:
327: d_position := 60;
328: reject_attr_values_intf

Line 404: processing_id = -PO_PDOI_PARAMS.g_processing_id

400: d_position := 20;
401: FORALL i IN 1..p_id_tbl.COUNT
402: UPDATE po_line_locations_interface
403: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
404: processing_id = -PO_PDOI_PARAMS.g_processing_id
405: WHERE interface_line_id = p_id_tbl(i)
406: AND processing_id = PO_PDOI_PARAMS.g_processing_id
407: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
408: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE

Line 406: AND processing_id = PO_PDOI_PARAMS.g_processing_id

402: UPDATE po_line_locations_interface
403: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
404: processing_id = -PO_PDOI_PARAMS.g_processing_id
405: WHERE interface_line_id = p_id_tbl(i)
406: AND processing_id = PO_PDOI_PARAMS.g_processing_id
407: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
408: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
409: RETURNING interface_line_location_id, interface_header_id
410: BULK COLLECT INTO l_intf_line_loc_id_tbl, l_intf_header_id_tbl;

Line 417: processing_id = -PO_PDOI_PARAMS.g_processing_id

413: d_position := 30;
414: FORALL i IN 1..p_id_tbl.COUNT
415: UPDATE po_line_locations_interface
416: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
417: processing_id = -PO_PDOI_PARAMS.g_processing_id
418: WHERE interface_line_location_id = p_id_tbl(i)
419: AND processing_id = PO_PDOI_PARAMS.g_processing_id
420: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
421: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE

Line 419: AND processing_id = PO_PDOI_PARAMS.g_processing_id

415: UPDATE po_line_locations_interface
416: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
417: processing_id = -PO_PDOI_PARAMS.g_processing_id
418: WHERE interface_line_location_id = p_id_tbl(i)
419: AND processing_id = PO_PDOI_PARAMS.g_processing_id
420: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
421: <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
422: RETURNING interface_line_location_id, interface_header_id
423: BULK COLLECT INTO l_intf_line_loc_id_tbl, l_intf_header_id_tbl;

Line 436: IF (PO_PDOI_PARAMS.g_request.document_type =

432: ( p_intf_header_id_tbl => l_intf_header_id_tbl
433: );
434:
435: IF (p_cascade = FND_API.G_TRUE) THEN
436: IF (PO_PDOI_PARAMS.g_request.document_type =
437: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
438:
439: d_position := 60;
440: reject_distributions_intf

Line 505: processing_id = -PO_PDOI_PARAMS.g_processing_id

501: d_position := 20;
502: FORALL i IN 1..p_id_tbl.COUNT
503: UPDATE po_distributions_interface
504: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
505: processing_id = -PO_PDOI_PARAMS.g_processing_id
506: WHERE interface_line_location_id = p_id_tbl(i)
507: AND processing_id = PO_PDOI_PARAMS.g_processing_id
508: RETURNING interface_header_id
509: BULK COLLECT INTO l_intf_header_id_tbl;

Line 507: AND processing_id = PO_PDOI_PARAMS.g_processing_id

503: UPDATE po_distributions_interface
504: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
505: processing_id = -PO_PDOI_PARAMS.g_processing_id
506: WHERE interface_line_location_id = p_id_tbl(i)
507: AND processing_id = PO_PDOI_PARAMS.g_processing_id
508: RETURNING interface_header_id
509: BULK COLLECT INTO l_intf_header_id_tbl;
510:
511: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_DISTRIBUTION_ID) THEN

Line 516: processing_id = -PO_PDOI_PARAMS.g_processing_id

512: d_position := 30;
513: FORALL i IN 1..p_id_tbl.COUNT
514: UPDATE po_distributions_interface
515: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
516: processing_id = -PO_PDOI_PARAMS.g_processing_id
517: WHERE interface_distribution_id = p_id_tbl(i)
518: AND processing_id = PO_PDOI_PARAMS.g_processing_id
519: RETURNING interface_header_id
520: BULK COLLECT INTO l_intf_header_id_tbl;

Line 518: AND processing_id = PO_PDOI_PARAMS.g_processing_id

514: UPDATE po_distributions_interface
515: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
516: processing_id = -PO_PDOI_PARAMS.g_processing_id
517: WHERE interface_distribution_id = p_id_tbl(i)
518: AND processing_id = PO_PDOI_PARAMS.g_processing_id
519: RETURNING interface_header_id
520: BULK COLLECT INTO l_intf_header_id_tbl;
521:
522: ELSE

Line 591: processing_id = -PO_PDOI_PARAMS.g_processing_id

587: d_position := 20;
588: FORALL i IN 1..p_id_tbl.COUNT
589: UPDATE po_price_diff_interface
590: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
591: processing_id = -PO_PDOI_PARAMS.g_processing_id
592: WHERE interface_line_id = p_id_tbl(i)
593: AND processing_id = PO_PDOI_PARAMS.g_processing_id
594: RETURNING interface_header_id
595: BULK COLLECT INTO l_intf_header_id_tbl;

Line 593: AND processing_id = PO_PDOI_PARAMS.g_processing_id

589: UPDATE po_price_diff_interface
590: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
591: processing_id = -PO_PDOI_PARAMS.g_processing_id
592: WHERE interface_line_id = p_id_tbl(i)
593: AND processing_id = PO_PDOI_PARAMS.g_processing_id
594: RETURNING interface_header_id
595: BULK COLLECT INTO l_intf_header_id_tbl;
596:
597: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_PRICE_DIFF_INTERFACE_ID) THEN

Line 602: processing_id = -PO_PDOI_PARAMS.g_processing_id

598: d_position := 30;
599: FORALL i IN 1..p_id_tbl.COUNT
600: UPDATE po_price_diff_interface
601: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
602: processing_id = -PO_PDOI_PARAMS.g_processing_id
603: WHERE price_diff_interface_id = p_id_tbl(i)
604: AND processing_id = PO_PDOI_PARAMS.g_processing_id
605: RETURNING interface_header_id
606: BULK COLLECT INTO l_intf_header_id_tbl;

Line 604: AND processing_id = PO_PDOI_PARAMS.g_processing_id

600: UPDATE po_price_diff_interface
601: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
602: processing_id = -PO_PDOI_PARAMS.g_processing_id
603: WHERE price_diff_interface_id = p_id_tbl(i)
604: AND processing_id = PO_PDOI_PARAMS.g_processing_id
605: RETURNING interface_header_id
606: BULK COLLECT INTO l_intf_header_id_tbl;
607:
608: ELSE

Line 683: processing_id = -PO_PDOI_PARAMS.g_processing_id

679: d_position := 20;
680: FORALL i IN 1..p_id_tbl.COUNT
681: UPDATE po_attr_values_interface
682: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
683: processing_id = -PO_PDOI_PARAMS.g_processing_id
684: WHERE interface_line_id = p_id_tbl(i)
685: AND processing_id = PO_PDOI_PARAMS.g_processing_id
686: RETURNING interface_header_id
687: BULK COLLECT INTO l_intf_header_id_tbl;

Line 685: AND processing_id = PO_PDOI_PARAMS.g_processing_id

681: UPDATE po_attr_values_interface
682: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
683: processing_id = -PO_PDOI_PARAMS.g_processing_id
684: WHERE interface_line_id = p_id_tbl(i)
685: AND processing_id = PO_PDOI_PARAMS.g_processing_id
686: RETURNING interface_header_id
687: BULK COLLECT INTO l_intf_header_id_tbl;
688:
689: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_ATTR_VALUES_ID) THEN

Line 694: processing_id = -PO_PDOI_PARAMS.g_processing_id

690: d_position := 30;
691: FORALL i IN 1..p_id_tbl.COUNT
692: UPDATE po_attr_values_interface
693: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
694: processing_id = -PO_PDOI_PARAMS.g_processing_id
695: WHERE interface_attr_values_id = p_id_tbl(i)
696: AND processing_id = PO_PDOI_PARAMS.g_processing_id
697: RETURNING interface_header_id
698: BULK COLLECT INTO l_intf_header_id_tbl;

Line 696: AND processing_id = PO_PDOI_PARAMS.g_processing_id

692: UPDATE po_attr_values_interface
693: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
694: processing_id = -PO_PDOI_PARAMS.g_processing_id
695: WHERE interface_attr_values_id = p_id_tbl(i)
696: AND processing_id = PO_PDOI_PARAMS.g_processing_id
697: RETURNING interface_header_id
698: BULK COLLECT INTO l_intf_header_id_tbl;
699:
700: ELSE

Line 769: processing_id = -PO_PDOI_PARAMS.g_processing_id

765: d_position := 20;
766: FORALL i IN 1..p_id_tbl.COUNT
767: UPDATE po_attr_values_tlp_interface
768: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
769: processing_id = -PO_PDOI_PARAMS.g_processing_id
770: WHERE interface_line_id = p_id_tbl(i)
771: AND processing_id = PO_PDOI_PARAMS.g_processing_id
772: RETURNING interface_header_id
773: BULK COLLECT INTO l_intf_header_id_tbl;

Line 771: AND processing_id = PO_PDOI_PARAMS.g_processing_id

767: UPDATE po_attr_values_tlp_interface
768: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
769: processing_id = -PO_PDOI_PARAMS.g_processing_id
770: WHERE interface_line_id = p_id_tbl(i)
771: AND processing_id = PO_PDOI_PARAMS.g_processing_id
772: RETURNING interface_header_id
773: BULK COLLECT INTO l_intf_header_id_tbl;
774:
775: ELSIF (p_id_param_type = PO_PDOI_CONSTANTS.g_INTERFACE_ATTR_VALUES_TLP_ID) THEN

Line 781: processing_id = -PO_PDOI_PARAMS.g_processing_id

777:
778: FORALL i IN 1..p_id_tbl.COUNT
779: UPDATE po_attr_values_tlp_interface
780: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
781: processing_id = -PO_PDOI_PARAMS.g_processing_id
782: WHERE interface_attr_values_tlp_id = p_id_tbl(i)
783: AND processing_id = PO_PDOI_PARAMS.g_processing_id
784: RETURNING interface_header_id
785: BULK COLLECT INTO l_intf_header_id_tbl;

Line 783: AND processing_id = PO_PDOI_PARAMS.g_processing_id

779: UPDATE po_attr_values_tlp_interface
780: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
781: processing_id = -PO_PDOI_PARAMS.g_processing_id
782: WHERE interface_attr_values_tlp_id = p_id_tbl(i)
783: AND processing_id = PO_PDOI_PARAMS.g_processing_id
784: RETURNING interface_header_id
785: BULK COLLECT INTO l_intf_header_id_tbl;
786:
787: ELSE

Line 955: IF (PO_PDOI_PARAMS.g_request.document_type =

951: IF (PO_LOG.d_proc) THEN
952: PO_LOG.proc_begin(d_module);
953: END IF;
954:
955: IF (PO_PDOI_PARAMS.g_request.document_type =
956: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
957: x_doc_type := 'PA';
958: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
959:

Line 958: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;

954:
955: IF (PO_PDOI_PARAMS.g_request.document_type =
956: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
957: x_doc_type := 'PA';
958: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
959:
960: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
961: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
962: x_doc_type := 'PO';

Line 960: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

956: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN
957: x_doc_type := 'PA';
958: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
959:
960: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
961: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
962: x_doc_type := 'PO';
963: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
964:

Line 963: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;

959:
960: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
961: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
962: x_doc_type := 'PO';
963: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
964:
965: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
966: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
967: x_doc_type := 'QUOTATION';

Line 965: ELSIF (PO_PDOI_PARAMS.g_request.document_type =

961: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
962: x_doc_type := 'PO';
963: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_type;
964:
965: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
966: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
967: x_doc_type := 'QUOTATION';
968: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_subtype;
969: END IF;

Line 968: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_subtype;

964:
965: ELSIF (PO_PDOI_PARAMS.g_request.document_type =
966: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
967: x_doc_type := 'QUOTATION';
968: x_doc_subtype := PO_PDOI_PARAMS.g_request.document_subtype;
969: END IF;
970:
971: IF (PO_LOG.d_proc) THEN
972: PO_LOG.proc_end(d_module);

Line 1132: PO_PDOI_PARAMS.g_docs_info(p_intf_header_id_tbl(i)).has_errors := FND_API.G_TRUE;

1128:
1129: -- Mark doc info to indicate that an error has occurred.
1130: FOR i IN 1..p_intf_header_id_tbl.COUNT LOOP
1131: IF (p_intf_header_id_tbl(i) IS NOT NULL) THEN
1132: PO_PDOI_PARAMS.g_docs_info(p_intf_header_id_tbl(i)).has_errors := FND_API.G_TRUE;
1133: END IF;
1134: END LOOP;
1135:
1136: IF (PO_LOG.d_proc) THEN

Line 1192: processing_id = -PO_PDOI_PARAMS.g_processing_id

1188:
1189: -- reject line level records
1190: UPDATE po_lines_interface
1191: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1192: processing_id = -PO_PDOI_PARAMS.g_processing_id
1193: WHERE interface_header_id = p_intf_header_id
1194: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1195: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1196: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,

Line 1194: AND processing_id = PO_PDOI_PARAMS.g_processing_id

1190: UPDATE po_lines_interface
1191: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1192: processing_id = -PO_PDOI_PARAMS.g_processing_id
1193: WHERE interface_header_id = p_intf_header_id
1194: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1195: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1196: IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
1197: PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT);
1198:

Line 1204: processing_id = -PO_PDOI_PARAMS.g_processing_id

1200:
1201: -- reject line location level records
1202: UPDATE po_line_locations_interface
1203: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1204: processing_id = -PO_PDOI_PARAMS.g_processing_id
1205: WHERE interface_header_id = p_intf_header_id
1206: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1207: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1208: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line 1206: AND processing_id = PO_PDOI_PARAMS.g_processing_id

1202: UPDATE po_line_locations_interface
1203: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1204: processing_id = -PO_PDOI_PARAMS.g_processing_id
1205: WHERE interface_header_id = p_intf_header_id
1206: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1207: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1208: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;
1209:
1210: d_position := 40;

Line 1215: processing_id = -PO_PDOI_PARAMS.g_processing_id

1211:
1212: -- reject price diff level records
1213: UPDATE po_price_diff_interface
1214: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1215: processing_id = -PO_PDOI_PARAMS.g_processing_id
1216: WHERE interface_header_id = p_intf_header_id
1217: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1218: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1219: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line 1217: AND processing_id = PO_PDOI_PARAMS.g_processing_id

1213: UPDATE po_price_diff_interface
1214: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1215: processing_id = -PO_PDOI_PARAMS.g_processing_id
1216: WHERE interface_header_id = p_intf_header_id
1217: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1218: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1219: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;
1220:
1221: d_position := 50;

Line 1226: processing_id = -PO_PDOI_PARAMS.g_processing_id

1222:
1223: -- reject attr level records
1224: UPDATE po_attr_values_interface
1225: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1226: processing_id = -PO_PDOI_PARAMS.g_processing_id
1227: WHERE interface_header_id = p_intf_header_id
1228: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1229: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1230: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line 1228: AND processing_id = PO_PDOI_PARAMS.g_processing_id

1224: UPDATE po_attr_values_interface
1225: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1226: processing_id = -PO_PDOI_PARAMS.g_processing_id
1227: WHERE interface_header_id = p_intf_header_id
1228: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1229: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1230: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;
1231:
1232: d_position := 60;

Line 1235: processing_id = -PO_PDOI_PARAMS.g_processing_id

1231:
1232: d_position := 60;
1233: UPDATE po_attr_values_tlp_interface
1234: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1235: processing_id = -PO_PDOI_PARAMS.g_processing_id
1236: WHERE interface_header_id = p_intf_header_id
1237: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1238: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1239: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line 1237: AND processing_id = PO_PDOI_PARAMS.g_processing_id

1233: UPDATE po_attr_values_tlp_interface
1234: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
1235: processing_id = -PO_PDOI_PARAMS.g_processing_id
1236: WHERE interface_header_id = p_intf_header_id
1237: AND processing_id = PO_PDOI_PARAMS.g_processing_id
1238: AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
1239: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;
1240:
1241: IF (PO_LOG.d_proc) THEN