49: p_result_set_id IN NUMBER
50: )
51: RETURN PO_VALIDATION_RESULTS_TYPE
52: IS
53: d_mod CONSTANT VARCHAR2(100) := PO_LOG.get_package_base('PO_VALIDATION_RESULTS_TYPE.GET_RESULT_SET_FROM_GT');
54: d_position NUMBER := 0;
55:
56: x_results PO_VALIDATION_RESULTS_TYPE;
57: BEGIN
55:
56: x_results PO_VALIDATION_RESULTS_TYPE;
57: BEGIN
58:
59: IF PO_LOG.d_proc THEN
60: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
61: END IF;
62:
63: d_position := 1;
56: x_results PO_VALIDATION_RESULTS_TYPE;
57: BEGIN
58:
59: IF PO_LOG.d_proc THEN
60: PO_LOG.proc_begin(d_mod,'p_result_set_id',p_result_set_id);
61: END IF;
62:
63: d_position := 1;
64:
115: WHERE
116: vr.result_set_id = p_result_set_id
117: ;
118:
119: IF PO_LOG.d_proc THEN
120: PO_LOG.log(PO_LOG.c_PROC_RETURN,d_mod,NULL,'x_results',x_results);
121: END IF;
122: RETURN x_results;
123:
116: vr.result_set_id = p_result_set_id
117: ;
118:
119: IF PO_LOG.d_proc THEN
120: PO_LOG.log(PO_LOG.c_PROC_RETURN,d_mod,NULL,'x_results',x_results);
121: END IF;
122: RETURN x_results;
123:
124: EXCEPTION
122: RETURN x_results;
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF PO_LOG.d_exc THEN
127: PO_LOG.exc(d_mod,d_position,NULL);
128: END IF;
129: RAISE;
130:
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF PO_LOG.d_exc THEN
127: PO_LOG.exc(d_mod,d_position,NULL);
128: END IF;
129: RAISE;
130:
131: END get_result_set_from_gt;