[Home] [Help]
PACKAGE: APPS.QA_SS_PARENT_CHILD_PKG
Source
1 PACKAGE qa_ss_parent_child_pkg AS
2 /* $Header: qapcsss.pls 120.2 2005/12/19 03:56:49 srhariha noship $ */
3
4 TYPE ErrorTable IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
5
6 PROCEDURE post_error_messages (p_errors IN ErrorTable);
7
8 PROCEDURE insert_plan_rel_chk(p_parent_plan_id IN NUMBER,
9 p_parent_plan_name IN VARCHAR2,
10 p_child_plan_id IN NUMBER,
11 p_child_plan_name IN VARCHAR2,
12 p_data_entry_mode IN NUMBER,
13 p_layout_mode IN NUMBER default null,
14 p_num_auto_rows IN NUMBER,
15 x_parent_plan_id OUT NOCOPY NUMBER,
16 x_child_plan_id OUT NOCOPY NUMBER,
17 x_status OUT NOCOPY VARCHAR2);
18
19 PROCEDURE update_plan_rel_chk(
20 p_parent_plan_id IN NUMBER,
21 p_parent_plan_name IN VARCHAR2,
22 p_child_plan_id IN NUMBER,
23 p_child_plan_name IN VARCHAR2,
24 p_data_entry_mode IN NUMBER,
25 p_layout_mode IN NUMBER default null,
26 p_num_auto_rows IN NUMBER,
27 p_new_plan IN VARCHAR2,
28 x_parent_plan_id OUT NOCOPY NUMBER,
29 x_child_plan_id OUT NOCOPY NUMBER,
30 x_status OUT NOCOPY VARCHAR2) ;
31
32
33
34 PROCEDURE insert_plan_rel(p_parent_plan_id NUMBER,
35 p_child_plan_id NUMBER,
36 p_plan_relationship_type NUMBER,
37 p_data_entry_mode NUMBER,
38 p_layout_mode NUMBER default null,
39 p_auto_row_count NUMBER,
40 p_default_parent_spec VARCHAR2,
41 p_last_updated_by NUMBER := fnd_global.user_id,
42 p_created_by NUMBER := fnd_global.user_id,
43 p_last_update_login NUMBER := fnd_global.user_id,
44 x_plan_relationship_id IN OUT NOCOPY NUMBER);
45
46
47 PROCEDURE insert_element_rel(p_plan_relationship_id NUMBER,
48 p_parent_char_id NUMBER,
49 p_child_char_id NUMBER,
50 p_element_relationship_type NUMBER,
51 p_link_flag VARCHAR2,
52 p_last_updated_by NUMBER := fnd_global.user_id,
53 p_created_by NUMBER := fnd_global.user_id,
54 p_last_update_login NUMBER := fnd_global.user_id,
55 x_element_relationship_id OUT NOCOPY NUMBER);
56
57 PROCEDURE insert_element_rel_chk(p_parent_char_id NUMBER,
58 p_child_char_id NUMBER,
59 p_relationship_type NUMBER,
60 x_status OUT NOCOPY VARCHAR2);
61
62 PROCEDURE insert_criteria_rel(p_plan_relationship_id NUMBER,
63 p_char_id NUMBER,
64 p_operator NUMBER,
65 p_low_value VARCHAR2,
66 -- p_low_value_id NUMBER,
67 p_high_value VARCHAR2,
68 -- p_high_value_id NUMBER,
69 p_last_updated_by NUMBER := fnd_global.user_id,
70 p_created_by NUMBER := fnd_global.user_id,
71 p_last_update_login NUMBER := fnd_global.user_id,
72 x_criteria_id OUT NOCOPY NUMBER);
73
74 PROCEDURE update_plan_rel(p_plan_relationship_id NUMBER,
75 p_parent_plan_id NUMBER,
76 p_child_plan_id NUMBER,
77 p_plan_relationship_type NUMBER,
78 p_data_entry_mode NUMBER,
79 p_layout_mode NUMBER default null,
80 p_auto_row_count NUMBER,
81 p_default_parent_spec VARCHAR2,
82 p_last_updated_by NUMBER:=fnd_global.user_id,
83 p_created_by NUMBER:=fnd_global.user_id,
84 p_last_update_login NUMBER:=fnd_global.user_id
85 );
86
87 PROCEDURE update_element_rel(
88 p_element_relationship_id NUMBER,
89 p_plan_relationship_id NUMBER,
90 p_parent_char_id NUMBER,
91 p_child_char_id NUMBER,
92 p_element_relationship_type NUMBER,
93 p_link_flag VARCHAR2,
94 p_last_updated_by NUMBER := fnd_global.user_id,
95 p_created_by NUMBER := fnd_global.user_id,
96 p_last_update_login NUMBER := fnd_global.user_id,
97 p_row_id VARCHAR2);
98
99
100 PROCEDURE update_criteria_rel(
101 p_rowid VARCHAR2,
102 p_plan_relationship_id NUMBER,
103 p_char_id NUMBER,
104 p_operator NUMBER,
105 p_low_value VARCHAR2,
106 p_high_value VARCHAR2,
107 p_last_updated_by NUMBER := fnd_global.user_id,
108 p_created_by NUMBER := fnd_global.user_id,
109 p_last_update_login NUMBER := fnd_global.user_id,
110 p_criteria_id NUMBER);
111
112
113 PROCEDURE delete_element_rel(p_element_relationship_id NUMBER);
114
115 PROCEDURE delete_criteria(p_criteria_id NUMBER);
116
117 FUNCTION descendant_plans_exist(p_plan_id NUMBER) RETURN VARCHAR2 ;
118
119 FUNCTION is_plan_applicable (
120 p_plan_id IN NUMBER,
121 search_array IN qa_txn_grp.ElementsArray)
122 RETURN VARCHAR2;
123
124 FUNCTION get_plan_vqr_sql (
125 p_plan_id IN NUMBER,
126 p_search_str IN VARCHAR2,
127 p_collection_id IN NUMBER default null,
128 p_occurrence in NUMBER default null,
129 p_search_str2 IN VARCHAR2 default null, --future use
130 p_search_str3 IN VARCHAR2 default null)
131 RETURN VARCHAR2;
132
133 FUNCTION check_for_elements (
134 p_plan_id IN NUMBER,
135 p_search_array IN qa_txn_grp.ElementsArray)
136 RETURN VARCHAR2;
137
138 FUNCTION check_for_results (
139 p_plan_id IN NUMBER,
140 p_search_array IN qa_txn_grp.ElementsArray)
141 RETURN VARCHAR2;
142
143
144 FUNCTION get_where_clause (
145 p_plan_id IN NUMBER,
146 p_search_array IN qa_txn_grp.ElementsArray)
147 RETURN VARCHAR2;
148
149
150 FUNCTION get_child_vqr_sql (
151 p_child_plan_id IN NUMBER,
152 p_parent_plan_id IN NUMBER,
153 p_parent_collection_id IN NUMBER,
154 p_parent_occurrence IN NUMBER)
155 RETURN VARCHAR2;
156
157 FUNCTION get_parent_vqr_sql (
158 p_parent_plan_id IN NUMBER,
159 p_parent_collection_id IN NUMBER,
160 p_parent_occurrence IN NUMBER)
161 RETURN VARCHAR2;
162
163 PROCEDURE delete_plan_rel(p_plan_relationship_id NUMBER);
164
165 FUNCTION get_plan_ids (
166 p_search_str IN VARCHAR2,
167 p_org_id IN VARCHAR2 default null,
168 p_search_str2 IN VARCHAR2 default null, --future use
169 p_search_str3 IN VARCHAR2 default null)
170 RETURN VARCHAR2;
171
172
173 END qa_ss_parent_child_pkg;