1 PACKAGE QA_ERES_PKG as
2 /* $Header: qaeress.pls 120.0.12000000.2 2007/10/16 13:13:37 skolluku ship $ */
3
4 SUFFIXSTRING CONSTANT VARCHAR2(7) := '_QAKM_Z';
5
6 /*
7 Mon May 5 18:03:19 2003, copied from QLTCORE.pld: collapses long comments' internal token
8 representation to the one the user sees in the form.
9 */
10 FUNCTION Collapse_Msg_Tokens (p_msg VARCHAR2) RETURN VARCHAR2;
11
12 /*
13 Wed May 7 15:23:09 2003, copied in part from the qa_flex_util package, this function takes a
14 category_id and category_set_id and retreives the category name and description.
15 */
16 FUNCTION get_category_name(p_category_id IN NUMBER, p_category_set_id IN NUMBER) RETURN VARCHAR2;
17 FUNCTION get_category_desc(p_category_id IN NUMBER, p_category_set_id IN NUMBER) RETURN VARCHAR2;
18
19 /*
20 Thu May 29 15:53:39 2003, for AME params based on soft coded params we need to have a function to
21 lookup a result column name based on qa_results row(identitied using plan_id, collection_id, occurrence)
22 and a char_id.
23
24 Note: this method does not handle multiple rows when occurrence is null.
25 */
26 FUNCTION get_result_column_value(p_plan_id IN NUMBER,
27 p_collection_id IN NUMBER,
28 p_occurrence IN NUMBER,
29 p_char_id IN NUMBER) RETURN VARCHAR2;
30
31 /*
32 Fri Sep 5 11:28:16 2003, for the APPS.QA_ERES_WSH_DELIVERABLES_V view, we need to get the real released status name
33 using some logic to decode the released_status.
34 */
35 FUNCTION decode_wsh_released_status(p_source_code IN VARCHAR2,
36 p_released_status IN VARCHAR2,
37 p_released_status_name IN VARCHAR2,
38 p_inv_interfaced_flag IN VARCHAR2,
39 p_oe_interfaced_flag IN VARCHAR2) RETURN VARCHAR2;
40
41 /*
42 Fri Sep 19 18:45:44 2003, for the APPS.QA_ERES_RCV_TRANS_INTERFACE_V view, we need to get the hazard class from some
43 transaction fields so this function masks the join complexity.
44 */
45 FUNCTION decode_po_hazard_class(p_interface_transaction_id IN NUMBER) RETURN VARCHAR2;
46
47 /*
48 Fri Sep 19 18:45:44 2003, for the APPS.QA_ERES_RCV_TRANS_INTERFACE_V view, we need to get the un_number from some
49 transaction fields so this function masks the join complexity.
50 */
51 FUNCTION decode_po_un_number(p_interface_transaction_id IN NUMBER) RETURN VARCHAR2;
52
53 /*
54 Thu May 6 12:28:59 2004 - ilawler - bug #3599451
55
56 For the Quality Result Creation ERES event, we need a function to handle AME attributes which may return more than
57 one value. The logic is that 'Per Row' will always return a single value. 'Per Collection' will return a value if
58 there is only one distinct value for the column across all rows. If there are multiple values, it throws an exception.
59
60 p_transaction_id VARCHAR2 => Unparsed AME transactionId consisting of <plan_id>-<collection_id>-[<occurrence>].
61 Occurrence is ommitted from the key when 'Per Collection' is selected.
62 p_char_id NUMBER => Char_id of the collection element whose value we want
63
64 RETURNS VARCHAR2 representation of the data for char_id's corresponding column in qa_results_full_v
65 */
66 FUNCTION get_result_column_value(p_transaction_id IN VARCHAR2,
67 p_char_id IN NUMBER) RETURN VARCHAR2;
68 --
69 -- bug 6266477
70 -- Made this function public.
71 -- skolluku Sun Oct 14 03:26:31 PDT 2007
72 --
73 FUNCTION get_result_column_name(p_plan_id IN NUMBER,
74 p_char_id IN NUMBER) RETURN VARCHAR2;
75
76
77
78 END QA_ERES_PKG;