48: l_source_object_type_code,
49: l_task_id,
50: l_task_template_id,
51: l_task_template_group_id,
52: fnd_global.user_id,
53: SYSDATE,
54: fnd_global.user_id,
55: SYSDATE,
56: fnd_global.login_id);
50: l_task_template_id,
51: l_task_template_group_id,
52: fnd_global.user_id,
53: SYSDATE,
54: fnd_global.user_id,
55: SYSDATE,
56: fnd_global.login_id);
57: IF (fnd_api.to_boolean (p_commit)) THEN
58: COMMIT WORK;
52: fnd_global.user_id,
53: SYSDATE,
54: fnd_global.user_id,
55: SYSDATE,
56: fnd_global.login_id);
57: IF (fnd_api.to_boolean (p_commit)) THEN
58: COMMIT WORK;
59: END IF;
60: EXCEPTION
113: -- call table handler to insert into as_sales_methodology_b
114: UPDATE AS_SALES_METH_TASK_MAP SET
115: sales_methodology_id = l_sales_methodology_id,
116: task_template_id = l_task_template_id,
117: last_updated_by = fnd_global.user_id,
118: last_update_date = SYSDATE ,
119: last_update_login = fnd_global.login_id
120: WHERE object_id = l_source_object_id
121: AND sales_stage_id = l_sales_stage_id
115: sales_methodology_id = l_sales_methodology_id,
116: task_template_id = l_task_template_id,
117: last_updated_by = fnd_global.user_id,
118: last_update_date = SYSDATE ,
119: last_update_login = fnd_global.login_id
120: WHERE object_id = l_source_object_id
121: AND sales_stage_id = l_sales_stage_id
122: AND task_template_group_id = l_task_template_group_id ;
123: IF (SQL%NOTFOUND) THEN