212: c.error,
213: c.approved_without_check,
214: c.Reason,
215: SYSDATE,
216: Fnd_Global.User_Id,
217: SYSDATE,
218: Fnd_Global.User_Id,
219: Fnd_Global.Login_Id
220: );
214: c.Reason,
215: SYSDATE,
216: Fnd_Global.User_Id,
217: SYSDATE,
218: Fnd_Global.User_Id,
219: Fnd_Global.Login_Id
220: );
221:
222: END LOOP;
215: SYSDATE,
216: Fnd_Global.User_Id,
217: SYSDATE,
218: Fnd_Global.User_Id,
219: Fnd_Global.Login_Id
220: );
221:
222: END LOOP;
223:
327: c.error,
328: c.approved_without_check,
329: c.Reason,
330: SYSDATE,
331: Fnd_Global.User_Id,
332: SYSDATE,
333: Fnd_Global.User_Id,
334: Fnd_Global.Login_Id
335: );
329: c.Reason,
330: SYSDATE,
331: Fnd_Global.User_Id,
332: SYSDATE,
333: Fnd_Global.User_Id,
334: Fnd_Global.Login_Id
335: );
336:
337: END LOOP;
330: SYSDATE,
331: Fnd_Global.User_Id,
332: SYSDATE,
333: Fnd_Global.User_Id,
334: Fnd_Global.Login_Id
335: );
336:
337: END LOOP;
338:
383: c.error,
384: c.approved_without_check,
385: c.Reason,
386: SYSDATE,
387: Fnd_Global.User_Id,
388: SYSDATE,
389: Fnd_Global.User_Id,
390: Fnd_Global.Login_Id
391: );
385: c.Reason,
386: SYSDATE,
387: Fnd_Global.User_Id,
388: SYSDATE,
389: Fnd_Global.User_Id,
390: Fnd_Global.Login_Id
391: );
392:
393: END LOOP;
386: SYSDATE,
387: Fnd_Global.User_Id,
388: SYSDATE,
389: Fnd_Global.User_Id,
390: Fnd_Global.Login_Id
391: );
392:
393: END LOOP;
394:
807:
808: UPDATE po_vendor_eligibility
809: SET eligibility_status = l_lookup_code,
810: received_date = SYSDATE,
811: performed_by = Fnd_Global.User_Id,
812: file_id_request = l_fnd_lob_seq,
813: last_update_date = SYSDATE,
814: last_updated_by = Fnd_Global.User_Id,
815: last_update_login = Fnd_Global.Login_Id,
810: received_date = SYSDATE,
811: performed_by = Fnd_Global.User_Id,
812: file_id_request = l_fnd_lob_seq,
813: last_update_date = SYSDATE,
814: last_updated_by = Fnd_Global.User_Id,
815: last_update_login = Fnd_Global.Login_Id,
816: select_flag = 'N'
817: WHERE id = c.id;
818:
811: performed_by = Fnd_Global.User_Id,
812: file_id_request = l_fnd_lob_seq,
813: last_update_date = SYSDATE,
814: last_updated_by = Fnd_Global.User_Id,
815: last_update_login = Fnd_Global.Login_Id,
816: select_flag = 'N'
817: WHERE id = c.id;
818:
819: OPEN get_error(c.id);
1082:
1083: UPDATE po_vendor_eligibility
1084: SET eligibility_status = l_lookup_code,
1085: received_date = SYSDATE,
1086: -- performed_by = Fnd_Global.User_Id,
1087: last_update_date = SYSDATE,
1088: -- last_updated_by = Fnd_Global.User_Id,
1089: -- last_update_login = Fnd_Global.Login_Id,
1090: select_flag = 'N',
1084: SET eligibility_status = l_lookup_code,
1085: received_date = SYSDATE,
1086: -- performed_by = Fnd_Global.User_Id,
1087: last_update_date = SYSDATE,
1088: -- last_updated_by = Fnd_Global.User_Id,
1089: -- last_update_login = Fnd_Global.Login_Id,
1090: select_flag = 'N',
1091: error = l_error_msg
1092: WHERE id = l_id;
1085: received_date = SYSDATE,
1086: -- performed_by = Fnd_Global.User_Id,
1087: last_update_date = SYSDATE,
1088: -- last_updated_by = Fnd_Global.User_Id,
1089: -- last_update_login = Fnd_Global.Login_Id,
1090: select_flag = 'N',
1091: error = l_error_msg
1092: WHERE id = l_id;
1093: COMMIT;