95: IF (PO_LOG.d_proc) THEN
96: PO_LOG.proc_begin(d_module);
97: END IF;
98:
99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
100:
101: -- insert records into po_headers_draft_all table
102: insert_po_headers_draft_all
103: (
120: (
121: p_headers => p_headers
122: );
123:
124: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_end (d_module);
128: END IF;
168: IF (PO_LOG.d_proc) THEN
169: PO_LOG.proc_begin(d_module);
170: END IF;
171:
172: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
173:
174: d_position := 10;
175:
176: -- set all lines to notified if:
242: (
243: p_lines => x_lines
244: );
245:
246: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
247:
248: IF (PO_LOG.d_proc) THEN
249: PO_LOG.proc_end (d_module);
250: END IF;
382: IF (PO_LOG.d_proc) THEN
383: PO_LOG.proc_begin(d_module);
384: END IF;
385:
386: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
387:
388: -- get ids of po lines that are going to be updated;
389: -- the id list will only contain distinct values
390: FOR i IN 1..x_lines.rec_count
414: l_num_tbl.COUNT);
415: END IF;
416:
417: IF (l_num_tbl.COUNT = 0) THEN
418: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
419:
420: IF (PO_LOG.d_proc) THEN
421: PO_LOG.proc_end (d_module);
422: END IF;
1137: END LOOP;
1138:
1139: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;
1140:
1141: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end (d_module);
1145: END IF;
1459: p_po_line_id_tbl => x_lines.po_line_id_tbl,
1460: p_draft_id_tbl => x_lines.draft_id_tbl
1461: );
1462:
1463: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1464:
1465: IF (PO_LOG.d_proc) THEN
1466: PO_LOG.proc_end (d_module);
1467: END IF;
1513: IF (PO_LOG.d_proc) THEN
1514: PO_LOG.proc_begin(d_module);
1515: END IF;
1516:
1517: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1518:
1519: /*
1520: -- delete existing price breaks for Quotation if new price breaks are added
1521: IF (PO_PDOI_PARAMS.g_request.document_type =
1560: (
1561: p_line_locs => p_line_locs
1562: );
1563:
1564: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1565:
1566: IF (PO_LOG.d_proc) THEN
1567: PO_LOG.proc_end (d_module);
1568: END IF;
1608: IF (PO_LOG.d_proc) THEN
1609: PO_LOG.proc_begin(d_module);
1610: END IF;
1611:
1612: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1613:
1614: -- insert distribution rows into po_distributions_draft_all
1615: insert_po_dists_draft_all
1616: (
1616: (
1617: p_dists => p_dists
1618: );
1619:
1620: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1621:
1622: IF (PO_LOG.d_proc) THEN
1623: PO_LOG.proc_end (d_module);
1624: END IF;
1664: IF (PO_LOG.d_proc) THEN
1665: PO_LOG.proc_begin(d_module);
1666: END IF;
1667:
1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1669:
1670: -- insert price differential rows into po_price_diff_draft
1671: insert_po_price_diff_draft
1672: (
1672: (
1673: p_price_diffs => p_price_diffs
1674: );
1675:
1676: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1677:
1678: IF (PO_LOG.d_proc) THEN
1679: PO_LOG.proc_end (d_module);
1680: END IF;
1738: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);
1739: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1740: END IF;
1741:
1742: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1743:
1744: -- sync rows from txn tables to draft tables for update
1745: l_delete_flag_tbl.EXTEND(p_sync_attr_id_tbl.COUNT);
1746: FOR i IN 1..p_sync_attr_id_tbl.COUNT
1790: p_key => l_key,
1791: p_attr_values => p_attr_values
1792: );
1793:
1794: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1795:
1796: IF (PO_LOG.d_proc) THEN
1797: PO_LOG.proc_end (d_module);
1798: END IF;
1856: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);
1857: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1858: END IF;
1859:
1860: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1861:
1862: -- sync rows from txn tables to draft tables for update
1863: l_delete_flag_tbl.EXTEND(p_sync_attr_tlp_id_tbl.COUNT);
1864: FOR i IN 1..p_sync_attr_tlp_id_tbl.COUNT
1912: p_key => l_key,
1913: p_attr_values_tlp => p_attr_values_tlp
1914: );
1915:
1916: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1917:
1918: IF (PO_LOG.d_proc) THEN
1919: PO_LOG.proc_end (d_module);
1920: END IF;