APPS.HXC_PROJ_MANAGER_APPROVAL_PKG dependencies on FND_GLOBAL

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

116: l_approval_mechanism := 'PERSON';
117:
118: /* get the Manager id of the project */
119:
120: l_dyn_sql := 'BEGIN '|| fnd_global.newline
121: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
122: ||'(p_project_id => :2);' ||fnd_global.newline
123: ||'END;';
124:

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

117:
118: /* get the Manager id of the project */
119:
120: l_dyn_sql := 'BEGIN '|| fnd_global.newline
121: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
122: ||'(p_project_id => :2);' ||fnd_global.newline
123: ||'END;';
124:
125: EXECUTE IMMEDIATE l_dyn_sql

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

118: /* get the Manager id of the project */
119:
120: l_dyn_sql := 'BEGIN '|| fnd_global.newline
121: || ':1 := Pa_Otc_Api.GetProjectManager' ||fnd_global.newline
122: ||'(p_project_id => :2);' ||fnd_global.newline
123: ||'END;';
124:
125: EXECUTE IMMEDIATE l_dyn_sql
126: using OUT l_manager_id, IN l_project_id;