[Home] [Help]
1317: IF PO_LOG.d_proc THEN
1318: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1319: END IF;
1320:
1321: DELETE FROM PO_VALIDATION_RESULTS_GT
1322: WHERE result_set_id = p_result_set_id
1323: ;
1324:
1325: IF PO_LOG.d_proc THEN
1454:
1455: d_position := 1;
1456:
1457: FORALL i IN 1 .. p_result_set_id_tbl.COUNT
1458: INSERT INTO PO_VALIDATION_RESULTS_GT
1459: ( result_set_id
1460: , result_type
1461: , entity_type
1462: , entity_id
1549: END IF;
1550:
1551: -- Fix the result_set_id, message_application, and message_name.
1552:
1553: UPDATE PO_VALIDATION_RESULTS_GT
1554: SET
1555: result_set_id = p_new_result_set_id
1556: WHERE
1557: result_set_id = p_old_result_set_id
1665: , l_token5_value_tbl
1666: , l_token6_name_tbl
1667: , l_token6_value_tbl
1668: FROM
1669: PO_VALIDATION_RESULTS_GT
1670: WHERE
1671: result_set_id = p_result_set_id
1672: ;
1673:
6957: BEGIN
6958: IF PO_LOG.d_stmt THEN
6959: SELECT VR.rowid
6960: BULK COLLECT INTO l_rowid_tbl
6961: FROM PO_VALIDATION_RESULTS_GT VR
6962: WHERE VR.result_set_id = p_result_set_id
6963: ;
6964: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);
6965: END IF;
6960: BULK COLLECT INTO l_rowid_tbl
6961: FROM PO_VALIDATION_RESULTS_GT VR
6962: WHERE VR.result_set_id = p_result_set_id
6963: ;
6964: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);
6965: END IF;
6966: END log_validation_results_gt;
6967:
6968: --