1053: END IF;
1054: /*
1055:
1056: Bug: 3205338: If the approver id is -1,
1057: i.e. fnd_global.employee_id is
1058:
1059: */
1060:
1061: l_is_blank := wf_engine.GetItemAttrText(itemtype => itemtype,
4448: if g_debug then
4449: hr_utility.set_location(l_proc, 60);
4450: end if;
4451: --
4452: l_func_sql := 'BEGIN '||fnd_global.newline
4453: ||l_ext_func1 ||fnd_global.newline
4454: ||'(x_autoapproval_flag => :1' ||fnd_global.newline
4455: ||',x_messages => :2);' ||fnd_global.newline
4456: ||'END;';
4449: hr_utility.set_location(l_proc, 60);
4450: end if;
4451: --
4452: l_func_sql := 'BEGIN '||fnd_global.newline
4453: ||l_ext_func1 ||fnd_global.newline
4454: ||'(x_autoapproval_flag => :1' ||fnd_global.newline
4455: ||',x_messages => :2);' ||fnd_global.newline
4456: ||'END;';
4457: --
4450: end if;
4451: --
4452: l_func_sql := 'BEGIN '||fnd_global.newline
4453: ||l_ext_func1 ||fnd_global.newline
4454: ||'(x_autoapproval_flag => :1' ||fnd_global.newline
4455: ||',x_messages => :2);' ||fnd_global.newline
4456: ||'END;';
4457: --
4458: EXECUTE IMMEDIATE l_func_sql
4451: --
4452: l_func_sql := 'BEGIN '||fnd_global.newline
4453: ||l_ext_func1 ||fnd_global.newline
4454: ||'(x_autoapproval_flag => :1' ||fnd_global.newline
4455: ||',x_messages => :2);' ||fnd_global.newline
4456: ||'END;';
4457: --
4458: EXECUTE IMMEDIATE l_func_sql
4459: using IN OUT l_auto_approval_flag,