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 243: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);

239: (
240: p_lines => x_lines
241: );
242:
243: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
244:
245: IF (PO_LOG.d_proc) THEN
246: PO_LOG.proc_end (d_module);
247: END IF;

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

369: IF (PO_LOG.d_proc) THEN
370: PO_LOG.proc_begin(d_module);
371: END IF;
372:
373: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
374:
375: -- get ids of po lines that are going to be updated;
376: -- the id list will only contain distinct values
377: FOR i IN 1..x_lines.rec_count

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

401: l_num_tbl.COUNT);
402: END IF;
403:
404: IF (l_num_tbl.COUNT = 0) THEN
405: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
406:
407: IF (PO_LOG.d_proc) THEN
408: PO_LOG.proc_end (d_module);
409: END IF;

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

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
1053: PO_LOG.proc_end (d_module);
1054: END IF;

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

1265: p_po_line_id_tbl => x_lines.po_line_id_tbl,
1266: p_draft_id_tbl => x_lines.draft_id_tbl
1267: );
1268:
1269: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1270:
1271: IF (PO_LOG.d_proc) THEN
1272: PO_LOG.proc_end (d_module);
1273: END IF;

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

1319: IF (PO_LOG.d_proc) THEN
1320: PO_LOG.proc_begin(d_module);
1321: END IF;
1322:
1323: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1324:
1325: /*
1326: -- delete existing price breaks for Quotation if new price breaks are added
1327: IF (PO_PDOI_PARAMS.g_request.document_type =

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

1366: (
1367: p_line_locs => p_line_locs
1368: );
1369:
1370: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1371:
1372: IF (PO_LOG.d_proc) THEN
1373: PO_LOG.proc_end (d_module);
1374: END IF;

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

1414: IF (PO_LOG.d_proc) THEN
1415: PO_LOG.proc_begin(d_module);
1416: END IF;
1417:
1418: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1419:
1420: -- insert distribution rows into po_distributions_draft_all
1421: insert_po_dists_draft_all
1422: (

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

1422: (
1423: p_dists => p_dists
1424: );
1425:
1426: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1427:
1428: IF (PO_LOG.d_proc) THEN
1429: PO_LOG.proc_end (d_module);
1430: END IF;

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

1470: IF (PO_LOG.d_proc) THEN
1471: PO_LOG.proc_begin(d_module);
1472: END IF;
1473:
1474: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1475:
1476: -- insert price differential rows into po_price_diff_draft
1477: insert_po_price_diff_draft
1478: (

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

1478: (
1479: p_price_diffs => p_price_diffs
1480: );
1481:
1482: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1483:
1484: IF (PO_LOG.d_proc) THEN
1485: PO_LOG.proc_end (d_module);
1486: END IF;

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

1544: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);
1545: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1546: END IF;
1547:
1548: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1549:
1550: -- sync rows from txn tables to draft tables for update
1551: l_delete_flag_tbl.EXTEND(p_sync_attr_id_tbl.COUNT);
1552: FOR i IN 1..p_sync_attr_id_tbl.COUNT

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

1596: p_key => l_key,
1597: p_attr_values => p_attr_values
1598: );
1599:
1600: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1601:
1602: IF (PO_LOG.d_proc) THEN
1603: PO_LOG.proc_end (d_module);
1604: END IF;

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

1662: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);
1663: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1664: END IF;
1665:
1666: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1667:
1668: -- sync rows from txn tables to draft tables for update
1669: l_delete_flag_tbl.EXTEND(p_sync_attr_tlp_id_tbl.COUNT);
1670: FOR i IN 1..p_sync_attr_tlp_id_tbl.COUNT

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

1716: p_key => l_key,
1717: p_attr_values_tlp => p_attr_values_tlp
1718: );
1719:
1720: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1721:
1722: IF (PO_LOG.d_proc) THEN
1723: PO_LOG.proc_end (d_module);
1724: END IF;