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,
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,
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,
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
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: );
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:
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:
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;