1 PACKAGE qa_results_api AS
2 /* $Header: qltrsiub.pls 120.2.12010000.1 2008/07/25 09:22:16 appldev ship $ */
3
4
5 PROCEDURE commit_qa_results( p_collection_id IN NUMBER);
6
7
8 PROCEDURE enable_and_fire_action( p_collection_id IN NUMBER);
9
10 --
11 -- 12.1 QWB Usability Improvements
12 -- added a new parameter, p_ssqr_opperation to ensure
13 -- that the validation is not done again at the time of
14 -- inserting rows through QWB
15 --
16 FUNCTION insert_row( p_plan_id IN NUMBER,
17 p_spec_id IN NUMBER DEFAULT NULL,
18 p_org_id IN NUMBER,
19 p_transaction_number IN NUMBER DEFAULT NULL,
20 p_transaction_id IN NUMBER DEFAULT 0,
21 p_collection_id IN OUT NOCOPY NUMBER,
22 p_who_last_updated_by IN NUMBER := fnd_global.user_id,
23 p_who_created_by IN NUMBER := fnd_global.user_id,
24 p_who_last_update_login IN NUMBER := fnd_global.user_id,
25 p_enabled_flag IN NUMBER,
26 p_commit_flag IN BOOLEAN DEFAULT FALSE,
27 p_error_found OUT NOCOPY BOOLEAN,
28 p_occurrence IN OUT NOCOPY NUMBER,
29 p_do_action_return OUT NOCOPY BOOLEAN,
30 p_message_array OUT NOCOPY qa_validation_api.MessageArray,
31 p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
32 p_txn_header_id IN NUMBER DEFAULT NULL,
33 p_ssqr_operation IN NUMBER DEFAULT NULL,
34 p_last_update_date IN DATE DEFAULT SYSDATE)
35
36 RETURN qa_validation_api.ErrorArray;
37
38 --
39 -- 12.1 QWB Usability Improvements
40 -- added a new parameter, p_ssqr_opperation to ensure
41 -- that the validation is not done again at the time of
42 -- updting rows through QWB
43 --
44 FUNCTION update_row( p_plan_id IN NUMBER,
45 p_spec_id IN NUMBER,
46 p_org_id IN NUMBER,
47 p_transaction_number IN NUMBER DEFAULT NULL,
48 p_transaction_id IN NUMBER DEFAULT NULL,
49 p_collection_id IN NUMBER,
50 p_who_last_updated_by IN NUMBER := fnd_global.user_id,
51 p_who_created_by IN NUMBER := fnd_global.user_id,
52 p_who_last_update_login IN NUMBER := fnd_global.user_id,
53 p_enabled_flag IN NUMBER,
54 p_commit_flag IN BOOLEAN DEFAULT FALSE,
55 p_error_found OUT NOCOPY BOOLEAN,
56 p_occurrence IN NUMBER,
57 p_do_action_return OUT NOCOPY BOOLEAN,
58 p_message_array OUT NOCOPY qa_validation_api.MessageArray,
59 p_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
60 p_txn_header_id IN NUMBER DEFAULT NULL,
61 p_ssqr_operation IN NUMBER DEFAULT NULL,
62 p_last_update_date IN DATE DEFAULT SYSDATE)
63 RETURN qa_validation_api.ErrorArray;
64
65 /* akbhatia- Bug 3345279 : Added a new procedure enable.*/
66
67 PROCEDURE enable( p_collection_id IN NUMBER);
68
69 END qa_results_api;
70