APPS.QA_VALIDATION_API dependencies on QA_RESULTS

Line 3420: -- the corresponding id to put in qa_results.

3416: -- for example context elements for transactions.
3417: --
3418: -- However, if this element is a keyflex or normalized
3419: -- then we have to go through validation to determine
3420: -- the corresponding id to put in qa_results.
3421:
3422: -- Bug 3381173. Validation should be performed even if the
3423: -- element is a primitive one. Hence adding an OR condn below.
3424: -- This is also necessary because of the dependent elements.

Line 3656: l_value qa_results.comment1%TYPE;

3652: -- bug 3256981
3653: -- the problem was happening due to value being initialized to have
3654: -- character1 length. For comment1 to comment5, it can be as long as
3655: -- 2000 chars. So we need to have long enough field.
3656: l_value qa_results.comment1%TYPE;
3657: c VARCHAR2(10);
3658: separator CONSTANT VARCHAR2(1) := '@';
3659:
3660: BEGIN

Line 3699: x_value qa_results.comment1%TYPE;

3695: -- bug 3256981
3696: -- the problem was happening due t value being initialized to have
3697: -- character1 length. For comment1 to comment5, it can be as long as
3698: -- 2000 chars. So we need to have long enough field.
3699: x_value qa_results.comment1%TYPE;
3700:
3701: BEGIN
3702: n := length(p_result);
3703: p := 1;

Line 3744: l_value qa_results.character1%TYPE;

3740: n INTEGER;
3741: p INTEGER; -- starting string position
3742: q INTEGER; -- ending string position
3743: l_char_id NUMBER;
3744: l_value qa_results.character1%TYPE;
3745:
3746: BEGIN
3747:
3748: IF p_result IS NULL THEN