Automatic created events; unable to put them on hold
We are creating automatic events, by directly inserting them into the events table. I am not able to put those events on hold. any ideas??
Here is the code:
PROCEDURE create_events(
p_exp_rec projordrec)
IS
l_event_id NUMBER;
l_event_type VARCHAR2(20);
l_task_org NUMBER;
g_user_id CONSTANT NUMBER := fnd_global.user_id;
g_login_id CONSTANT NUMBER := fnd_global.login_id;
g_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
g_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
l_user_id NUMBER;
l_responsibility_id NUMBER;
l_return_status VARCHAR2 (1);
Here is the code:
PROCEDURE create_events(
p_exp_rec projordrec)
IS
l_event_id NUMBER;
l_event_type VARCHAR2(20);
l_task_org NUMBER;
g_user_id CONSTANT NUMBER := fnd_global.user_id;
g_login_id CONSTANT NUMBER := fnd_global.login_id;
g_program_application_id CONSTANT NUMBER := fnd_global.prog_appl_id;
g_program_id CONSTANT NUMBER := fnd_global.conc_program_id;
l_user_id NUMBER;
l_responsibility_id NUMBER;
l_return_status VARCHAR2 (1);
0