DBA Data[Home] [Help]

APPS.QA_RESULTS_API dependencies on QA_VALIDATION_API

Line 63: p_message_array OUT NOCOPY qa_validation_api.MessageArray,

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)

Line 64: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

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

Line 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;

Line 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;

Line 73: master_error_list qa_validation_api.ErrorArray;

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;

Line 147: master_error_list := qa_validation_api.validate_row(

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,

Line 170: master_error_list := qa_validation_api.processNotEnteredActions(

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,

Line 179: IF qa_validation_api.no_errors(master_error_list) THEN

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

Line 467: p_message_array OUT NOCOPY qa_validation_api.MessageArray,

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)

Line 468: p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

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

Line 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;

Line 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;

Line 477: master_error_list qa_validation_api.ErrorArray;

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;

Line 538: master_error_list := qa_validation_api.validate_row(p_plan_id,

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

Line 585: IF qa_validation_api.no_errors(master_error_list) THEN

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: