[Home] [Help]
341: (execution_id,audit_procedure_rev_id,last_update_date,
342: last_updated_by,creation_date,created_by,
343: last_update_login,executed_on,executed_by,
344: status,work_desc,execution_type,pk1,pk2,pk3,object_version_number)
345: values(amw_ap_executions_s.nextval,ap_details_rec.audit_procedure_rev_id,sysdate,
346: g_user_id,sysdate,g_user_id,
347: g_login_id,sysdate,v_emp_id,
348: ap_details_rec.ap_status,ap_details_rec.ap_work_description,
349: 'AP',ap_details_rec.audit_project_id,ap_details_rec.organization_id,
350: ap_details_rec.task_id,1);
351: commit;
352: else
353:
354: update amw_ap_executions set work_desc = ap_details_rec.ap_work_description,
355: status = ap_details_rec.ap_status,executed_by = v_emp_id,
356: executed_on = sysdate
357: where audit_procedure_rev_id = ap_details_rec.audit_procedure_rev_id
358: and pk1 = ap_details_rec.audit_project_id and pk2 = ap_details_rec.organization_id
409: (execution_id,audit_procedure_rev_id,ap_step_id,
410: last_update_date,last_updated_by,creation_date,created_by,
411: last_update_login,executed_on,executed_by,
412: status,work_desc,execution_type,pk1,pk2,pk3,object_version_number)
413: values(amw_ap_executions_s.nextval,step_details_rec.audit_procedure_rev_id,step_details_rec.step_id,
414: sysdate,g_user_id,sysdate,g_user_id,
415: g_login_id,sysdate,v_emp_id,
416: step_details_rec.step_status,step_details_rec.step_work_description,
417: 'STEP',step_details_rec.audit_project_id,step_details_rec.organization_id,
418: step_details_rec.task_id,1);
419: commit;
420: else
421:
422: update amw_ap_executions set work_desc = step_details_rec.step_work_description,
423: status = step_details_rec.step_status,executed_by = v_emp_id,
424: executed_on = sysdate
425: where audit_procedure_rev_id = step_details_rec.audit_procedure_rev_id
426: and pk1 = step_details_rec.audit_project_id and pk2 = step_details_rec.organization_id