415: THEN 'Y'
416: ELSE CASH_POSTED_FLAG
417: END
418: -- bug 10101613
419: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
420: ,LAST_UPDATE_DATE = SYSDATE
421: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
422: WHERE Accounting_Event_ID = l_event_list(num);
423:
417: END
418: -- bug 10101613
419: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
420: ,LAST_UPDATE_DATE = SYSDATE
421: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
422: WHERE Accounting_Event_ID = l_event_list(num);
423:
424: FORALL num in 1 .. l_event_list.COUNT
425: UPDATE ap_prepay_history_all
429: THEN 'Y'
430: ELSE 'N' -- bug 9464912
431: END
432: -- bug 10101613
433: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
434: ,LAST_UPDATE_DATE = SYSDATE
435: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
436: WHERE Accounting_Event_ID = l_event_list(num);
437:
431: END
432: -- bug 10101613
433: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
434: ,LAST_UPDATE_DATE = SYSDATE
435: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
436: WHERE Accounting_Event_ID = l_event_list(num);
437:
438: l_event_list.DELETE;
439: l_event_status_list.DELETE;
646: l_event_status_list(num) = 'N' THEN 'Y'
647: ELSE 'N'
648: END
649: -- bug 10101613
650: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
651: ,LAST_UPDATE_DATE = SYSDATE
652: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
653: WHERE Accounting_Event_ID = l_event_list(num);
654:
648: END
649: -- bug 10101613
650: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
651: ,LAST_UPDATE_DATE = SYSDATE
652: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
653: WHERE Accounting_Event_ID = l_event_list(num);
654:
655: FORALL num in 1 .. l_event_list.COUNT
656: UPDATE AP_payment_history_all APH
663: l_event_status_list(num) = 'N' THEN 'Y'
664: ELSE 'N'
665: END
666: -- bug 10101613
667: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
668: ,LAST_UPDATE_DATE = SYSDATE
669: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
670: WHERE APH.Accounting_Event_ID = l_event_list(num);
671:
665: END
666: -- bug 10101613
667: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
668: ,LAST_UPDATE_DATE = SYSDATE
669: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
670: WHERE APH.Accounting_Event_ID = l_event_list(num);
671:
672: l_event_list.DELETE;
673: l_event_status_list.DELETE;