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.40.12020000.3 2013/02/11 14:14:03 ntungare ship $ */
3:
4: g_dependency_matrix DependencyArray;
5:

Line 3763: RETURN qa_validation_api.ElementsArray IS

3759: END parse_value;
3760:
3761:
3762: FUNCTION result_to_array(p_result IN VARCHAR2)
3763: RETURN qa_validation_api.ElementsArray IS
3764:
3765: elements qa_validation_api.ElementsArray;
3766: n INTEGER;
3767: p INTEGER; -- starting string position

Line 3765: elements qa_validation_api.ElementsArray;

3761:
3762: FUNCTION result_to_array(p_result IN VARCHAR2)
3763: RETURN qa_validation_api.ElementsArray IS
3764:
3765: elements qa_validation_api.ElementsArray;
3766: n INTEGER;
3767: p INTEGER; -- starting string position
3768: q INTEGER; -- ending string position
3769: x_char_id NUMBER;

Line 3796: --IF qa_validation_api.set_validation_flag_sql_valid(x_char_id) THEN

3792: -- Bug 10431717
3793: -- Reverted this fix since we would be validating the entered data
3794: -- again since the LOV values are not validated on cancel
3795: --
3796: --IF qa_validation_api.set_validation_flag_sql_valid(x_char_id) THEN
3797: -- elements(x_char_id).validation_flag := 'valid';
3798: --END IF;
3799: --
3800: -- To the right, must be the value

Line 3826: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)

3822: -- bso Tue Sep 27 17:51:10 PDT 2005
3823: --
3824: FUNCTION id_to_array(
3825: p_result IN VARCHAR2,
3826: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)
3827: RETURN qa_validation_api.ElementsArray IS
3828:
3829: n INTEGER;
3830: p INTEGER; -- starting string position

Line 3827: RETURN qa_validation_api.ElementsArray IS

3823: --
3824: FUNCTION id_to_array(
3825: p_result IN VARCHAR2,
3826: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray)
3827: RETURN qa_validation_api.ElementsArray IS
3828:
3829: n INTEGER;
3830: p INTEGER; -- starting string position
3831: q INTEGER; -- ending string position

Line 3859: IF qa_validation_api.set_validation_flag_sql_valid(l_char_id) THEN

3855: -- Added this statement to set the validation flag back to
3856: -- valid if the element has a validation string.
3857: -- this api is called from forms and qwb where the
3858: -- value of the element will be validated at UI.
3859: IF qa_validation_api.set_validation_flag_sql_valid(l_char_id) THEN
3860: x_elements(l_char_id).validation_flag := 'valid';
3861: END IF;
3862:
3863: x_elements(l_char_id).validation_flag :=

Line 3865: qa_validation_api.id_derived;

3861: END IF;
3862:
3863: x_elements(l_char_id).validation_flag :=
3864: nvl(x_elements(l_char_id).validation_flag, 'invalid') ||
3865: qa_validation_api.id_derived;
3866: p := q;
3867: END LOOP;
3868:
3869: RETURN x_elements;

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

3870: END id_to_array;
3871:
3872:
3873: PROCEDURE set_validation_flag(
3874: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray) IS
3875: i INTEGER;
3876: BEGIN
3877: i := x_elements.FIRST;
3878: WHILE i <= x_elements.LAST LOOP

Line 3881: qa_validation_api.action_fired;

3877: i := x_elements.FIRST;
3878: WHILE i <= x_elements.LAST LOOP
3879: x_elements(i).validation_flag :=
3880: x_elements(i).validation_flag ||
3881: qa_validation_api.action_fired;
3882:
3883: IF i = qa_ss_const.transaction_type THEN
3884: x_elements(i).validation_flag :=
3885: x_elements(i).validation_flag ||

Line 3886: qa_validation_api.valid_element;

3882:
3883: IF i = qa_ss_const.transaction_type THEN
3884: x_elements(i).validation_flag :=
3885: x_elements(i).validation_flag ||
3886: qa_validation_api.valid_element;
3887: END IF;
3888:
3889: i := x_elements.NEXT(i);
3890: END LOOP;

Line 3915: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

3911: -- bso Sat Oct 1 15:05:35 PDT 2005
3912: --
3913:
3914: PROCEDURE set_validation_flag_txn(
3915: x_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
3916: p_plan_id NUMBER,
3917: p_transaction_number NUMBER,
3918: p_plan_transaction_id NUMBER) IS
3919:

Line 3952: qa_validation_api.valid_element;

3948: FOR c IN context LOOP
3949: IF x_elements.EXISTS(c.collection_trigger_id) THEN
3950: x_elements(c.collection_trigger_id).validation_flag :=
3951: x_elements(c.collection_trigger_id).validation_flag ||
3952: qa_validation_api.valid_element;
3953: END IF;
3954: END LOOP;
3955:
3956: --

Line 3962: qa_validation_api.valid_element;

3958: --
3959: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3960: x_elements(qa_ss_const.lot_number).validation_flag :=
3961: x_elements(qa_ss_const.lot_number).validation_flag ||
3962: qa_validation_api.valid_element;
3963: END IF;
3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3966: x_elements(qa_ss_const.serial_number).validation_flag :=

Line 3968: qa_validation_api.valid_element;

3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3966: x_elements(qa_ss_const.serial_number).validation_flag :=
3967: x_elements(qa_ss_const.serial_number).validation_flag ||
3968: qa_validation_api.valid_element;
3969: END IF;
3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3972: x_elements(qa_ss_const.transaction_type).validation_flag :=

Line 3974: qa_validation_api.valid_element;

3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3972: x_elements(qa_ss_const.transaction_type).validation_flag :=
3973: x_elements(qa_ss_const.transaction_type).validation_flag ||
3974: qa_validation_api.valid_element;
3975: END IF;
3976:
3977: --
3978: -- Step 3. If it is a background plan, set all elements

Line 4006: qa_validation_api.background_element;

4002: i := x_elements.FIRST;
4003: WHILE i <= x_elements.LAST LOOP
4004: x_elements(i).validation_flag :=
4005: x_elements(i).validation_flag ||
4006: qa_validation_api.background_element;
4007: i := x_elements.NEXT(i);
4008: END LOOP;
4009: END IF;
4010:

Line 4178: row_record QA_VALIDATION_API.RowRecord;

4174: dependent_elements OUT NOCOPY VARCHAR2,
4175: disable_enable_flag_list OUT NOCOPY VARCHAR2,
4176: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4177: AS
4178: row_record QA_VALIDATION_API.RowRecord;
4179: result_record QA_VALIDATION_API.ResultRecord;
4180: row_elements QA_VALIDATION_API.ElementsArray;
4181: error_array QA_VALIDATION_API.ErrorArray;
4182: errors_list QA_VALIDATION_API.ErrorArray;

Line 4179: result_record QA_VALIDATION_API.ResultRecord;

4175: disable_enable_flag_list OUT NOCOPY VARCHAR2,
4176: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4177: AS
4178: row_record QA_VALIDATION_API.RowRecord;
4179: result_record QA_VALIDATION_API.ResultRecord;
4180: row_elements QA_VALIDATION_API.ElementsArray;
4181: error_array QA_VALIDATION_API.ErrorArray;
4182: errors_list QA_VALIDATION_API.ErrorArray;
4183: cntr NUMBER;

Line 4180: row_elements QA_VALIDATION_API.ElementsArray;

4176: disabled_dep_elem_vo_attr_lst OUT NOCOPY VARCHAR2)
4177: AS
4178: row_record QA_VALIDATION_API.RowRecord;
4179: result_record QA_VALIDATION_API.ResultRecord;
4180: row_elements QA_VALIDATION_API.ElementsArray;
4181: error_array QA_VALIDATION_API.ErrorArray;
4182: errors_list QA_VALIDATION_API.ErrorArray;
4183: cntr NUMBER;
4184: i NUMBER :=1 ;

Line 4181: error_array QA_VALIDATION_API.ErrorArray;

4177: AS
4178: row_record QA_VALIDATION_API.RowRecord;
4179: result_record QA_VALIDATION_API.ResultRecord;
4180: row_elements QA_VALIDATION_API.ElementsArray;
4181: error_array QA_VALIDATION_API.ErrorArray;
4182: errors_list QA_VALIDATION_API.ErrorArray;
4183: cntr NUMBER;
4184: i NUMBER :=1 ;
4185: message_str VARCHAR2(4000);

Line 4182: errors_list QA_VALIDATION_API.ErrorArray;

4178: row_record QA_VALIDATION_API.RowRecord;
4179: result_record QA_VALIDATION_API.ResultRecord;
4180: row_elements QA_VALIDATION_API.ElementsArray;
4181: error_array QA_VALIDATION_API.ErrorArray;
4182: errors_list QA_VALIDATION_API.ErrorArray;
4183: cntr NUMBER;
4184: i NUMBER :=1 ;
4185: message_str VARCHAR2(4000);
4186:

Line 4200: elements qa_validation_api.ElementsArray;

4196: dep_elements_list VARCHAR2(4000);
4197: dep_flag_list VARCHAR2(4000);
4198: dep_elements_status VARCHAR2(4000);
4199:
4200: elements qa_validation_api.ElementsArray;
4201:
4202: dependent_elements_arr QA_PARENT_CHILD_PKG.ChildPlanArray;
4203: dep_elements_status_arr QA_PARENT_CHILD_PKG.ChildPlanArray;
4204:

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

4207: BEGIN
4208: -- populate the record structures
4209: /*
4210: if result_string is not NULL THEN
4211: elements := qa_validation_api.result_to_array(result_string);
4212: elements := qa_validation_api.id_to_array(id_string, elements);
4213: end if;
4214: */
4215:

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

4208: -- populate the record structures
4209: /*
4210: if result_string is not NULL THEN
4211: elements := qa_validation_api.result_to_array(result_string);
4212: elements := qa_validation_api.id_to_array(id_string, elements);
4213: end if;
4214: */
4215:
4216: row_elements(p_element_id).id := p_element_id;

Line 4263: error_array := QA_VALIDATION_API.validate_element(

4259: result_record.element_id := p_element_id;
4260:
4261: -- call the validate_element api to perform
4262: -- the element validation
4263: error_array := QA_VALIDATION_API.validate_element(
4264: row_elements => row_elements,
4265: row_record => row_record,
4266: element_id => p_element_id,
4267: org_id => p_org_id,

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

4271:
4272: -- build the error list array
4273: while cntr <= error_array.last
4274: loop
4275: if error_array(cntr).error_code <> QA_VALIDATION_API.OK THEN
4276: errors_list(i).element_id := p_element_id;
4277: errors_list(i).error_code := error_array(cntr).error_code;
4278: i := i+1;
4279: END If;

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

4286: -- the Id value and also disable the dependent elements
4287: -- This is done in the ELSE part
4288: -- ntungare
4289: --
4290: If (QA_VALIDATION_API.no_errors(error_array) = FALSE AND
4291: ((qa_plan_element_api.keyflex(p_element_id) OR
4292: qa_plan_element_api.normalized(p_element_id)) = FALSE)) THEN
4293:
4294: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);

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

4300: -- needs to be captured if there is any. The dependent elements
4301: -- processing needs to be done in case of an invalid value as well
4302: -- ntungare
4303: --
4304: IF QA_VALIDATION_API.no_errors(error_array) = FALSE THEN
4305: QA_SS_RESULTS.get_error_messages(errors_list, p_plan_id, message_str);
4306: message := replace_message_tokens(message_str);
4307: END IF;
4308:

Line 4588: END qa_validation_api;

4584:
4585: populate_dependency_matrix;
4586: init_message_map;
4587:
4588: END qa_validation_api;