544: status = DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED',
545: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
546: 'FINAL CLOSE' ,'CLOSED'),
547: last_update_date = sysdate,
548: last_updated_by = fnd_global.user_id,
549: last_update_login = fnd_global.login_id
550: WHERE document_type = lv_doc_type
551: AND distribution_id = p_dist_id_tbl(i);
552:
545: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
546: 'FINAL CLOSE' ,'CLOSED'),
547: last_update_date = sysdate,
548: last_updated_by = fnd_global.user_id,
549: last_update_login = fnd_global.login_id
550: WHERE document_type = lv_doc_type
551: AND distribution_id = p_dist_id_tbl(i);
552:
553: ELSE
582: DECODE(p_action,PO_CONSTANTS_SV.RESERVE,'RESERVED' ,
583: PO_CONSTANTS_SV.CANCEL ,'CANCELLED',
584: 'FINAL CLOSE' ,'CLOSED') ,
585: sysdate ,
586: fnd_global.user_id ,
587: sysdate ,
588: fnd_global.user_id ,
589: fnd_global.login_id ,
590: NULL
584: 'FINAL CLOSE' ,'CLOSED') ,
585: sysdate ,
586: fnd_global.user_id ,
587: sysdate ,
588: fnd_global.user_id ,
589: fnd_global.login_id ,
590: NULL
591: );
592:
585: sysdate ,
586: fnd_global.user_id ,
587: sysdate ,
588: fnd_global.user_id ,
589: fnd_global.login_id ,
590: NULL
591: );
592:
593: END IF;
695: p_source_doc_type ,
696: p_nr_tax_amount ,
697: 0 ,
698: SYSDATE ,
699: fnd_global.user_id ,
700: SYSDATE ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: NULL
697: 0 ,
698: SYSDATE ,
699: fnd_global.user_id ,
700: SYSDATE ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: NULL
704: );
705:
698: SYSDATE ,
699: fnd_global.user_id ,
700: SYSDATE ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: NULL
704: );
705:
706: EXCEPTION