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_PROJ_STAT_ACTSET dependencies on PA_ACTION_SET_UTILS

Line 12: l_line_number_tbl pa_action_set_utils.number_tbl_type;

8: , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
9: , x_return_status OUT NOCOPY VARCHAR2
10: ) IS
11:
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 13: l_line_id_tbl pa_action_set_utils.number_tbl_type;

9: , x_return_status OUT NOCOPY VARCHAR2
10: ) IS
11:
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
17: l_loop_cnt NUMBER;

Line 14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;

10: ) IS
11:
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
17: l_loop_cnt NUMBER;
18:

Line 15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;

11:
12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
17: l_loop_cnt NUMBER;
18:
19: BEGIN

Line 102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

98: PROCEDURE perform_action_set_line(
99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
104: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
105:
106: IS

Line 103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type

99: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
100: ,p_action_set_details_rec IN pa_action_sets%ROWTYPE
101: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
102: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
103: ,x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type
104: ,x_action_line_result_code OUT NOCOPY VARCHAR2)
105:
106: IS
107: CURSOR c_report_info(cp_layout_id NUMBER) IS

Line 139: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

135:
136: BEGIN
137:
138: pa_debug.init_err_stack('PA_PROJ_STAT_ACTSET:perform_action_set_line');
139: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
140: g_action_line_audit_tbl.DELETE;
141:
142: if validate_action_type_code(p_action_set_type_code) = FALSE then
143: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 152: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;

148: end if;
149:
150: --per Xiouyuan,hard-coding statu code, bug 2383406
151: if p_action_set_line_rec.status_code = 'REVERSE_PENDING' then
152: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;
153: PA_DEBUG.RESET_ERR_STACK;
154: return;
155: end if;
156:

Line 162: PA_ACTION_SET_UTILS.Add_Message ( p_app_short_name => 'PA'

158: OPEN c_report_info(p_action_set_details_rec.object_id);
159: FETCH c_report_info INTO cp_rpt_info;
160: if c_report_info%NOTFOUND then
161: CLOSE c_report_info;
162: PA_ACTION_SET_UTILS.Add_Message ( p_app_short_name => 'PA'
163: ,p_msg_name => 'PA_INVALID_PROJECT_ID'); --existing msg
164: PA_DEBUG.RESET_ERR_STACK;
165: return;
166: end if ;

Line 183: PA_ACTION_SET_UTILS.Add_Message ( p_app_short_name => 'PA'

179: return;
180: end if;
181:
182: if (l_project_id is null or l_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
183: PA_ACTION_SET_UTILS.Add_Message ( p_app_short_name => 'PA'
184: ,p_msg_name => 'PA_NO_PROJECT_ID'); --existing message
185: PA_DEBUG.RESET_ERR_STACK;
186: return;
187: end if ;

Line 221: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;

217: end if;
218: if (l_action_performed = 'Y') then
219: l_action_is_repeating := is_action_repeating(p_action_line_conditions_tbl);
220: if (l_action_is_repeating) then
221: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;
222: else
223: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
224: end if;
225: x_action_line_audit_tbl := PA_PROJ_STAT_ACTSET.g_action_line_audit_tbl;

Line 223: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;

219: l_action_is_repeating := is_action_repeating(p_action_line_conditions_tbl);
220: if (l_action_is_repeating) then
221: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_ACTIVE;
222: else
223: x_action_line_result_code := pa_action_set_utils.G_PERFORMED_COMPLETE;
224: end if;
225: x_action_line_audit_tbl := PA_PROJ_STAT_ACTSET.g_action_line_audit_tbl;
226:
227: else

Line 229: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;

225: x_action_line_audit_tbl := PA_PROJ_STAT_ACTSET.g_action_line_audit_tbl;
226:
227: else
228: if nvl(l_msg_count,0) > 0 then
229: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED ;
230: end if;
231: end if;
232:
233:

Line 241: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;

237: EXCEPTION
238: WHEN OTHERS THEN
239: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.perform_action_set_line'
240: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
241: x_action_line_result_code := pa_action_set_utils.G_NOT_PERFORMED;
242: RAISE;
243:
244: END perform_action_set_line;
245:

Line 307: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

303:
304: FUNCTION ok_to_perform_action (
305: p_report_date IN pa_object_page_layouts.next_reporting_date%TYPE
306: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
307: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
308: ) return BOOLEAN
309: IS
310: l_condition_date DATE := TRUNC(sysdate);
311: l_days NUMBER := 0;

Line 325: if (pa_action_set_utils.get_last_performed_date

321: end if;
322: l_condition_date := TRUNC(p_report_date) + l_days;
323:
324: if (l_condition_date = TRUNC(SYSDATE)) then
325: if (pa_action_set_utils.get_last_performed_date
326: (p_action_set_line_rec.action_set_line_id) = TRUNC(sysdate)) then
327: return FALSE;
328: else
329: return TRUE;

Line 340: p_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type) return BOOLEAN

336:
337:
338:
339: FUNCTION is_action_repeating(
340: p_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type) return BOOLEAN
341: IS
342: BEGIN
343: --if (p_action_line_conditions_tbl(1).condition_attribute2 is NULL ) then
344: -- return FALSE;

Line 354: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

350:
351: PROCEDURE validate_action_set_line (
352: p_action_set_type_code IN VARCHAR2 := 'PA_PROJ_STATUS_REPORT'
353: , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
354: , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
355: , x_return_status OUT NOCOPY VARCHAR2
356: ) IS
357:
358: BEGIN

Line 379: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type

375: ,p_report_type_id IN NUMBER
376: ,p_layout_id IN NUMBER
377: ,p_action_set_type_code IN VARCHAR2
378: ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
379: ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
380: ,x_action_performed OUT NOCOPY VARCHAR2
381: ,x_return_status OUT NOCOPY VARCHAR2
382: ,x_msg_count OUT NOCOPY NUMBER
383: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 390: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;

386: l_return_status VARCHAR2(1) := 'S';
387: l_msg_count NUMBER := 0;
388: l_msg_data VARCHAR2(2000);
389: l_sysdate DATE := TRUNC(sysdate);
390: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
391: l_cnt NUMBER := 0;
392:
393: BEGIN
394: /*Currently we are passing PA_OBJECT_PAGE_LAYOUT as object type so the

Line 453: ,pa_action_set_utils.get_action_set_id

449: AND lt.object_id = p_project_id_from --c_proj_id_from
450: AND ast.object_id = lt.object_page_layout_id;
451: */
452: SELECT lt.object_page_layout_id object_page_layout_id
453: ,pa_action_set_utils.get_action_set_id
454: ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) action_set_id
455: ,lt.report_type_id report_type_id
456: FROM pa_object_page_layouts lt
457: WHERE lt.page_type_code = 'PPR'

Line 459: and pa_action_set_utils.get_action_set_id

455: ,lt.report_type_id report_type_id
456: FROM pa_object_page_layouts lt
457: WHERE lt.page_type_code = 'PPR'
458: AND lt.object_id = p_project_id_from
459: and pa_action_set_utils.get_action_set_id
460: ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) is not null;
461:
462:
463: Cursor c_new_proj_layout_ids(c_proj_id_to NUMBER, rep_type_id NUMBER)

Line 576: l_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code

572: l_action_set_id := p_action_set_id;
573: l_record_version_number := p_record_version_number;
574:
575: IF l_action_set_id is NULL THEN
576: l_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code
577: ,p_object_type
578: ,p_object_id);
579: END IF;
580:

Line 662: l_curr_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code

658: ,x_Log_Level => 6);
659:
660: x_return_status := 'S';
661: --l_record_version_number := p_record_version_number;
662: l_curr_action_set_id := pa_action_set_utils.get_action_set_id(p_action_set_type_code
663: ,p_object_type
664: ,p_object_id);
665:
666: IF l_curr_action_set_id is NOT NULL THEN