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.HXC_FIND_NOTIFY_APRS_PKG dependencies on FND_GLOBAL

Line 1477: l_dyn_sql := 'BEGIN '|| fnd_global.newline

1473: if(l_project_id is not null) then
1474:
1475: --find project manager id
1476:
1477: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1478: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1479: ||'(p_project_id => :2);' ||fnd_global.newline
1480: ||'END;';
1481:

Line 1478: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline

1474:
1475: --find project manager id
1476:
1477: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1478: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1479: ||'(p_project_id => :2);' ||fnd_global.newline
1480: ||'END;';
1481:
1482: EXECUTE IMMEDIATE l_dyn_sql

Line 1479: ||'(p_project_id => :2);' ||fnd_global.newline

1475: --find project manager id
1476:
1477: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1478: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1479: ||'(p_project_id => :2);' ||fnd_global.newline
1480: ||'END;';
1481:
1482: EXECUTE IMMEDIATE l_dyn_sql
1483: using OUT l_project_manager, IN l_project_id;

Line 2221: l_func_sql := 'BEGIN '||fnd_global.newline

2217: ,p_time_recipient_id => p_time_recipient);
2218:
2219:
2220:
2221: l_func_sql := 'BEGIN '||fnd_global.newline
2222: ||p_ext_func2 ||fnd_global.newline
2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2224: ||',x_approver_person_id => :2' ||fnd_global.newline
2225: ||',x_messages => :3);' ||fnd_global.newline

Line 2222: ||p_ext_func2 ||fnd_global.newline

2218:
2219:
2220:
2221: l_func_sql := 'BEGIN '||fnd_global.newline
2222: ||p_ext_func2 ||fnd_global.newline
2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2224: ||',x_approver_person_id => :2' ||fnd_global.newline
2225: ||',x_messages => :3);' ||fnd_global.newline
2226: ||'END;';

Line 2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline

2219:
2220:
2221: l_func_sql := 'BEGIN '||fnd_global.newline
2222: ||p_ext_func2 ||fnd_global.newline
2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2224: ||',x_approver_person_id => :2' ||fnd_global.newline
2225: ||',x_messages => :3);' ||fnd_global.newline
2226: ||'END;';
2227:

Line 2224: ||',x_approver_person_id => :2' ||fnd_global.newline

2220:
2221: l_func_sql := 'BEGIN '||fnd_global.newline
2222: ||p_ext_func2 ||fnd_global.newline
2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2224: ||',x_approver_person_id => :2' ||fnd_global.newline
2225: ||',x_messages => :3);' ||fnd_global.newline
2226: ||'END;';
2227:
2228: EXECUTE IMMEDIATE l_func_sql

Line 2225: ||',x_messages => :3);' ||fnd_global.newline

2221: l_func_sql := 'BEGIN '||fnd_global.newline
2222: ||p_ext_func2 ||fnd_global.newline
2223: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2224: ||',x_approver_person_id => :2' ||fnd_global.newline
2225: ||',x_messages => :3);' ||fnd_global.newline
2226: ||'END;';
2227:
2228: EXECUTE IMMEDIATE l_func_sql
2229: using IN OUT l_previous_approver_id,