eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_DYN dependencies on PA_ACTION_SETS

Line 1: PACKAGE BODY PA_ACTION_SETS_DYN AS

1: PACKAGE BODY PA_ACTION_SETS_DYN AS
2: PROCEDURE validate_action_set_line(p_action_set_type_code IN VARCHAR2,
3: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
4: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
5: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 91: pa_action_sets asets,

87: BULK COLLECT INTO x_action_set_line_id_tbl,
88: x_object_name_tbl,
89: x_project_number_tbl
90: FROM PA_ADV_RULE_OBJECTS_V conc_view,
91: pa_action_sets asets,
92: pa_action_set_lines alines
93: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
94: AND conc_view.object_type = asets.object_type
95: AND conc_view.object_id = asets.object_id

Line 109: pa_action_sets asets,

105: BULK COLLECT INTO x_action_set_line_id_tbl,
106: x_object_name_tbl,
107: x_project_number_tbl
108: FROM PA_ADV_RULE_OBJECTS_V conc_view,
109: pa_action_sets asets,
110: pa_action_set_lines alines
111: WHERE project_number >= p_project_number_from
112: AND conc_view.object_type = asets.object_type
113: AND conc_view.object_id = asets.object_id

Line 127: pa_action_sets asets,

123: BULK COLLECT INTO x_action_set_line_id_tbl,
124: x_object_name_tbl,
125: x_project_number_tbl
126: FROM PA_ADV_RULE_OBJECTS_V conc_view,
127: pa_action_sets asets,
128: pa_action_set_lines alines
129: WHERE project_number <= p_project_number_to
130: AND conc_view.object_type = asets.object_type
131: AND conc_view.object_id = asets.object_id

Line 145: pa_action_sets asets,

141: BULK COLLECT INTO x_action_set_line_id_tbl,
142: x_object_name_tbl,
143: x_project_number_tbl
144: FROM PA_ADV_RULE_OBJECTS_V conc_view,
145: pa_action_sets asets,
146: pa_action_set_lines alines
147: WHERE
148: conc_view.object_type = asets.object_type
149: AND conc_view.object_id = asets.object_id

Line 170: pa_action_sets asets,

166: BULK COLLECT INTO x_action_set_line_id_tbl,
167: x_object_name_tbl,
168: x_project_number_tbl
169: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
170: pa_action_sets asets,
171: pa_action_set_lines alines
172: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
173: AND conc_view.object_type = asets.object_type
174: AND conc_view.object_id = asets.object_id

Line 188: pa_action_sets asets,

184: BULK COLLECT INTO x_action_set_line_id_tbl,
185: x_object_name_tbl,
186: x_project_number_tbl
187: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
188: pa_action_sets asets,
189: pa_action_set_lines alines
190: WHERE project_number >= p_project_number_from
191: AND conc_view.object_type = asets.object_type
192: AND conc_view.object_id = asets.object_id

Line 206: pa_action_sets asets,

202: BULK COLLECT INTO x_action_set_line_id_tbl,
203: x_object_name_tbl,
204: x_project_number_tbl
205: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
206: pa_action_sets asets,
207: pa_action_set_lines alines
208: WHERE project_number <= p_project_number_to
209: AND conc_view.object_type = asets.object_type
210: AND conc_view.object_id = asets.object_id

Line 224: pa_action_sets asets,

220: BULK COLLECT INTO x_action_set_line_id_tbl,
221: x_object_name_tbl,
222: x_project_number_tbl
223: FROM PA_PROJ_STATUS_REMINDER_V conc_view,
224: pa_action_sets asets,
225: pa_action_set_lines alines
226: WHERE
227: conc_view.object_type = asets.object_type
228: AND conc_view.object_id = asets.object_id

Line 249: pa_action_sets asets,

245: BULK COLLECT INTO x_action_set_line_id_tbl,
246: x_object_name_tbl,
247: x_project_number_tbl
248: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
249: pa_action_sets asets,
250: pa_action_set_lines alines
251: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
252: AND conc_view.object_type = asets.object_type
253: AND conc_view.object_id = asets.object_id

Line 267: pa_action_sets asets,

263: BULK COLLECT INTO x_action_set_line_id_tbl,
264: x_object_name_tbl,
265: x_project_number_tbl
266: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
267: pa_action_sets asets,
268: pa_action_set_lines alines
269: WHERE project_number >= p_project_number_from
270: AND conc_view.object_type = asets.object_type
271: AND conc_view.object_id = asets.object_id

Line 285: pa_action_sets asets,

281: BULK COLLECT INTO x_action_set_line_id_tbl,
282: x_object_name_tbl,
283: x_project_number_tbl
284: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
285: pa_action_sets asets,
286: pa_action_set_lines alines
287: WHERE project_number <= p_project_number_to
288: AND conc_view.object_type = asets.object_type
289: AND conc_view.object_id = asets.object_id

Line 303: pa_action_sets asets,

299: BULK COLLECT INTO x_action_set_line_id_tbl,
300: x_object_name_tbl,
301: x_project_number_tbl
302: FROM PA_TASK_PROGRESS_REMINDER_V conc_view,
303: pa_action_sets asets,
304: pa_action_set_lines alines
305: WHERE
306: conc_view.object_type = asets.object_type
307: AND conc_view.object_id = asets.object_id

Line 318: p_action_set_details_rec IN pa_action_sets%ROWTYPE,

314: -- End fixes for 2778044
315: END IF;
316: END;
317: PROCEDURE perform_action_set_line(p_action_set_type_code IN VARCHAR2,
318: p_action_set_details_rec IN pa_action_sets%ROWTYPE,
319: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
320: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
321: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619
322: x_action_line_result_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895