454: status = DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED',
455: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
456: 'FINAL CLOSE' ,'CLOSED'),
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,
459: last_update_login = fnd_global.login_id
460: WHERE document_type = lv_doc_type
461: AND distribution_id = p_dist_id_tbl(i);
462:
455: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
456: 'FINAL CLOSE' ,'CLOSED'),
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,
459: last_update_login = fnd_global.login_id
460: WHERE document_type = lv_doc_type
461: AND distribution_id = p_dist_id_tbl(i);
462:
463: ELSE
490: ln_doc_curr_tax_amt ,
491: ln_func_curr_tax_amt ,
492: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,PO_CONSTANTS_SV.CANCEL ,'CANCELLED','FINAL CLOSE' ,'CLOSED') ,
493: sysdate ,
494: fnd_global.user_id ,
495: sysdate ,
496: fnd_global.user_id ,
497: fnd_global.login_id ,
498: NULL
492: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,PO_CONSTANTS_SV.CANCEL ,'CANCELLED','FINAL CLOSE' ,'CLOSED') ,
493: sysdate ,
494: fnd_global.user_id ,
495: sysdate ,
496: fnd_global.user_id ,
497: fnd_global.login_id ,
498: NULL
499: );
500:
493: sysdate ,
494: fnd_global.user_id ,
495: sysdate ,
496: fnd_global.user_id ,
497: fnd_global.login_id ,
498: NULL
499: );
500:
501: END IF;
603: p_source_doc_type ,
604: p_nr_tax_amount ,
605: 0 ,
606: SYSDATE ,
607: fnd_global.user_id ,
608: SYSDATE ,
609: fnd_global.user_id ,
610: fnd_global.login_id ,
611: NULL
605: 0 ,
606: SYSDATE ,
607: fnd_global.user_id ,
608: SYSDATE ,
609: fnd_global.user_id ,
610: fnd_global.login_id ,
611: NULL
612: );
613:
606: SYSDATE ,
607: fnd_global.user_id ,
608: SYSDATE ,
609: fnd_global.user_id ,
610: fnd_global.login_id ,
611: NULL
612: );
613:
614: EXCEPTION