DBA Data[Home] [Help]

APPS.PO_VALIDATIONS dependencies on PO_VALIDATION_RESULTS_GT

Line 1038: DELETE FROM PO_VALIDATION_RESULTS_GT

1034: IF PO_LOG.d_proc THEN
1035: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
1036: END IF;
1037:
1038: DELETE FROM PO_VALIDATION_RESULTS_GT
1039: WHERE result_set_id = p_result_set_id
1040: ;
1041:
1042: IF PO_LOG.d_proc THEN

Line 1175: INSERT INTO PO_VALIDATION_RESULTS_GT

1171:
1172: d_position := 1;
1173:
1174: FORALL i IN 1 .. p_result_set_id_tbl.COUNT
1175: INSERT INTO PO_VALIDATION_RESULTS_GT
1176: ( result_set_id
1177: , result_type
1178: , entity_type
1179: , entity_id

Line 1270: UPDATE PO_VALIDATION_RESULTS_GT

1266: END IF;
1267:
1268: -- Fix the result_set_id, message_application, and message_name.
1269:
1270: UPDATE PO_VALIDATION_RESULTS_GT
1271: SET
1272: result_set_id = p_new_result_set_id
1273: WHERE
1274: result_set_id = p_old_result_set_id

Line 1386: PO_VALIDATION_RESULTS_GT

1382: , l_token5_value_tbl
1383: , l_token6_name_tbl
1384: , l_token6_value_tbl
1385: FROM
1386: PO_VALIDATION_RESULTS_GT
1387: WHERE
1388: result_set_id = p_result_set_id
1389: ;
1390:

Line 5658: FROM PO_VALIDATION_RESULTS_GT VR

5654: BEGIN
5655: IF PO_LOG.d_stmt THEN
5656: SELECT VR.rowid
5657: BULK COLLECT INTO l_rowid_tbl
5658: FROM PO_VALIDATION_RESULTS_GT VR
5659: WHERE VR.result_set_id = p_result_set_id
5660: ;
5661: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);
5662: END IF;

Line 5661: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);

5657: BULK COLLECT INTO l_rowid_tbl
5658: FROM PO_VALIDATION_RESULTS_GT VR
5659: WHERE VR.result_set_id = p_result_set_id
5660: ;
5661: PO_LOG.stmt_table(p_module_base,p_position,'PO_VALIDATION_RESULTS_GT',l_rowid_tbl);
5662: END IF;
5663: END log_validation_results_gt;
5664:
5665: