APPS.QA_VALIDATION_API dependencies on QA_RESULTS

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

3492: -- for example context elements for transactions.
3493: --
3494: -- However, if this element is a keyflex or normalized
3495: -- then we have to go through validation to determine
3496: -- the corresponding id to put in qa_results.
3497:
3498: -- Bug 3381173. Validation should be performed even if the
3499: -- element is a primitive one. Hence adding an OR condn below.
3500: -- This is also necessary because of the dependent elements.

Line 3732: l_value qa_results.comment1%TYPE;

3728: -- bug 3256981
3729: -- the problem was happening due to value being initialized to have
3730: -- character1 length. For comment1 to comment5, it can be as long as
3731: -- 2000 chars. So we need to have long enough field.
3732: l_value qa_results.comment1%TYPE;
3733: c VARCHAR2(10);
3734: separator CONSTANT VARCHAR2(1) := '@';
3735:
3736: BEGIN

Line 3775: x_value qa_results.comment1%TYPE;

3771: -- bug 3256981
3772: -- the problem was happening due t value being initialized to have
3773: -- character1 length. For comment1 to comment5, it can be as long as
3774: -- 2000 chars. So we need to have long enough field.
3775: x_value qa_results.comment1%TYPE;
3776:
3777: BEGIN
3778: n := length(p_result);
3779: p := 1;

Line 3833: l_value qa_results.character1%TYPE;

3829: n INTEGER;
3830: p INTEGER; -- starting string position
3831: q INTEGER; -- ending string position
3832: l_char_id NUMBER;
3833: l_value qa_results.character1%TYPE;
3834:
3835: BEGIN
3836:
3837: IF p_result IS NULL THEN