59: p_commit_flag IN BOOLEAN DEFAULT FALSE,
60: p_error_found OUT NOCOPY BOOLEAN,
61: p_occurrence IN OUT NOCOPY NUMBER,
62: p_do_action_return OUT NOCOPY BOOLEAN,
63: p_message_array OUT NOCOPY qa_validation_api.MessageArray,
64: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
65: p_txn_header_id IN NUMBER DEFAULT NULL,
66: p_ssqr_operation IN NUMBER DEFAULT NULL,
67: p_last_update_date IN DATE DEFAULT SYSDATE)
60: p_error_found OUT NOCOPY BOOLEAN,
61: p_occurrence IN OUT NOCOPY NUMBER,
62: p_do_action_return OUT NOCOPY BOOLEAN,
63: p_message_array OUT NOCOPY qa_validation_api.MessageArray,
64: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
65: p_txn_header_id IN NUMBER DEFAULT NULL,
66: p_ssqr_operation IN NUMBER DEFAULT NULL,
67: p_last_update_date IN DATE DEFAULT SYSDATE)
68: RETURN qa_validation_api.ErrorArray IS
64: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
65: p_txn_header_id IN NUMBER DEFAULT NULL,
66: p_ssqr_operation IN NUMBER DEFAULT NULL,
67: p_last_update_date IN DATE DEFAULT SYSDATE)
68: RETURN qa_validation_api.ErrorArray IS
69:
70:
71:
72: return_results_array qa_validation_api.ResultRecordArray;
68: RETURN qa_validation_api.ErrorArray IS
69:
70:
71:
72: return_results_array qa_validation_api.ResultRecordArray;
73: master_error_list qa_validation_api.ErrorArray;
74:
75: insert_string varchar2(6000) := null;
76: value_string varchar2(30000) := null;
69:
70:
71:
72: return_results_array qa_validation_api.ResultRecordArray;
73: master_error_list qa_validation_api.ErrorArray;
74:
75: insert_string varchar2(6000) := null;
76: value_string varchar2(30000) := null;
77: sql_string varchar2(32000) := null;
143: -- derive the Id values for the context elements
144: --
145: If (p_ssqr_operation IS NULL OR
146: p_ssqr_operation = 2) THEN
147: master_error_list := qa_validation_api.validate_row(
148: p_plan_id,
149: p_spec_id,
150: p_org_id,
151: p_who_created_by,
166: -- value not entered trigger conditiion would not be fired.
167: -- hence making a call to the api processNotEnteredActions that
168: -- would process those action conditions
169: --
170: master_error_list := qa_validation_api.processNotEnteredActions(
171: p_plan_id => p_plan_id,
172: p_spec_id => p_spec_id,
173: p_ssqr_operation => p_ssqr_operation,
174: p_row_elements => p_row_elements,
175: p_return_results_array => return_results_array,
176: message_array => p_message_array);
177:
178: END If;
179: IF qa_validation_api.no_errors(master_error_list) THEN
180:
181: p_error_found := FALSE;
182:
183: -- construct INSERT sql part
463: p_commit_flag IN BOOLEAN DEFAULT FALSE,
464: p_error_found OUT NOCOPY BOOLEAN,
465: p_occurrence IN NUMBER,
466: p_do_action_return OUT NOCOPY BOOLEAN,
467: p_message_array OUT NOCOPY qa_validation_api.MessageArray,
468: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
469: p_txn_header_id IN NUMBER DEFAULT NULL,
470: p_ssqr_operation IN NUMBER DEFAULT NULL,
471: p_last_update_date IN DATE DEFAULT SYSDATE)
464: p_error_found OUT NOCOPY BOOLEAN,
465: p_occurrence IN NUMBER,
466: p_do_action_return OUT NOCOPY BOOLEAN,
467: p_message_array OUT NOCOPY qa_validation_api.MessageArray,
468: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
469: p_txn_header_id IN NUMBER DEFAULT NULL,
470: p_ssqr_operation IN NUMBER DEFAULT NULL,
471: p_last_update_date IN DATE DEFAULT SYSDATE)
472: RETURN qa_validation_api.ErrorArray IS
468: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
469: p_txn_header_id IN NUMBER DEFAULT NULL,
470: p_ssqr_operation IN NUMBER DEFAULT NULL,
471: p_last_update_date IN DATE DEFAULT SYSDATE)
472: RETURN qa_validation_api.ErrorArray IS
473:
474:
475:
476: return_results_array qa_validation_api.ResultRecordArray;
472: RETURN qa_validation_api.ErrorArray IS
473:
474:
475:
476: return_results_array qa_validation_api.ResultRecordArray;
477: master_error_list qa_validation_api.ErrorArray;
478:
479: update_string varchar2(25) := null;
480: where_clause varchar2(500) := null;
473:
474:
475:
476: return_results_array qa_validation_api.ResultRecordArray;
477: master_error_list qa_validation_api.ErrorArray;
478:
479: update_string varchar2(25) := null;
480: where_clause varchar2(500) := null;
481: value_string varchar2(30000) := null;
534: -- p_ssqr_operation is NULL which means that the call
535: -- of not from the self service application
536: --
537: If (p_ssqr_operation IS NULL) THEN
538: master_error_list := qa_validation_api.validate_row(p_plan_id,
539: p_spec_id, p_org_id, p_who_created_by, p_transaction_number,
540: p_transaction_id, return_results_array, p_message_array,
541: p_row_elements);
542: -- In case the call is from the self-service application
581: charctr := p_row_elements.next(charctr);
582: end loop;
583: END If;
584:
585: IF qa_validation_api.no_errors(master_error_list) THEN
586:
587: p_error_found := FALSE;
588:
589: