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_SET_LINES

Line 3: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,

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
6: IS
7: BEGIN

Line 92: pa_action_set_lines alines

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
96: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 110: pa_action_set_lines alines

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
114: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 128: pa_action_set_lines alines

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
132: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 146: pa_action_set_lines alines

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
150: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 171: pa_action_set_lines alines

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
175: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 189: pa_action_set_lines alines

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
193: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 207: pa_action_set_lines alines

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
211: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 225: pa_action_set_lines alines

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
229: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 250: pa_action_set_lines alines

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
254: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 268: pa_action_set_lines alines

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
272: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 286: pa_action_set_lines alines

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
290: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 304: pa_action_set_lines alines

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
308: AND asets.action_set_type_code = nvl(p_action_set_type_code, asets.action_set_type_code)

Line 319: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,

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
323: IS