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:
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
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;