1 PACKAGE qa_mqa_results AS
2 /* $Header: qaress.pls 120.1 2005/10/02 01:22:11 bso noship $ */
3
4 --
5 -- Post a result to the database. This is a wrapper to the QA API
6 -- qa_results_api.insert_row. Do not perform commit. Most of the
7 -- parameters are self explanatory.
8 --
9 -- x_result is a flattened @-separated list of <char_id>=<value>.
10 -- x_result1 and x_result2 are not used but can be reserved for
11 -- expansion if one VARCHAR2 is not enough.
12 -- x_enabled maps to the status flag in qa_results
13 -- (i.e., null or 2 for enabled, 1 for disabled).
14 -- x_committed is whether to commit the row afterwards,
15 -- 1 = yes, others = no.
16 -- x_messages is an @-separated string of error messages if there
17 -- is any error.
18 --
19 -- Return 0 if OK
20 -- Return -1 if error.
21 --
22 FUNCTION post_result(
23 x_occurrence OUT NOCOPY NUMBER,
24 x_org_id IN NUMBER,
25 x_plan_id IN NUMBER,
26 x_spec_id IN NUMBER,
27 x_collection_id IN NUMBER,
28 x_result IN VARCHAR2,
29 x_result1 IN VARCHAR2, -- R12 Project MOAC 4637896, ID passing
30 x_result2 IN VARCHAR2, -- not used yet, for future expansion
31 x_enabled IN INTEGER,
32 x_committed IN INTEGER,
33 x_messages OUT NOCOPY VARCHAR2,
34 p_txn_header_id IN NUMBER DEFAULT NULL) -- Currently Unused
35 RETURN INTEGER;
36
37 -- anagarwa Thu Dec 19 15:43:27 PST 2002
38 -- Bug 2701777
39 -- This function is defined to insert records into qa_results without
40 -- any validations. The change is done for History plans.
41 FUNCTION post_result_with_no_validation(
42 x_occurrence OUT NOCOPY NUMBER,
43 x_org_id IN NUMBER,
44 x_plan_id IN NUMBER,
45 x_spec_id IN NUMBER,
46 x_collection_id IN NUMBER,
47 x_result IN VARCHAR2,
48 x_result1 IN VARCHAR2, -- R12 Project MOAC 4637896, ID passing
49 x_result2 IN VARCHAR2, -- not used yet, for future expansion
50 x_enabled IN INTEGER,
51 x_committed IN INTEGER,
52 x_messages OUT NOCOPY VARCHAR2,
53 p_txn_header_id IN NUMBER DEFAULT NULL)
54 RETURN INTEGER;
55
56
57 --
58 -- The overloaded method is used for transaction only
59 --
60 FUNCTION post_result(
61 x_occurrence OUT NOCOPY NUMBER,
62 x_org_id IN NUMBER,
63 x_plan_id IN NUMBER,
64 x_spec_id IN NUMBER,
65 x_collection_id IN NUMBER,
66 x_result IN VARCHAR2,
67 x_result1 IN VARCHAR2, -- R12 Project MOAC 4637896, ID passing
68 x_result2 IN VARCHAR2, -- not used yet, for future expansion
69 x_enabled IN INTEGER,
70 x_committed IN INTEGER,
71 x_transaction_number IN NUMBER,
72 x_messages OUT NOCOPY VARCHAR2,
73 p_txn_header_id IN NUMBER DEFAULT NULL) -- Currently Unused
74 RETURN INTEGER;
75
76 --
77 -- Delete a result. Do not perform commit.
78 --
79 PROCEDURE delete_result(
80 x_plan_id IN NUMBER,
81 x_collection_id IN NUMBER,
82 x_occurrence IN NUMBER);
83
84 --
85 -- Batch delete a set of results (supply occurrences in
86 -- comma-separated list.) Do not perform commit.
87 --
88 PROCEDURE delete_results(
89 x_plan_id IN NUMBER,
90 x_collection_id IN NUMBER,
91 x_occurrences IN VARCHAR2);
92
93 --
94 -- Perform database commit. Do not use in transaction integration,
95 -- otherwise we will be committing the parent's data without their
96 -- knowing!
97 --
98 PROCEDURE commit_results;
99
100
101 END qa_mqa_results;