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 1444: l_dyn_sql := 'BEGIN '|| fnd_global.newline

1440: if(l_project_id is not null) then
1441:
1442: --find project manager id
1443:
1444: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1445: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1446: ||'(p_project_id => :2);' ||fnd_global.newline
1447: ||'END;';
1448:

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

1441:
1442: --find project manager id
1443:
1444: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1445: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1446: ||'(p_project_id => :2);' ||fnd_global.newline
1447: ||'END;';
1448:
1449: EXECUTE IMMEDIATE l_dyn_sql

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

1442: --find project manager id
1443:
1444: l_dyn_sql := 'BEGIN '|| fnd_global.newline
1445: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
1446: ||'(p_project_id => :2);' ||fnd_global.newline
1447: ||'END;';
1448:
1449: EXECUTE IMMEDIATE l_dyn_sql
1450: using OUT l_project_manager, IN l_project_id;

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

2076: ,p_time_recipient_id => p_time_recipient);
2077:
2078:
2079:
2080: l_func_sql := 'BEGIN '||fnd_global.newline
2081: ||p_ext_func2 ||fnd_global.newline
2082: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2083: ||',x_approver_person_id => :2' ||fnd_global.newline
2084: ||',x_messages => :3);' ||fnd_global.newline

Line 2081: ||p_ext_func2 ||fnd_global.newline

2077:
2078:
2079:
2080: l_func_sql := 'BEGIN '||fnd_global.newline
2081: ||p_ext_func2 ||fnd_global.newline
2082: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2083: ||',x_approver_person_id => :2' ||fnd_global.newline
2084: ||',x_messages => :3);' ||fnd_global.newline
2085: ||'END;';

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

2078:
2079:
2080: l_func_sql := 'BEGIN '||fnd_global.newline
2081: ||p_ext_func2 ||fnd_global.newline
2082: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2083: ||',x_approver_person_id => :2' ||fnd_global.newline
2084: ||',x_messages => :3);' ||fnd_global.newline
2085: ||'END;';
2086:

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

2079:
2080: l_func_sql := 'BEGIN '||fnd_global.newline
2081: ||p_ext_func2 ||fnd_global.newline
2082: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2083: ||',x_approver_person_id => :2' ||fnd_global.newline
2084: ||',x_messages => :3);' ||fnd_global.newline
2085: ||'END;';
2086:
2087: EXECUTE IMMEDIATE l_func_sql

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

2080: l_func_sql := 'BEGIN '||fnd_global.newline
2081: ||p_ext_func2 ||fnd_global.newline
2082: ||'(p_previous_approver_id => :1' ||fnd_global.newline
2083: ||',x_approver_person_id => :2' ||fnd_global.newline
2084: ||',x_messages => :3);' ||fnd_global.newline
2085: ||'END;';
2086:
2087: EXECUTE IMMEDIATE l_func_sql
2088: using IN OUT l_previous_approver_id,