3518: open get_payrun_id_curs;
3519: fetch get_payrun_id_curs into l_payrun_id, l_org_id,l_obj;
3520: close get_payrun_id_curs;
3521:
3522: cn_message_pkg.begin_batch
3523: ( x_process_type => 'DPRUN',
3524: x_process_audit_id => l_proc_audit_id,
3525: x_parent_proc_audit_id => l_proc_audit_id,
3526: x_request_id => NULL,
3527: --R12
3528: p_org_id => l_org_id
3529: );
3530:
3531: cn_message_pkg.debug('***************************************************');
3532: cn_message_pkg.debug('Delete Payrun');
3533:
3534: --call the create worksheet api
3535: CN_Payrun_PVT.delete_payrun
3528: p_org_id => l_org_id
3529: );
3530:
3531: cn_message_pkg.debug('***************************************************');
3532: cn_message_pkg.debug('Delete Payrun');
3533:
3534: --call the create worksheet api
3535: CN_Payrun_PVT.delete_payrun
3536: (p_api_version => 1.0,
3549: THEN
3550: retcode := 2;
3551: errbuf := FND_MSG_PUB.get(p_msg_index => fnd_msg_pub.G_LAST,
3552: p_encoded => FND_API.G_FALSE);
3553: cn_message_pkg.debug('Error for delete payrun : '||errbuf);
3554: ELSE
3555: COMMIT;
3556: END IF;
3557: