DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_TIMING_UTL

Line 99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);

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

Line 124: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);

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;

Line 172: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);

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:

Line 246: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);

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;

Line 386: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);

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

Line 418: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);

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;

Line 1141: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);

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;

Line 1463: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);

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;

Line 1517: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);

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 =

Line 1564: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);

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;

Line 1612: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);

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

Line 1620: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);

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;

Line 1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);

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

Line 1676: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);

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;

Line 1742: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);

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

Line 1794: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);

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;

Line 1860: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);

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

Line 1916: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);

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;