[Home] [Help]
PACKAGE: APPS.QA_MQA_PLAN_ELEMENTS
Source
1 PACKAGE qa_mqa_plan_elements AUTHID CURRENT_USER AS
2 /* $Header: qachars.pls 120.2 2006/02/05 18:06:53 bso noship $ */
3
4
5 --
6 -- Attributes of a plan element.
7 --
8 -- Modified to include Read Only Flag for Collection Plan Elements
9 -- saugupta
10 TYPE PlanElementRecord IS RECORD (
11 char_id NUMBER,
12 name qa_chars.name%TYPE,
13 prompt qa_plan_chars.prompt%TYPE,
14 data_entry_hint qa_chars.data_entry_hint%TYPE,
15 datatype NUMBER,
16 display_length NUMBER,
17 decimal_precision NUMBER,
18 default_value qa_plan_chars.default_value%TYPE,
19 lov_flag NUMBER,
20 mandatory_flag NUMBER,
21 displayed_flag NUMBER,
22 read_only_flag NUMBER,
23 target_value qa_chars.target_value%TYPE,
24 upper_spec_limit qa_chars.upper_spec_limit%TYPE,
25 lower_spec_limit qa_chars.lower_spec_limit%TYPE,
26 upper_reasonable_limit qa_chars.upper_reasonable_limit%TYPE,
27 lower_reasonable_limit qa_chars.lower_reasonable_limit%TYPE,
28 upper_user_defined_limit qa_chars.upper_user_defined_limit%TYPE,
29 lower_user_defined_limit qa_chars.lower_user_defined_limit%TYPE
30 );
31
32
33 TYPE PlanElementRefCursor IS REF CURSOR RETURN PlanElementRecord;
34
35
36 --
37 -- Attributes of a flattened Action Trigger for a given plan element.
38 --
39 TYPE ActionTriggerRecord IS RECORD (
40 plan_char_action_trigger_id NUMBER,
41 plan_char_action_id NUMBER,
42 trigger_sequence NUMBER,
43 operator NUMBER,
44 low_value_lookup qa_plan_char_action_triggers.low_value_lookup%TYPE,
45 high_value_lookup qa_plan_char_action_triggers.high_value_lookup%TYPE,
46 low_value_other qa_plan_char_action_triggers.low_value_other%TYPE,
47 high_value_other qa_plan_char_action_triggers.high_value_other%TYPE,
48 action_id NUMBER,
49 message qa_plan_char_actions.message%TYPE,
50 assigned_char_id NUMBER,
51 assign_type qa_plan_char_actions.assign_type%TYPE,
52 online_flag NUMBER
53 );
54
55
56 TYPE ActionTriggerRefCursor IS REF CURSOR RETURN ActionTriggerRecord;
57
58
59 --
60 -- Attributes of an action token
61 --
62 TYPE ActionTokenRecord IS RECORD (
63 token_name qa_plan_char_action_outputs.token_name%TYPE,
64 char_id NUMBER
65 );
66
67
68 TYPE ActionTokenRefCursor IS REF CURSOR RETURN ActionTokenRecord;
69
70
71 --
72 -- Return a ref cursor that loops through all plan
73 -- elements.
74 --
75 FUNCTION get_elements(
76 x_plan_id IN NUMBER,
77 x_spec_id IN NUMBER DEFAULT NULL) RETURN PlanElementRefCursor;
78
79
80 --
81 -- Return a ref cursor that loops through all online (aka immediate)
82 -- action triggers of a plan element.
83 --
84 FUNCTION get_online_action_triggers(x_plan_id IN NUMBER, x_char_id IN NUMBER)
85 RETURN ActionTriggerRefCursor;
86
87
88 --
89 -- Return a ref cursor that loops through all action tokens
90 -- given an action of an action trigger.
91 --
92 FUNCTION get_action_tokens(x_plan_char_action_id IN NUMBER)
93 RETURN ActionTokenRefCursor;
94
95
96 --
97 -- Return a plan name given a plan ID.
98 --
99 FUNCTION get_plan_name(x_plan_id IN NUMBER) RETURN VARCHAR2;
100
101
102 --
103 -- Return a spec type given a plan ID.
104 --
105 PROCEDURE get_spec_type (p_plan_id IN NUMBER, x_spec_type OUT NOCOPY VARCHAR2,
106 x_spec_type_name OUT NOCOPY VARCHAR2);
107
108
109
110 /*
111 Excluded for performance reasons.
112
113 --
114 -- Return 1 if there should be an lov for the given plan element.
115 -- Return 2 if not.
116 --
117 FUNCTION has_lov(x_plan_id IN NUMBER, x_char_id IN NUMBER)
118 RETURN NUMBER;
119 */
120
121 --
122 -- For Specification Enhancements
123 -- rkunchal
124 --
125
126 FUNCTION get_spec_limit(plan_char_uom VARCHAR2, spec_char_uom VARCHAR2,
127 decimal_precision NUMBER, value NUMBER)
128 RETURN NUMBER;
129
130 -- Bug 3288391. The function added for returning specification limits for
131 -- date and datetime elements
132 -- saugupta Thu, 11 Dec 2003 22:06:30 -0800 PDT
133 FUNCTION get_spec_limit(plan_char_uom VARCHAR2, spec_char_uom VARCHAR2,
134 decimal_precision NUMBER, x_value VARCHAR2)
135 RETURN VARCHAR2;
136
137 --
138 -- Bug 4958730. SQL Repository fix for SQL ID 15007756
139 -- requires a rewrite of the above "get_spec_limit" function.
140 -- bso Sun Feb 5 17:46:13 PST 2006
141 --
142 FUNCTION get_spec_limit(
143 p_char_id NUMBER,
144 p_datatype NUMBER,
145 p_spec_char_id NUMBER,
146 p_qc_uom_code VARCHAR2,
147 p_qpc_uom_code VARCHAR2,
148 p_qsc_uom_code VARCHAR2,
149 p_qc_dec_prec NUMBER,
150 p_qpc_dec_prec NUMBER,
151 p_qc_spec_limit VARCHAR2,
152 p_qsc_spec_limit VARCHAR2)
153 RETURN VARCHAR2;
154
155 END qa_mqa_plan_elements;