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_MOVE_TO_DRAFT_TABS_PVT dependencies on FND_API

Line 205: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

201: -- bug 6743283 added a condition to check the action, so that only for update
202: -- we made the line notified if call comes from catalog admin.
203: FOR i IN 1..x_lines.rec_count
204: LOOP
205: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
206: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE AND
207: x_lines.action_tbl(i) = 'UPDATE') THEN
208: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
209: END IF;

Line 206: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE AND

202: -- we made the line notified if call comes from catalog admin.
203: FOR i IN 1..x_lines.rec_count
204: LOOP
205: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
206: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE AND
207: x_lines.action_tbl(i) = 'UPDATE') THEN
208: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
209: END IF;
210: END LOOP;

Line 213: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;

209: END IF;
210: END LOOP;
211:
212: -- set status on header level for notified lines
213: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(1)).has_lines_to_notify := FND_API.g_TRUE;
214: ELSE
215: d_position := 30;
216:
217: -- populate value of has_lines_updated in g_doc_info for each document

Line 220: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

216:
217: -- populate value of has_lines_updated in g_doc_info for each document
218: FOR i IN 1..x_lines.rec_count
219: LOOP
220: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
221: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
222: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
223: END IF;
224: END LOOP;

Line 221: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

217: -- populate value of has_lines_updated in g_doc_info for each document
218: FOR i IN 1..x_lines.rec_count
219: LOOP
220: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
221: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
222: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
223: END IF;
224: END LOOP;
225:

Line 381: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

377: FOR i IN 1..x_lines.rec_count
378: LOOP
379: l_po_line_id := x_lines.po_line_id_tbl(i);
380:
381: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
382: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
383: IF (l_line_ref_tbl.EXISTS(l_po_line_id) = FALSE) THEN
384: l_count := l_count + 1;
385: l_po_line_id_tbl.EXTEND;

Line 382: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

378: LOOP
379: l_po_line_id := x_lines.po_line_id_tbl(i);
380:
381: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
382: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
383: IF (l_line_ref_tbl.EXISTS(l_po_line_id) = FALSE) THEN
384: l_count := l_count + 1;
385: l_po_line_id_tbl.EXTEND;
386: l_draft_id_tbl.EXTEND;

Line 542: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

538:
539: -- bug5107324
540: -- Only process lines that do not contain error or destined to get
541: -- rejected.
542: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
543: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
544:
545: IF (PO_LOG.d_stmt) THEN
546: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));

Line 543: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

539: -- bug5107324
540: -- Only process lines that do not contain error or destined to get
541: -- rejected.
542: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
543: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
544:
545: IF (PO_LOG.d_stmt) THEN
546: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
547: PO_LOG.stmt(d_module, d_position, 'reference',

Line 597: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

593: FOR i IN 1..x_lines.rec_count
594: LOOP
595: d_position := 60;
596:
597: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
598: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
599: IF (PO_LOG.d_stmt) THEN
600: PO_LOG.stmt(d_module, d_position, 'update line on index', i);
601: END IF;

Line 598: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

594: LOOP
595: d_position := 60;
596:
597: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
598: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
599: IF (PO_LOG.d_stmt) THEN
600: PO_LOG.stmt(d_module, d_position, 'update line on index', i);
601: END IF;
602:

Line 604: l_uom_different := FND_API.g_FALSE;

600: PO_LOG.stmt(d_module, d_position, 'update line on index', i);
601: END IF;
602:
603: -- reset variables
604: l_uom_different := FND_API.g_FALSE;
605: l_exceed_tolerance := FND_API.g_FALSE;
606:
607: -- get index reference in existing value tables
608: l_index := l_line_ref_tbl(x_lines.po_line_id_tbl(i));

Line 605: l_exceed_tolerance := FND_API.g_FALSE;

601: END IF;
602:
603: -- reset variables
604: l_uom_different := FND_API.g_FALSE;
605: l_exceed_tolerance := FND_API.g_FALSE;
606:
607: -- get index reference in existing value tables
608: l_index := l_line_ref_tbl(x_lines.po_line_id_tbl(i));
609:

Line 621: l_uom_different := FND_API.g_TRUE;

617: -- check whether uom has been changed
618: IF (x_lines.unit_of_measure_tbl(i) IS NOT NULL AND
619: x_lines.order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND
620: x_lines.unit_of_measure_tbl(i) <> l_unit_of_measure_tbl(l_index)) THEN
621: l_uom_different := FND_API.g_TRUE;
622:
623: IF (PO_LOG.d_stmt) THEN
624: PO_LOG.stmt(d_module, d_position, 'uom_different',
625: l_uom_different);

Line 690: l_exceed_tolerance := FND_API.G_TRUE;

686: IF (PO_LOG.d_stmt) THEN
687: PO_LOG.stmt(d_module, d_position, 'orig_intf_line_id exists');
688: END IF;
689:
690: l_exceed_tolerance := FND_API.G_TRUE;
691: x_lines.parent_interface_line_id_tbl(i) := l_orig_intf_line_id_tbl(l_index);
692:
693: -- check unit price
694: ELSIF (x_lines.create_line_loc_tbl(i) = FND_API.g_FALSE AND

Line 694: ELSIF (x_lines.create_line_loc_tbl(i) = FND_API.g_FALSE AND

690: l_exceed_tolerance := FND_API.G_TRUE;
691: x_lines.parent_interface_line_id_tbl(i) := l_orig_intf_line_id_tbl(l_index);
692:
693: -- check unit price
694: ELSIF (x_lines.create_line_loc_tbl(i) = FND_API.g_FALSE AND
695: x_lines.unit_price_tbl(i) IS NOT NULL AND
696: x_lines.unit_price_tbl(i) <> NVL(l_unit_price_tbl(l_index), -1)) THEN
697:
698: IF (x_lines.unit_price_tbl(i) <> PO_PDOI_CONSTANTS.g_NULLIFY_NUM) THEN

Line 721: IF (l_uom_different = FND_API.g_FALSE AND

717: NVL(x_lines.hd_global_agreement_flag_tbl(i), 'N') = 'Y')) THEN
718:
719: d_position := 110;
720: -- only perform tolerance checking when uom is not changed
721: IF (l_uom_different = FND_API.g_FALSE AND
722: x_lines.unit_price_tbl(i) <> l_unit_price_tbl(l_index)) THEN
723: -- check whether new price exceeds the tolerance
724: l_exceed_tolerance :=
725: PO_PDOI_PRICE_TOLERANCE_PVT.exceed_tolerance_check

Line 746: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN

742: d_position := 120;
743:
744: -- update unit_price, base_unit_price and retroactive_date
745: -- if price does not exceed tolerance
746: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
747: -- When we update an existing blanket with a new unit_price,
748: -- retroactive_date in po_lines must be updated with the timestamp.
749: -- This has to be done for non-cumulative blanket lines only.
750: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

Line 780: IF (l_exceed_tolerance = FND_API.g_TRUE) THEN

776: d_position := 150;
777:
778: -- bug5149827
779: -- Move the handling of exceed tolerance = T to here
780: IF (l_exceed_tolerance = FND_API.g_TRUE) THEN
781:
782: IF (PO_LOG.d_stmt) THEN
783: PO_LOG.stmt(d_module, d_position, 'set line to be notified', i);
784: PO_LOG.stmt(d_module, d_position, 'notified intf header id',

Line 792: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_to_notify := FND_API.g_TRUE;

788: -- set process_code to be 'NOTIFIED' for this line;
789: x_lines.process_code_tbl(i) := PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED;
790:
791: -- set status on header level for notified lines
792: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_to_notify := FND_API.g_TRUE;
793:
794: END IF; -- l_exceed_tolerance = true
795:
796: -- check check expiration_date

Line 798: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN

794: END IF; -- l_exceed_tolerance = true
795:
796: -- check check expiration_date
797: -- do the following update only when price does not exceed tolerance
798: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
799: -- If the new value is '#DEL', we null out the expiration_date
800: IF (PO_PDOI_PARAMS.g_request.document_type =
801: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND
802: x_lines.expiration_date_tbl(i) IS NOT NULL) THEN

Line 958: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN

954:
955: d_position := 250;
956:
957: -- set has_lines_updated flag in g_docs_info
958: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
959: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
960:
961: IF (PO_LOG.d_stmt) THEN
962: PO_LOG.stmt(d_module, d_position, 'line updated for document',

Line 967: END IF; -- IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE)

963: x_lines.intf_header_id_tbl(i));
964: END IF;
965: END IF;
966:
967: END IF; -- IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE)
968: END LOOP;
969:
970: d_position := 260;
971:

Line 989: p_init_msg_list => FND_API.g_TRUE,

985: LOOP
986: EGO_ITEM_PUB.Process_Item
987: (
988: p_api_version => 1.0,
989: p_init_msg_list => FND_API.g_TRUE,
990: p_commit => FND_API.g_TRUE,
991: p_Transaction_Type => 'UPDATE',
992: p_Inventory_Item_Id => x_lines.item_id_tbl(l_index),
993: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,

Line 990: p_commit => FND_API.g_TRUE,

986: EGO_ITEM_PUB.Process_Item
987: (
988: p_api_version => 1.0,
989: p_init_msg_list => FND_API.g_TRUE,
990: p_commit => FND_API.g_TRUE,
991: p_Transaction_Type => 'UPDATE',
992: p_Inventory_Item_Id => x_lines.item_id_tbl(l_index),
993: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
994: p_description => NVL(x_lines.item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),

Line 1010: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1006: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1007: l_return_status);
1008: END IF;
1009:
1010: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011: -- error handling
1012: Error_Handler.GET_MESSAGE_LIST
1013: (
1014: x_message_list => l_message_list

Line 1048: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;

1044: p_column_value => NULL
1045: );
1046: END LOOP;
1047:
1048: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;
1049:
1050: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1051:
1052: IF (PO_LOG.d_proc) THEN

Line 1341: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;

1337: p_line_locs.draft_id_tbl(i),
1338: 'Y'
1339: FROM po_line_locations
1340: WHERE po_line_id = p_line_locs.ln_po_line_id_tbl(i)
1341: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
1342:
1343: d_position := 20;
1344:
1345: DELETE FROM po_session_gt

Line 1589: WHERE p_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;

1585: p_attr_values.ln_po_line_id_tbl(i),
1586: p_attr_values.ln_ip_category_id_tbl(i),
1587: p_attr_values.ln_item_id_tbl(i)
1588: FROM DUAL
1589: WHERE p_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;
1590:
1591: d_position := 20;
1592:
1593: -- merge values from interface tables to draft tables

Line 1709: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;

1705: p_attr_values_tlp.ln_ip_category_id_tbl(i),
1706: p_attr_values_tlp.ln_item_id_tbl(i),
1707: p_attr_values_tlp.ln_item_desc_tbl(i)
1708: FROM DUAL
1709: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
1710:
1711: d_position := 20;
1712:
1713: -- insert or update attribute values rows into po_attribute_values_draft

Line 1777: IF (p_headers.error_flag_tbl(i) = FND_API.G_FALSE) THEN

1773:
1774: IF (PO_LOG.d_stmt) THEN
1775: FOR i IN 1..p_headers.rec_count
1776: LOOP
1777: IF (p_headers.error_flag_tbl(i) = FND_API.G_FALSE) THEN
1778: l_valid_intf_header_id_tbl.EXTEND(1);
1779: l_count := l_valid_intf_header_id_tbl.COUNT;
1780: l_valid_intf_header_id_tbl(l_count) :=
1781: p_headers.intf_header_id_tbl(i);

Line 2008: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;

2004: p_headers.created_language_tbl(i),
2005: p_headers.tax_attribute_update_code_tbl(i)
2006: FROM po_headers_interface
2007: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2008: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;
2009:
2010: IF (PO_LOG.d_proc) THEN
2011: PO_LOG.proc_end (d_module);
2012: END IF;

Line 2094: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE

2090: p_headers.creation_date_tbl(i),
2091: p_headers.created_by_tbl(i)
2092: FROM po_headers_interface
2093: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2094: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2095: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2096: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';
2097: END IF;
2098:

Line 2217: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE

2213: FND_GLOBAL.prog_appl_id,
2214: FND_GLOBAL.conc_program_id,
2215: sysdate
2216: FROM DUAL
2217: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2218: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';
2219: END IF;
2220:
2221: IF (PO_LOG.d_proc) THEN

Line 2282: IF (p_dists.error_flag_tbl(i) = FND_API.g_FALSE) THEN

2278:
2279: IF (PO_LOG.d_stmt) THEN
2280: FOR i IN 1..p_dists.rec_count
2281: LOOP
2282: IF (p_dists.error_flag_tbl(i) = FND_API.g_FALSE) THEN
2283: l_valid_intf_dist_id_tbl.EXTEND(1);
2284: l_count := l_count + 1;
2285: l_valid_intf_dist_id_tbl(l_count) :=
2286: p_dists.intf_dist_id_tbl(i);

Line 2482: AND p_dists.error_flag_tbl(i) = FND_API.g_FALSE;

2478: NULL, -- amount_to_encumber
2479: p_dists.tax_attribute_update_code_tbl(i)
2480: FROM po_distributions_interface
2481: WHERE interface_distribution_id = p_dists.intf_dist_id_tbl(i)
2482: AND p_dists.error_flag_tbl(i) = FND_API.g_FALSE;
2483:
2484: IF (PO_LOG.d_proc) THEN
2485: PO_LOG.proc_end (d_module);
2486: END IF;

Line 2538: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

2534: IF (PO_LOG.d_stmt) THEN
2535:
2536: FOR i IN 1..p_lines.rec_count
2537: LOOP
2538: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
2539: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2540: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2541: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2542: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));

Line 2539: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN

2535:
2536: FOR i IN 1..p_lines.rec_count
2537: LOOP
2538: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
2539: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2540: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2541: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2542: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2543: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));

Line 2759: AND p_lines.error_flag_tbl(i) = FND_API.g_FALSE

2755: p_lines.intf_line_id_tbl(i),
2756: NULL) -- bug5149827
2757: FROM po_lines_interface
2758: WHERE interface_line_id = p_lines.intf_line_id_tbl(i)
2759: AND p_lines.error_flag_tbl(i) = FND_API.g_FALSE
2760: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
2761:
2762: IF (PO_LOG.d_proc) THEN
2763: PO_LOG.proc_end (d_module);

Line 2760: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;

2756: NULL) -- bug5149827
2757: FROM po_lines_interface
2758: WHERE interface_line_id = p_lines.intf_line_id_tbl(i)
2759: AND p_lines.error_flag_tbl(i) = FND_API.g_FALSE
2760: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
2761:
2762: IF (PO_LOG.d_proc) THEN
2763: PO_LOG.proc_end (d_module);
2764: END IF;

Line 2815: IF (p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE) THEN

2811:
2812: IF (PO_LOG.d_stmt) THEN
2813: FOR i IN 1..p_line_locs.rec_count
2814: LOOP
2815: IF (p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE) THEN
2816: l_valid_intf_loc_id_tbl.EXTEND(1);
2817: l_count := l_count + 1;
2818: l_valid_intf_loc_id_tbl(l_count) :=
2819: p_line_locs.intf_line_loc_id_tbl(i);

Line 3041: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;

3037: p_line_locs.value_basis_tbl(i),
3038: p_line_locs.matching_basis_tbl(i)
3039: FROM po_line_locations_interface
3040: WHERE interface_line_location_id = p_line_locs.intf_line_loc_id_tbl(i)
3041: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
3042:
3043: IF (PO_LOG.d_proc) THEN
3044: PO_LOG.proc_end (d_module);
3045: END IF;

Line 3096: IF (p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE) THEN

3092:
3093: IF (PO_LOG.d_stmt) THEN
3094: FOR i IN 1..p_price_diffs.rec_count
3095: LOOP
3096: IF (p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE) THEN
3097: l_valid_intf_diff_id_tbl.EXTEND(1);
3098: l_count := l_count + 1;
3099: l_valid_intf_diff_id_tbl(l_count) :=
3100: p_price_diffs.intf_price_diff_id_tbl(i);

Line 3149: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;

3145: NVL(creation_date, sysdate),
3146: NVL(created_by, FND_GLOBAL.user_id)
3147: FROM po_price_diff_interface
3148: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)
3149: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
3150:
3151: IF (PO_LOG.d_proc) THEN
3152: PO_LOG.proc_end (d_module);
3153: END IF;