[Home] [Help]
885: l_ProgramId number;
886: l_ApplicationId number;
887: l_ProgramUpdate date;
888: cursor l_NewOper_csr is
889: Select bom_operation_sequences_s.nextval new_op_seq_id
890: from dual;
891: BEGIN
892: -- Standard Start of API savepoint
893: SAVEPOINT CreateOperation_Pvt;
1626: Else
1627: l_ProgramUpdate := sysdate;
1628: End if;
1629:
1630: update bom_operation_sequences set
1631: operation_seq_num = l_operation_rec.new_operation_seq_num,
1632: last_update_date = sysdate,
1633: last_updated_by = l_UserId,
1634: creation_date = sysdate,