DBA Data[Home] [Help]

APPS.QA_VALIDATION_API dependencies on QA_VALIDATION_API

Line 1: PACKAGE BODY qa_validation_api AS

1: PACKAGE BODY qa_validation_api AS
2: /* $Header: qltvalb.plb 120.30.12010000.2 2008/11/18 07:33:37 ntungare ship $ */
3:
4: g_dependency_matrix DependencyArray;
5:

Line 3687: RETURN qa_validation_api.ElementsArray IS

3683: END parse_value;
3684:
3685:
3686: FUNCTION result_to_array(p_result IN VARCHAR2)
3687: RETURN qa_validation_api.ElementsArray IS
3688:
3689: elements qa_validation_api.ElementsArray;
3690: n INTEGER;
3691: p INTEGER; -- starting string position

Line 3689: elements qa_validation_api.ElementsArray;

3685:
3686: FUNCTION result_to_array(p_result IN VARCHAR2)
3687: RETURN qa_validation_api.ElementsArray IS
3688:
3689: elements qa_validation_api.ElementsArray;
3690: n INTEGER;
3691: p INTEGER; -- starting string position
3692: q INTEGER; -- ending string position
3693: x_char_id NUMBER;

Line 3737: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)

3733: -- bso Tue Sep 27 17:51:10 PDT 2005
3734: --
3735: FUNCTION id_to_array(
3736: p_result IN VARCHAR2,
3737: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)
3738: RETURN qa_validation_api.ElementsArray IS
3739:
3740: n INTEGER;
3741: p INTEGER; -- starting string position

Line 3738: RETURN qa_validation_api.ElementsArray IS

3734: --
3735: FUNCTION id_to_array(
3736: p_result IN VARCHAR2,
3737: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)
3738: RETURN qa_validation_api.ElementsArray IS
3739:
3740: n INTEGER;
3741: p INTEGER; -- starting string position
3742: q INTEGER; -- ending string position

Line 3767: qa_validation_api.id_derived;

3763: l_value := parse_value(p_result, n, q);
3764: x_elements(l_char_id).id := l_value;
3765: x_elements(l_char_id).validation_flag :=
3766: nvl(x_elements(l_char_id).validation_flag, 'invalid') ||
3767: qa_validation_api.id_derived;
3768: p := q;
3769: END LOOP;
3770:
3771: RETURN x_elements;

Line 3776: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray) IS

3772: END id_to_array;
3773:
3774:
3775: PROCEDURE set_validation_flag(
3776: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray) IS
3777: i INTEGER;
3778: BEGIN
3779: i := x_elements.FIRST;
3780: WHILE i <= x_elements.LAST LOOP

Line 3783: qa_validation_api.action_fired;

3779: i := x_elements.FIRST;
3780: WHILE i <= x_elements.LAST LOOP
3781: x_elements(i).validation_flag :=
3782: x_elements(i).validation_flag ||
3783: qa_validation_api.action_fired;
3784:
3785: IF i = qa_ss_const.transaction_type THEN
3786: x_elements(i).validation_flag :=
3787: x_elements(i).validation_flag ||

Line 3788: qa_validation_api.valid_element;

3784:
3785: IF i = qa_ss_const.transaction_type THEN
3786: x_elements(i).validation_flag :=
3787: x_elements(i).validation_flag ||
3788: qa_validation_api.valid_element;
3789: END IF;
3790:
3791: i := x_elements.NEXT(i);
3792: END LOOP;

Line 3817: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

3813: -- bso Sat Oct 1 15:05:35 PDT 2005
3814: --
3815:
3816: PROCEDURE set_validation_flag_txn(
3817: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
3818: p_plan_id NUMBER,
3819: p_transaction_number NUMBER,
3820: p_plan_transaction_id NUMBER) IS
3821:

Line 3854: qa_validation_api.valid_element;

3850: FOR c IN context LOOP
3851: IF x_elements.EXISTS(c.collection_trigger_id) THEN
3852: x_elements(c.collection_trigger_id).validation_flag :=
3853: x_elements(c.collection_trigger_id).validation_flag ||
3854: qa_validation_api.valid_element;
3855: END IF;
3856: END LOOP;
3857:
3858: --

Line 3864: qa_validation_api.valid_element;

3860: --
3861: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3862: x_elements(qa_ss_const.lot_number).validation_flag :=
3863: x_elements(qa_ss_const.lot_number).validation_flag ||
3864: qa_validation_api.valid_element;
3865: END IF;
3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3868: x_elements(qa_ss_const.serial_number).validation_flag :=

Line 3870: qa_validation_api.valid_element;

3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3868: x_elements(qa_ss_const.serial_number).validation_flag :=
3869: x_elements(qa_ss_const.serial_number).validation_flag ||
3870: qa_validation_api.valid_element;
3871: END IF;
3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3874: x_elements(qa_ss_const.transaction_type).validation_flag :=

Line 3876: qa_validation_api.valid_element;

3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3874: x_elements(qa_ss_const.transaction_type).validation_flag :=
3875: x_elements(qa_ss_const.transaction_type).validation_flag ||
3876: qa_validation_api.valid_element;
3877: END IF;
3878:
3879: --
3880: -- Step 3. If it is a background plan, set all elements

Line 3908: qa_validation_api.background_element;

3904: i := x_elements.FIRST;
3905: WHILE i <= x_elements.LAST LOOP
3906: x_elements(i).validation_flag :=
3907: x_elements(i).validation_flag ||
3908: qa_validation_api.background_element;
3909: i := x_elements.NEXT(i);
3910: END LOOP;
3911: END IF;
3912:

Line 4050: row_record QA_VALIDATION_API.RowRecord;

4046: dependent_elements OUT NOCOPY VARCHAR2,
4047: disable_enable_flag_list OUT NOCOPY VARCHAR2,
4048: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4049: AS
4050: row_record QA_VALIDATION_API.RowRecord;
4051: result_record QA_VALIDATION_API.ResultRecord;
4052: row_elements QA_VALIDATION_API.ElementsArray;
4053: error_array QA_VALIDATION_API.ErrorArray;
4054: errors_list QA_VALIDATION_API.ErrorArray;

Line 4051: result_record QA_VALIDATION_API.ResultRecord;

4047: disable_enable_flag_list OUT NOCOPY VARCHAR2,
4048: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4049: AS
4050: row_record QA_VALIDATION_API.RowRecord;
4051: result_record QA_VALIDATION_API.ResultRecord;
4052: row_elements QA_VALIDATION_API.ElementsArray;
4053: error_array QA_VALIDATION_API.ErrorArray;
4054: errors_list QA_VALIDATION_API.ErrorArray;
4055: cntr NUMBER;

Line 4052: row_elements QA_VALIDATION_API.ElementsArray;

4048: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4049: AS
4050: row_record QA_VALIDATION_API.RowRecord;
4051: result_record QA_VALIDATION_API.ResultRecord;
4052: row_elements QA_VALIDATION_API.ElementsArray;
4053: error_array QA_VALIDATION_API.ErrorArray;
4054: errors_list QA_VALIDATION_API.ErrorArray;
4055: cntr NUMBER;
4056: i NUMBER :=1 ;

Line 4053: error_array QA_VALIDATION_API.ErrorArray;

4049: AS
4050: row_record QA_VALIDATION_API.RowRecord;
4051: result_record QA_VALIDATION_API.ResultRecord;
4052: row_elements QA_VALIDATION_API.ElementsArray;
4053: error_array QA_VALIDATION_API.ErrorArray;
4054: errors_list QA_VALIDATION_API.ErrorArray;
4055: cntr NUMBER;
4056: i NUMBER :=1 ;
4057: message_str VARCHAR2(4000);

Line 4054: errors_list QA_VALIDATION_API.ErrorArray;

4050: row_record QA_VALIDATION_API.RowRecord;
4051: result_record QA_VALIDATION_API.ResultRecord;
4052: row_elements QA_VALIDATION_API.ElementsArray;
4053: error_array QA_VALIDATION_API.ErrorArray;
4054: errors_list QA_VALIDATION_API.ErrorArray;
4055: cntr NUMBER;
4056: i NUMBER :=1 ;
4057: message_str VARCHAR2(4000);
4058:

Line 4066: elements qa_validation_api.ElementsArray;

4062: dep_elements_list VARCHAR2(4000);
4063: dep_flag_list VARCHAR2(4000);
4064: dep_elements_status VARCHAR2(4000);
4065:
4066: elements qa_validation_api.ElementsArray;
4067:
4068: dependent_elements_arr QA_PARENT_CHILD_PKG.ChildPlanArray;
4069: dep_elements_status_arr QA_PARENT_CHILD_PKG.ChildPlanArray;
4070:

Line 4077: elements := qa_validation_api.result_to_array(result_string);

4073: BEGIN
4074: -- populate the record structures
4075: /*
4076: if result_string is not NULL THEN
4077: elements := qa_validation_api.result_to_array(result_string);
4078: elements := qa_validation_api.id_to_array(id_string, elements);
4079: end if;
4080: */
4081:

Line 4078: elements := qa_validation_api.id_to_array(id_string, elements);

4074: -- populate the record structures
4075: /*
4076: if result_string is not NULL THEN
4077: elements := qa_validation_api.result_to_array(result_string);
4078: elements := qa_validation_api.id_to_array(id_string, elements);
4079: end if;
4080: */
4081:
4082: row_elements(p_element_id).id := p_element_id;

Line 4117: error_array := QA_VALIDATION_API.validate_element(

4113: result_record.element_id := p_element_id;
4114:
4115: -- call the validate_element api to perform
4116: -- the element validation
4117: error_array := QA_VALIDATION_API.validate_element(
4118: row_elements => row_elements,
4119: row_record => row_record,
4120: element_id => p_element_id,
4121: org_id => p_org_id,

Line 4129: if error_array(cntr).error_code <> QA_VALIDATION_API.OK THEN

4125:
4126: -- build the error list array
4127: while cntr <= error_array.last
4128: loop
4129: if error_array(cntr).error_code <> QA_VALIDATION_API.OK THEN
4130: errors_list(i).element_id := p_element_id;
4131: errors_list(i).error_code := error_array(cntr).error_code;
4132: i := i+1;
4133: END If;

Line 4144: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND

4140: -- the Id value and also disable the dependent elements
4141: -- This is done in the ELSE part
4142: -- ntungare
4143: --
4144: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4145: ((qa_plan_element_api.keyflex(p_element_id) OR
4146: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4147:
4148: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);

Line 4158: IF QA_VALIDATION_API.no_errors(error_array) = FALSE THEN

4154: -- needs to be captured if there is any. The dependent elements
4155: -- processing needs to be done in case of an invalid value as well
4156: -- ntungare
4157: --
4158: IF QA_VALIDATION_API.no_errors(error_array) = FALSE THEN
4159: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4160: message := replace_message_tokens(message_str);
4161: END IF;
4162:

Line 4405: END qa_validation_api;

4401:
4402: populate_dependency_matrix;
4403: init_message_map;
4404:
4405: END qa_validation_api;